Advanced SQL

SQL is a used to communicate with a database by firing queries.  Advance sql contains all the sql functions.
These are the topics covered:
   
Basics:

1.     SELECTing columns from a table
2.     Aggregates Part 1: COUNT, SUM, MAX/MIN
3.     Aggregates Part 2: DISTINCT, GROUP BY, HAVING

Intermediate:

1.     JOINs, syntax
2.     UNION vs UNION ALL
3.     Subqueries: IN, EXISTS, and inline views
4.     Subqueries: Correlated
5.     WITH syntax: Subquery Factoring/CTE
6.     Views

Advanced Topics:

1.  Controlling User Access.
2.  Using SET operators.
3.  DateTime Functions.
4.  Enhancements to Group by clause(cube, Rollup and Grouping).
5.  Advanced Subqueries (Multiple column subqueries, Subqueries in FROM clause, Scalar and correlated subqueries).
6.  WITH Clause.
7.  Hierarchical retrieval.

References/Books:
Murach’s Oracle SQL and PLSQL by Joel Murach, Murach and Associates.
Oracle Database 11g PL/SQL Programming Workbook, ISBN: 9780070702264, By: Michael McLaughlin,John Harper, TATAMCGRAW-HILL .
Oracle PL/SQL Programming, Fifth Edition By Steven Feuerstein.
Oracle database 11g: hands on SQL/PL SQL by Satish Asnani (PHI) EEE edition.

Notes Download:
Advance SQL (Sem-III) Complete Notes -Here

Advanced SQL All Programs Available - Here