Oracle Database 12c: Introduction for Experienced SQL Users

Oracle Database 12c: Introduction for Experienced SQL Users Certification Training Course Overview

New version Oracle Database 12c: Introduction for Experienced SQL Users is now available.

This Oracle Database 12c: Introduction for Experienced SQL Users training course will teach you about Oracle Database 12c, the database environment and the Oracle SQL Developer tool. It will also give you an overview on how to create and manage tables, synonyms, sequences, indexes and views, fundamental database security features.

Who Should do this course?

  • Application Developers
  • Data Warehouse Developer
  • Database Administrators
  • Developer

Oracle Database 12c: Introduction for Experienced SQL Users (16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2200
02 - 03 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 07 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 2550
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Customers who bought this course also bought

• New version Oracle Database 12c: Introduction for Experienced SQL Users is now available.
• Oracle BPM 12c: Essentials Ed 1
• Oracle Database 12c: Admin, Install and Upgrade Accelerated
• Oracle Database 12c: Advanced PL/SQL
• Oracle Database: Managing Multitenant Architecture Ed 1
• Oracle Database 12c R2: SQL Tuning for Developers Ed 2
• Oracle Database 19C:Administration Workshop
• Oracle Database: Backup and Recovery Workshop
• Oracle Database: Introduction to SQL
• Oracle HCM Cloud: US Payroll
• Oracle WebLogic Server 12c: Administration I Ed 3

Course Modules

Module 1: Course Overview
  • Course Objectives, Course Agenda and Class Account Information
  • Describe the Human Resources (HR) Schema
  • Identify the Appendices Used in this Course
Module 2: Understanding the Oracle Database Environment
  • Understanding the Oracle Database Environment
  • Understanding the Oracle Instance
  • Processing a SQL Statement
  • Understanding Data Flow During SQL Statement Processing
  • Understanding Read Consistency
Module 3: Using SQL Developer
  • SQL Developer
Module 4: Getting Started with Oracle SQL
  • Basic SQL statements
  • How Oracle SQL treats NULLs
  • Using Pseudocolumns
  • Using Operators, Expressions and Functions
  • Understanding Data Types and Date Format
Module 5: Combining Tables by Using Advanced Queries
  • Subqueries
  • Update and delete rows by using correlated subqueries
  • Perform joins in Oracle SQL
  • Create a tree-structured report
  • Exclude branches from the tree structure
Module 6: Creating and Managing Tables
  • Using CREATE, ALTER, DROP, RENAME, COMMENT, and TRUNCATE statement
  • Create and maintain integrity constraints
  • Use the data dictionary to view and maintain information about tables
Module 7: Creating and Managing Other Oracle Database Objects
  • Create and maintain indexes
  • Create and maintain a view
  • Create, maintain, and use sequences
  • Create private and public synonyms
Module 8: Oracle Database Extensions to DML and DDL Statements
  • Describe the features of multitable INSERT statements
  • Merge rows by using the MERGE statement
  • Create and use external tables
  • Describe transaction processing
Module 9: Controlling User Access
  • Discuss the concepts of users, roles, and privileges
  • Create users
  • Create roles
  • Grant and revoke object privileges
  • Create and access database links
Download Course Contents

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.

On Completion of this course you will be able to:-

  • Describe the Oracle database environment.
  • Use various features of Oracle SQL Developer.
  • Describe and work with the basic elements of Oracle SQL.
  • Become familiar with fundamental database security features.
  • Combine tables using joins and subqueries.
  • Create and manage tables, synonyms, sequences, indexes and views.
  • Implement database security by granting privileges and creating roles.

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database 12c: Introduction for Experienced SQL Users Ed 1 Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

FAQ's