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:

  1. 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 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

  1. Topic 1A: Querying multiple tables with unions
  2. Topic 1B: Advanced Joins
  3. Topic 1C: Calculating with COMPUTE

Lesson 2: Querying with subqueries

  1. Topic 2A: Subqueries

Lesson 3: Adding data

  1. Topic 3A: Inserting data
  2. Topic 3B: SELECT INTO

Lesson 4: Updating and removing data

  1. Topic 4A: Updating records
  2. Topic 4B: Deleting records
  3. Topic 4C: Deleting the contents of tables

Lesson 5: Manipulating tables and views

  1. Topic 5A: Creating tables
  2. Topic 5B: Modifying tables
  3. Topic 5C: Deleting tables
  4. Topic 5D: Adding and removing views

Lesson 6: Manipulating indexes

  1. Topic 6A: Adding and removing indexes

Lesson 7: Ensuring data integrity with transactions

  1. Topic 7A: Transactions

Lesson 8: Creating databases

  1. Topic 8A: Creating a database with SQL
  2. Topic 8B: Deleting a database