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


SQL: Fundamentals of Querying or equivalent knowledge.

  14 Hours


Related Courses

SQL in Microsoft Access

  14 hours

Microsoft Access - download the data

  14 hours

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

  14 hours

SQL in SQL Server

  14 hours

Transact SQL Basic

  14 hours

Transact SQL Advanced

  7 hours

SQL Fundamentals

  14 hours

SQL Advanced in MySQL

  7 hours


  14 hours

ORACLE PL/SQL Fundamentals

  21 hours

ORACLE SQL Fundamentals

  14 hours

Oracle SQL Language

  14 hours

Oracle SQL for beginners

  21 hours

Oracle SQL Advanced

  14 hours

Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

  21 hours