SQL Advanced Training Course


14 hours (usually 2 days including breaks)


SQL: Fundamentals of Querying or equivalent knowledge.


Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.

Course Outline

Lesson 1: Querying with unions and advanced joins

  • Querying multiple tables with unions
  • Advanced Joins
  • Calculating with COMPUTE

Lesson 2: Querying with subqueries

  • Subqueries

Lesson 3: Adding data

  • Inserting data

Lesson 4: Updating and removing data

  • Updating records
  • Deleting records
  • Deleting the contents of tables

Lesson 5: Manipulating tables and views

  • Creating tables
  • Modifying tables
  • Deleting tables
  • Adding and removing views

Lesson 6: Manipulating indexes

  • Adding and removing indexes

Lesson 7: Ensuring data integrity with transactions

  • Transactions

Lesson 8: Creating databases

  • Creating a database with SQL
  • Deleting a database

Leave a Reply

Your email address will not be published. Required fields are marked *