SQL Advanced Querying

1 day

Overview

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

Prerequisites

SQL Fundamentals of Querying or equivalent knowledge.

Benefits

Students will learn how to change, update and manipulate an SQL database.

Target student

Students should already understand the basics of querying a database with the SQL command language. They should be comfortable issuing SELECT queries against one or more tables and understand query concepts, such as joins.

Querying with unions and advanced joins

Querying multiple tables with unions
Advanced Joins
Calculating with COMPUTE

Querying with subqueries

Subqueries

Adding data

Inserting data
SELECT INTO

Updating and removing data

Updating records
Deleting records
Deleting the contents of tables

Manipulating tables and views

Creating tables
Modifying tables
Deleting tables
Adding and removing views

Manipulating indexes

Adding and removing indexes

Ensuring data integrity with transactions

Transactions

Creating databases

Creating a database with SQL
Deleting a database