Oracle Database 12c R2: Introduction to SQL Ed 2 Training

Live Online & Classroom Enterprise Certification Training

This Intro to SQL training teaches you basic concepts of relational databases and the SQL programming language. You'll gain essential SQL skills to write queries against single & multiple tables, manipulate data in tables & create database objects.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Introduction to SQL Ed 2 Certification Training about?

This 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.

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g, 11g and 12c audience.

Note: This course is a combination of Oracle Database 12c: SQL Workshop I and Oracle Database12c: SQL Workshop II courses.

What are the objectives of Introduction to SQL Ed 2 Certification Training ?

Identify the major structural components of the Oracle Database 12c
Manage objects with data dictionary views
Manage schema objects
Retrieve row and column data from tables
Run data manipulation statements (DML) in Oracle Database 12c
Use scalar and correlated sub-queries
Utilize views to display data
Write SELECT statements that include queries
Write multiple-column sub-queries
Control database access to specific objects
Create reports of aggregated data
Create reports of sorted and restricted data
Create tables to store data
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Employ SQL functions to retrieve customized dat

Who is Introduction to SQL Ed 2 Certification Training for?

Application Developers
System Analysts
Business Analysts
Forms Developer
Developer
Data Warehouse Administrator
PL/SQL Developer

What are the prerequisites for Introduction to SQL Ed 2 Certification Training?

Suggested Prerequisite

Familiarity with data processing concepts and techniques
Data processing

Available Training Modes

Live Online Training

40 Hours

Classroom Training

5 Days

Course Outline Expand All

Expand All

Introduction

Overview of Oracle Database 12c and Related Products

Introduction to SQL and its development environments

Course Objectives, Course Agenda and Appendixes Used in this Course

The Human Resource (HR) Schema

Overview of relational database management concepts and terminologies

What is Oracle SQL Developer?

Tables used in the Course

Starting SQL*Plus from Oracle SQL Developer

Retrieving Data using the SQL SELECT Statement

Column aliases

Use of the DESCRIBE command

Capabilities of the SELECT statement

Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

Arithmetic expressions and NULL values in the SELECT statement

Restricting and Sorting Data

Rules of precedence for operators in an expression

Limiting the Rows

Substitution Variables

Using the DEFINE and VERIFY command

Using Single-Row Functions to Customize Output

Manipulate strings with character function in the SELECT and WHERE clauses

Perform arithmetic with date data

Manipulate numbers with the ROUND, TRUNC and MOD functions

Describe the differences between single row and multiple row functions

Manipulate dates with the date functions

Using Conversion Functions and Conditional Expressions

Use conditional IF THEN ELSE logic in a SELECT statement

Apply the NVL, NULLIF, and COALESCE functions to data

Describe implicit and explicit data type conversion

Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

Nest multiple functions

Reporting Aggregated Data Using the Group Functions

Restricting Group Results

Creating Groups of Data

Group Functions

Displaying Data from Multiple Tables Using Joins

Self-join

Types of Joins

Introduction to JOINS

Non equijoins

OUTER join

Natural join

Using Subqueries to Solve Queries

Single Row Subqueries

Multiple Row Subqueries

Introduction to Subqueries

Using the SET Operators

Matching the SELECT statements

Set Operators

Using ORDER BY clause in set operations

INTERSECT operator

MINUS operator

UNION and UNION ALL operator

Managing Tables using DML statements

Database Transactions

Data Manipulation Language

Introduction to Data Definition Language

Data Definition Language

Introduction to Data Dictionary Views

Describe the Data Dictionary Structure

Introduction to Data Dictionary

Querying the Data Dictionary Views

Using the Data Dictionary views

Creating Sequences, Synonyms, Indexes

Overview of indexes

Overview of synonyms

Overview of sequences

Creating Views

Overview of views

Managing Schema Objects

Creating and using external tables

Creating and using temporary tables

Managing constraints

Retrieving Data by Using Subqueries

Working with Multiple-Column subqueries

Using Scalar subqueries in SQL

Correlated Subqueries

Retrieving Data by Using a Subquery as Source

Working with the WITH clause

Manipulating Data by Using Subqueries

Using the WITH CHECK OPTION Keyword on DML Statements

Inserting by Using a Subquery as a Target

Using Subqueries to Manipulate Data

Using Correlated Subqueries to Update and Delete rows

Controlling User Access

Revoking object privileges

Creating a role

Object privileges

System privileges

Manipulating Data

Using the MERGE statement

Using multitable INSERTs

Performing flashback operations

Overview of the Explicit Default Feature

Tracking Changes in Data

Managing Data in Different Time Zones

Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP

Working with INTERVAL data types

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Introduction to SQL Ed 2 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree