Oracle Database Management 12c (SQL, OCA, OCP)

This course offers a comprehensive introduction to Oracle Database 12c. You learn how to design, build and manage robust cloud based database applications with Oracle database tools. Oracle 12c is a large, complex system. This course provides an overview of the power and flexibility of Oracle databases and serves as the foundation for other courses in the Learning Tree Oracle Databases curriculum.

Course Description

Oracle Database 12c: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

This course will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 12c.

The Oracle Database 12c Administration Workshop II Release 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 such as performing backup and recovery, diagnosing and repairing data failures with Flashback technology etc

Who will benefit from this course? This course benefits a wide range of professionals, including:
  • Developers, analysts, administrators, managers, programmers, consultants, power users and others who design and write Oracle applications using Oracle 12c
  • Database administrators who want to become proficient in querying and manipulating an Oracle database
  • Data processing professionals with experience working in a traditional database system (hierarchical or network), who are now moving to a client/server or Web environment Technology managers and project leaders who need a general overview of Oracle 12c
Certificate Earned
  • Oracle Certified Associate (OCA), Oracle Certified Professional (OCP)
Career Prospects
  • Database Administrator, Data Analyst, IT manager, IT Consultants

Course Outline

Working with Oracle Cloud Exadata Express Cloud Service

  • Retrieving Data using the SQL SELECT Statement
  • 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 Joins
  • Using Subqueries to Solve Queries
  • Using the SET Operators
  • Managing Tables using DML statements
  • Introduction to Data Definition Language
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data
  • Managing Data in Different Time Zones


  • Weekdays: 4 Months
  • Weekends: 5 Months

For our IT services and solutions