Overview
Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
Requirements
SQL: Fundamentals of Querying or equivalent knowledge.
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
- 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