Course Code: orsqlbspk
Duration: 20 hours
Prerequisites:

-

Overview:

-

Course Outline:
  • Table Joins
    • Recap of joins using primary key and foreign key connections
    • Recap of difference between inner and outer joins
    • Recap of usage of link tables to resolve many-to-many relationships
    • Self Joins
  • Sub Queries
    • Recap of nested sub-queries in Where & Having clauses
    • Recap of correlated sub-queries in Where & Having clauses
    • Common Table Expression
    • Sub-Queries as columns
  • Querying with unions and advanced joins
    • Querying multiple tables with unions
    • Advanced Joins
  • Querying with subqueries
    • Subqueries
  • Adding data
    • Inserting data
    • SELECT INTO
  • Updating and removing data
    • Updating records              
    • Deleting records
    • Deleting the contents of tables
  • DQL (Data Query Language)
    • Dealing with NULL, NULL-safe operators
    • Using CASE, IF, COALESCE functions
  • DML (Data Modification Language)
    • Multi-row inserts
    • INSERT by SELECT
    • Updating data in many tables
  • DDL (Data Definition Language)
    • Creating tables with select
    • Temporary tables
  • Stored Procedures
    • Use of parameters
    • Use of IF statements
    • Use of Loops & Cursors
  • Execution Plan
  • Indexes