SQL 7.0: Advanced

Course Specifications:
Courseware: SQL: Advanced Querying
Software: SQL 7.0
Course length: 1 day
Course times: 8:30 a.m. - 4:30 p.m.

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

Course Objective:
Upon course completion, students will be able to use advanced techniques for querying a database, including querying with subqueries, creating and editing data, tables, views and indexes, and creating and dropping databases.

Target Student:
Students enrolling in this course should 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.

Prerequisites:
To ensure the successful completion of SQL 7.0: Advanced, we recommend completion of the following MicroAssist courses, or equivalent knowledge from another source:

-SQL 7.0: Introduction

Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Each student is provided with a computer and a Training Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content:
Lesson 1: Querying with unions and advanced joins
Topic 1A: Querying multiple tables with unions
Topic 1B: Advanced Joins
Topic 1C: Calculating with COMPUTE

Lesson 2: Querying with subqueries
Topic 2A: Subqueries

Lesson 3: Adding data
Topic 3A: Inserting data
Topic 3B: SELECT INTO

Lesson 4: Updating and removing data
Topic 4A: Updating records
Topic 4B: Deleting records
Topic 4C: Deleting the contents of tables

Lesson 5: Manipulating tables and views
Topic 5A: Creating tables
Topic 5B: Modifying tables
Topic 5C: Deleting tables
Topic 5D: Adding and removing views

Lesson 6: Manipulating indexes
Topic 6A: Adding and removing indexes

Lesson 7: Ensuring data integrity with transactions
Topic 7A: Transactions

Lesson 8: Creating databases
Topic 8A: Creating a database with SQL
Topic 8B: Deleting a database