Oracle Database 12c: Introduction for Experienced SQL Users

Download Course Contents

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

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

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

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
  • Understanding the Oracle Database Environment
  • Understanding the Oracle Instance
  • Processing a SQL Statement
  • Understanding Data Flow During SQL Statement Processing
  • Understanding Read Consistency
  • Basic SQL statements
  • How Oracle SQL treats NULLs
  • Using Pseudocolumns
  • Using Operators, Expressions and Functions
  • Understanding Data Types and Date Format
  • 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
  • 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
  • Create and maintain indexes
  • Create and maintain a view
  • Create, maintain, and use sequences
  • Create private and public synonyms
  • Describe the features of multitable INSERT statements
  • Merge rows by using the MERGE statement
  • Create and use external tables
  • Describe transaction processing
  • Discuss the concepts of users, roles, and privileges
  • Create users
  • Create roles
  • Grant and revoke object privileges
  • Create and access database links
Live Online Training (Duration : 16 Hours) Fee On Request
Group Training Incl. Official Courseware
06 - 07 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 05 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training Incl. Official Courseware
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 16 hours is too fast, we can offer Comfort Track for 32 hours

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.

Request More Information

Add Name and Email Address of participant (If different from you)