Oracle Courses

Oracle 12c Training

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.

Duration

  • Weekdays – 4 Months
  • Weekends – 6 Months

Target Audience

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 501 – Oracle Database: Introduction to SQL Ed 2

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.

Course Outline

  • Introduction
  • Working with Oracle Cloud Exadata Express Cloud Service
  • Retrieving Data using the SQL SELECT StatementRestricting 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
Register Now

Course 502 – Oracle Database 12c: Admin, Install and Upgrade Accelerated (OCA)

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.

Course Outline

  • Introduction
  • Exploring the Oracle Database Architecture
  • Oracle Software Installation Basics
  • Installing Oracle Database Software
  • Creating an Oracle Database by Using DBCA
  • Oracle Database Management Tools
  • Managing the Database Instance
  • Configuring the Oracle Network Environment
  • Administering User Security
  • Managing Database Storage Structures
  • Managing Space
  • Managing Undo Data
  • Managing Data Concurrency
  • Implementing Oracle Database Auditing
  • Backup and Recovery Concepts
  • Backup and Recovery Configuration
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Performing Database Maintenance
  • Managing Performance
  • Oracle Database Cloud Service: Overview
Register Now

Course 103 – Oracle Database 12c: Backup and Recovery Workshop Ed 2 (OCP)

This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You’ll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. In this course, you will be introduced to Oracle Database Cloud Service.

Course Outline

  • Introduction
  • Getting Started with the core concepts of the Oracle Database, Critical for Backup and Recovery
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Backup Strategies and Terminology
  • Performing Backups
  • Improving Your Backups
  • Using RMAN-Encrypted Backups
  • Diagnosing Database Failures
  • Restore and Recovery Concepts
  • Performing Recovery, Part 1
  • Performing Recovery, Part 2
  • RMAN and Oracle Secure Backup
  • Performing Tape Backups and Restores
  • Using Flashback Technologies
  • Using Flashback Database
  • Managing Backup Space or Transporting Data
  • Duplicating a Database
  • RMAN Performance and Tuning
Register Now