Oracle Database 12c: Administrator(SQL):

Oracle Database 12c is designed to teach you the fundamentals of SQL using Oracle Database 12c database technology. Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated.

Course Objective:


Develop essential SQL skills that enable developers to write queries against single and multiple tables.
Manipulate data in tables.
Create database objects.
Use single row functions to customize output.
Work with group functions to report aggregated data.
Use conversion functions and conditional expressions.
Manipulate queries to return required data.
Perform calculations on data.
Administer database objects.

Oracle Database 12c: Administrator(Workshop 1):

This Oracle Database 12c Release 2 : Administration Workshop 1 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands - on practices that will prepare you for the corresponding Oracle Certified Associate exam.

Course Objective:


Install Oracle Grid Infrastructure.
Create and manage users.
Install and configure an Oracle Database.
Create and manage storage structures.
Administer the Oracle Database.
Understand the Oracle database architecture and how its components work and interact with one another.
Perform backup and recovery.

Oracle Database 12c: Administrator(Workshop 2):

This Oracle Database 12c Release 2 : Administration Workshop 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Course Objective:


Diagnose and repair data failures with Flashback technology.
Manage space to optimize database storage so you can respond to growing space requirement.
Monitor and manage major database components, including memory, performance and resources.
Secure the availability of your database through appropriate backup and recovery strategies.
Automate DBA tasks with the Scheduler.
Understand the Oracle database architecture and how its components work and interact with one another.
Perform backup and recovery.