Course description
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.
Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
* Use advanced techniques for querying a database.
* Query with subqueries.
* Add data to a database.
* Change and delete data from a database.
* Create, alter, and delete tables, and create, use, and delete views.
* Create and delete indexes.
* Manage how data is altered through the use of transactions.
* Create and drop databases.
Course content
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