Oracle Database 12c: Introduction for Experienced SQL Users

Q: Is GST/ VAT applicable on the published fee?

No, the published fee includes all applicable taxes.

Overview Schedule & Fees Course Benefits Student Feedback FAQ Course Modules

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 08 - 09 Nov GTR 09:00 AM - 05:00 PM CST (8 Hours/Day) 06 - 07 Dec 09:00 AM - 05:00 PM CST (8 Hours/Day)	1-on-1 Training (GTR) 2550 4 Hours 8 Hours Week Days Weekend Start Time : At any time 12 AM 12 PM Training Schedule: GTR=Guaranteed to Run

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Customers who bought this course also bought

Oracle Database 12c: Introduction for Experienced SQL Users

Developing Applications for the Java EE 7 Platform Ed 1

MySQL for Database Administrators Ed5 Training Course

Oracle Database 19C:Administration Workshop Certification Training Course

R12.x Oracle General Ledger Management Fundamentals

10% discount on 2nd course:

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

Request a call back?

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.