Oracle 12c: SQL & PL/SQL Training Institute [TOP-RATED]

• Brief History of SQL 
• Relational Databases: 

Tables, Rows, Columns, Relationships, Datatypes 

Primary Keys, Foreign Keys, RDBMS Concepts 

• Popular Databases: 

Commercial & Open Source Databases 

Valid Object References 

• SQL Statements:

DML, DDL, DCL 

• Introduction to Northwind Database 
• SQL Basics: Comments, Whitespace, Case Sensitivity 
• SELECT Statements:

All Columns vs Specific Columns 

Sorting Records (Single/Multiple Columns, Asc/Desc) 

• WHERE Clause & Operators: 

Equality, Inequality, NULL Checks 

BETWEEN, IN, LIKE, NOT Operators 

Multiple Conditions (AND, OR) 

• Calculated Fields: Concatenation, Math, Aliases 
• Aggregate Functions & Grouping: 

SUM, AVG, MIN, MAX, COUNT 

Grouping & Distinct Records 

• Built-in Data Manipulation Functions: 

Math, String, and Date Functions 

• Subqueries: Nested, Inline Views, Correlated Subqueries 
• Joins: Inner, Outer, Cross, Natural Joins 
• Unions: UNION, UNION ALL & Rules 

• Conditional Processing with CASE 
• DML Operations: INSERT, UPDATE, DELETE 
• Student Challenges: Report Design 

• Users & Schemas Introduction: Definitions, Tools 
• SQL Developer Login 
• HR Schema Overview: Entities, Sample Schemas 
• Creating Application Schemas 

• Dual Table & Functions: SYSCONTEXT 
• Pseudo-Columns: ROWID, ROWNUM

• Simple Subqueries: Definition, Nested Views 
• Inline Views & HAVING Clause 
• Correlated & Scalar Subqueries 

• Join Types: Inner, Outer, Cross, Natural 
• Advanced Joins: Reflexive, Non-Key, Semijoins 
• Named Subqueries & Exercises 

• Group Processing Concepts 
• GROUP BY, ROLLUP, CUBE Functions 
• Exercises on ROLLUP & CUBE 

• Set Theory in SQL: UNION, INTERSECT, MINUS 
• Restrictions & Usage Scenarios 

• DECODE Function 
• CASE Expression 

• Character Functions: CONCAT, LENGTH, REPLACE etc., 
• Regular Expressions: SOUNDEX, UPPER, LOWER etc., 

• Numeric Functions: TO_CHAR with Numbers 
• Date/Time Functions: Date Arithmetic 
• Null Value Handling 

• INSERT, UPDATE, DELETE Statements 
• MERGE Statement & Transactions 

• Creating & Managing Views 

•  Indexing Techniques & Performance

• Creating & Managing Sequences

• Purpose & Usage of Synonyms  

• User-Defined Types & Usage

• Introduction to PL/SQL 

• File Naming Conventions 
• SQLDeveloper & SQLPlus Setup 

• Block Structure: Anonymous vs Named Blocks 
• Calling Functions & Execution 

• Variable Data Types & Naming 
• Variable Assignment & Display 

• Conditional Statements: IF, CASE 
• Looping Constructs: LOOP, WHILE, FOR 

• System & User-Defined Exceptions 
• Exception Propagation 

• Implicit & Explicit Cursors 
• Attributes & EXECUTE IMMEDIATE 

• Scope of Variables & Exceptions 
• Exception Propagation in Nested Blocks 

• Anonymous vs Named Subprograms 
• Finding & Managing Dependencies 

• Creating, Modifying, & Debugging 
• Parameters & Cursor Parameters

• Structure & Usage 
• Wrap Utility & Parameter Notation 

• Purpose & Invocation 
• Coding & Managing Triggers 

• Cursor Review & Dynamic SQL 
• Cursor Variables & Reports