The Weblearning Oracle Database Administration and Development course combines Oracle Database Administration and SQL/PLSQL development courses into a single solution for students wanting to start a highly rewarding career in Database administration and development.

Oracle is a relational database management systems whose primary function is to store and retrieve data. Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerised databases in today’s organisations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers.

All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, DB2, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today.

As a database developer you will be working closely with database administrators and business analysts to capture business requirements and implement them using Oracle SQL - gain a working knowledge of queries , insert, update and delete SQL statements as well as some Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization.

In addition you will also gain a working knowledge of the PL/SQL Procedural programming languages; ensuring performance, reliability and security.

Audience:

Database Developers

Database Designers

Database Administrators (DBAs)

Development DBAs

DB Architects 

DB Analysts

prerequisites:

Some Knowledge of relational server technology

Familiariry with SQL or Database Management Systems

Course Objectives:

Understand Oracle Database Tools

Learn  Data Definition Lanaguage - DDL

Learn Data Manipulation Language - DML

Learn Data Control Language - DCL

Configure Oracle Net Services

Describe Oracle Database Architecture

Manage the Oracle Database Instance

Manage Database Storage structures

Create and Administer User Accounts

Monitor the Database

Manage Database Performance

Understanding The Oracle Optimizer

Implement Database Auditing

Configure the Database Instance

Configure and create a CDB

Create a new PDB from the CDB seed

Explore the structure of PDBs

Schedule Jobs to Run Inside or Outside of the Database

Configure your Database For Backup and Recovery Operations

Certification: Oracle Database Certified Professional:

Based on the latest Oracle database, the internationally recognised Oracle Database 12c Certified Associate qualification will instill in the student the essential skills and knowledge needed to develop and maintain Oracle Database 12c environments. Upon achieving this certification you will have gained the ability to work in numerous database environments.

Oracle Database Certified Associate :

Part I: – Oracle® Database: SQL Fundamentals - Exam - 1Z0-071 

II: Oracle Database: Certified Professional - PL/SQL Programming - 1Z0-149

Part III: – Oracle® Database: Administration - Exam - 1Z0-071 and 1Z0-083

Oracle Database Certified Associate:

The Oracle Database Certified Associate courses will provide you with the most recent skills and knowledge that is required to develop and maintain Oracle 12c and 19c environments. The Oracle OCA qualification will enable you to secure and maintain data, import, export and compress data, as well as monitor, troubleshoot and optimise databases.

The Oracle Database Certified Associate certification is also a prerequisite to certain OCP (Oracle Certified Professional) courses, opening up another dimension of career opportunities.

Course Outline:

I: Oracle Database: Certified Associate - SQL Fundamentals  - Certified Associate - 1Z0-071

Oracle and Structured Query Language (SQL) 

Restricting and Sorting Data 

Using Single-Row Functions to Customize Output 

Using Conversion Functions and Conditional Expressions 

Reporting Aggregated Data Using the Group Functions 

Displaying Data from Multiple Tables 

Using Subqueries to Solve Queries 

Using the Set Operators 

Manipulating Data 

Using DDL Statements to Create and Manage Tables 

Managing Objects with Data Dictionary Views 

Controlling User Access 

Managing Schema Objects 

Manipulating Large Data Sets

II: Oracle Database: Certified Professional - PL/SQL Programming - 1Z0-149

Introduction to PL/SQL Programming 

PL/SQL Blocks        

Creating an Anonymous Block       

Using Triggers          

Creating a DML Trigger      

Using Procedures and Functions   

Creating a Procedure          

Creating a Function 

Handling Exceptions

Creating  Exceptions           

PL/SQL packages   

Creating a Package

II: Oracle Database Administration I Certified Associate - 1Z0-082

Basics of the Oracle® Database Architecture 

Oracle® Server Architecture 

Shared Memory Areas 

Universal Installer 

Managing an Oracle® Instance 

Oracle® Managed Files 

Server Side Parameter File 

Oracle® Data Dictionary 

Control Files 

Redo Log Files 

Managing the Physical Database Structure 

Managing Tablespaces and Datafiles 

Temporary Segments 

Storage Structures and Undo Data 

Block Utilization 

Undo Space Management 

Managing Database Objects 

Indexes 

Integrity Constraints 

Managing Database Users 

System Privileges 

Object Privileges 

Roles 

    

NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY E-LEARNING, TRAINING GUIDE OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, E-LEARNING OR TRAINING GUIDE LEARNING  FORMATS.PRICES DIFFER

What is a CBT?

CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBT Titles do NOT have voice..

Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Courseware Learning formats are delivered with FULL LICENCE KEY.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

The WebLearning unique Methodology

All WebLearning® CBT and Courseware courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: A NEW, very effective and proven way of learning. 

FACT:

·        Material retention with CBT’S are 45% better than with conventional training methods

·        Your learning curve with CBT is 25%-55% less than conventional methods

·        The cost of CBT training is over 65% less than Classroom training

·        CBT’S are self pacing, interactive and simulate the actual software being studied