MicroKnowledge SQL Advanced Queries

SQL Advanced Queries

Use advanced techniques such as unions, COMPUTE, subqueries; add, update and remove data; manipulate tables, views and indexes; ensure data integrity and create databases.

Recommended Preparation: SQL Fundamentals or equivalent knowledge

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
SELECT INTO

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