+1 (201) 720-5410 (USA)

My Cart


Advanced SQL

2 Review(s)

Training Mode: Class Room / Live Online

myTectra the Market Leader in advanced sql training

myTectra offers advanced sql training in Bangalore using Class Room. myTectra offers Live Online advanced sql training Globally.


Senior SQL Developers are in high demand and demand 100k+ salary in the IT industry. If we have to advance in our career and earn a good salary, we need these Advanced SQL skills. So let's take the next step of learning these advanced concepts of Oracle SQL.

Who is the target audience?
This SQL course is meant for students who already have familiarity with the SQL syntax and would like to learn the advanced concepts of SQL.

course outline:Welcome to the course
Important - How to make best use of the program.

Software Installation
Installing Oracle
Installing Java SDK
Installing SQL Developer
Running scripts necessary for the course
Scripts used in the demonstration

Manipulating data
Default values for columns
Virtual Columns
Arithmetic calculations on NULL Values
Multi table Insert's
Merge the data...

Analytical Functions
Analytical Functions Introductionbr
Why Analytical Functions Example 1
Why Analytical Functions Example 2
Getting the cummulative Sum of Sales
Displaying Sales as a percentage of Total sales
Ranking your data
Performing Top N Analysis
Dividing your data into Bands
LAG and LEAD function Examples
Analyzing Sales growth across time
Analytical Functions Recap

Transforming the Data
Row level data to Column level using CASE statement
Row level data to Column level using PIVOT
Row level data to Column level using LISTAGG
Row level data to Column level using LISTAGG
Column level data to Row level using UNION
Column level data to Row level using UNPIVOT
Data Transformation Recap

Hierarchical Queries
Hierarchical Queries Introduction
Connect By clause
Creating the Hierarchy Tree
Sorting the Hierarchy Tree
CONNECT_BY_ROOT unary operator
Get me the Sales under Manager Raj
CONNECT BY for number generation
Hierarchical Queries Recap
Exercise 2

Extensions to Group BY
Extensions to Group BY
Sub Totals using ROLLUP function
Sub Totals using CUBE function
GROUPING function
GROUPING_ID function
Limiting number of sub totals using GROUPING SETS function
Composite Columns
Group by Extensions Recap
Exercise 3

Table Partitioning
Table Partitioning Introduction
Range Partition based on range of values
List Partition based on list of values
Hash Partition based on the hash key
Composite Partitioning by mixing things up!!
Interval Partition for automatic partition creation
Adding/Droping Partitions
Table Partitioning Recap

Materialized Views
Materialized Views Introduction
Materialized Views creation Options
Materialized Views with ON COMMIT option
Materialized Views with ON DEMAND option
Materialized Views with REFRESH FAST option
Timing the refresh
Query Rewrite functionality
Materialized Views Recap

Regular Expressions
Regular Expressions Introduction
Meta Characters . and +
Meta Characters ? and *
Interval Operator to match the number of occurances
Matching the characters in a List
Lets combine multiple expressions using |
Check for an expression in the beginning or end of a string
POSIX Character class operators
Search for meta characters by placing a escape character
More examples on Regular Expressions

Flashback operations
Flashback operations Introduction
Tracking changes in Data
Flashback Operations Recap

Live Online advanced sql Training Globally and To Learn advanced sql training in Bangalore using Class Room ENROLL TODAY at myTectra.

Customer Reviews

2 Item(s)

per page
best institute Review by ramachandra
The trainer is very good impress and teach well.
It's very helpful for us.
This trainer as cover basic to logic level of the script.
All looks very good.
best institute Review by satheesh
The trainer is very good .They will teach each and every thing in our course and provide good labs also.

2 Item(s)

per page

Only registered users can write reviews. Please, log in or register

myTectra Stands for Quality Training and provides training using Experienced professionals on the Respective Technologies and who has a good teaching expertise.


myTectra flexible batch schedules enables you to start your class at your convenient date and time.

1. All the enrolled candidates must start the class by any date within 30 days from the date of enrollment.
2. Maximum of 3 Days will be taken by myTectra to schedule the batches from the date of schedule request from the candidate.
3. Individual Focus - Maximum 5 candidates allowed per batches
4. The candidate can request any one of the batch time slot from the below list
Batch Type Time Slab Hours/Day Time Zone Days
Regular Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Friday
Regular Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Friday
Week End 6.30 AM - 9.30 PM Anytime Maximum 3 Hrs IST Saturday,Sunday
Fast Track-Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Fast Track-Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Customized Batch Customized Timing Customized Hrs IST Customized Days

Note : We can schedule your batch anytime on Saturday and Sunday between 6.30 AM 9.30 PM at your convenient time

Do you have any questions ? please call us on +919019191856 or email to [email protected]