Oracle 12c SQL Certification training Bangalore| Oracle 12c SQL Certification course| OCA OCP training


Oracle 12c SQL Certification training Bangalore

Oracle 12c SQL certification training bangalore, oracle 12c sql course, oracle 12c sql training koramangala, oracle 12c oca training, 1z0-061 training, 1z0-071 training

Oracle 12c SQL Certified Associate
Exam Training- (Exam Code: 1Z0-071)
 
Click here to download detailed Syllabus 
 

What do you learn in this course?

This Oracle 12c Database 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.

Course Highlights:

Real time training with live examples and practice
Learn how to convert business logic to SQL Queries
Understand how queries run in the background
Full training and support for Certification Exam
Premium support at our Authorized Exam center

About the Instructor:
DTecH SQL Certified & experienced real time trainer. 

Language of Instruction: English

Duration: 10 days, 10 Sessions, 2-3 hours per day

Training mode: Live Instructor led training

Course materials: Hard copies of both course & lab materials provided.

Software Setup & Lab: 

Will provide access our Oracle Server for Lab sessions.
Software provided to install on student laptops.

Pre-requisites:

Good logical thinking skills or knowledge of any programming language

Course Topics

Introduction
relational database management concepts
Introduction to SQL
What is Oracle SQL Developer?

Retrieving Data using the SQL SELECT Statement
Arithmetic expressions and NULL values in the SELECT statement
Column aliases
Use of concatenation operator
literal character strings
quote operator
DISTINCT keyword
DESCRIBE command
Restricting and Sorting Data
Limiting the Rows
Rules of precedence for operators

Single-Row Functions
multiple row functions
character functions
Number Functions
Perform arithmetic with dates
date functions

Conversion Functions
Conditional Expressions
implicit data type conversion
TO_CHAR, TO_NUMBER, and TO_DATE functions
Nest functions
NVL, NULLIF, and COALESCE functions
Use IF THEN ELSE logic in a SELECT statement

Reporting Aggregated Data Using the Group Functions
Group Functions
Creating Groups of Data
Having clause

Introduction to JOINS
Types of Joins
Natural join
Self-join
Non equijoins
OUTER join

Using Subqueries to Solve Queries
Single Row Subqueries
Multiple Row Subqueries
Inline views
Multiple-Column subqueries
Correlated Subqueries
WITH clause
WITH CHECK OPTION
Correlated Subqueries to Update/Delete rows
Manipulating Data by Using Subqueries
Using Subqueries to Manipulate Data

Set Operators
UNION and UNION ALL operator
INTERSECT operator
MINUS operator
Matching the SELECT statements
Using ORDER BY clause in set operations

Managing Tables using DML statements
Data Manipulation Language
Database Transactions

Introduction to Data Definition Language
Data Definition Language

Data Dictionary Views
Describe the Data Dictionary Structure
Using the Data Dictionary views
Querying the Data Dictionary Views

Overview of sequences
Overview of synonyms
Overview of indexes
Overview of views
Managing Schema Objects
Managing constraints
Creating and using temporary tables
Creating and using external tables


Inserting by Using a Subquery as a Target
Using the Keyword on DML Statements
Controlling User Access
System privileges
Creating a role
Object privileges
Revoking object privileges

Manipulating Data
Using multitable INSERTs
Using the MERGE statement

Overview of the Explicit Default Feature (12c)
Performing flashback operations
Tracking Changes in Data
Managing Data in Different Time Zones
Working with CURRENT_DATE, CURRENT_TIMESTAMP and LOCALTIMESTAMP
Working with INTERVAL data types

 

Click here & download detailed Syllabus Oracle 12c SQL training bangalore

Click here to fill up the course Enquiry Form!