All our Locations are now permanently closed due to Covid-19

SQL Querying: Advanced

This instructor-led class is held at Training Centres of Canada
330 Bay Street, suite 610. All classes start at 9am.

This course is currently available as E-Learning, or a private instructor-led class scheduled to suit your availabilty. You can click here to inquire further or you ask us for recommendations on similar classes.

Performance-Based Objectives

In this course, you will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel the data entry process.
You will:
Use subqueries to generate query output.
Manipulate table data by inserting and updating records in a table and deleting records from a table.
Manipulate the table structure.
Create views, manipulate data through views, modify the view structure, and drop views.
Create indexes on table columns and drop inefficient indexes.

Course Content

Lesson 1: Using Subqueries to Perform Advanced Querying

Topic A: Search Based on Unknown Values
Topic B: Compare a Value with Unknown Values
Topic C: Search Based on the Existence of Records
Topic D: Generate Output Using Correlated Subqueries
Topic E: Filter Grouped Data Within Subqueries
Topic F: Perform Multiple-Level Subqueries

Lesson 2: Manipulating Table Data

Topic A: Insert Data
Topic B: Modify and Delete Data

Lesson 3: Manipulating the Table Structure

Topic A: Create a Table
Topic B: Create a Table with Constraints
Topic C: Modify a Table's Structure
Topic D: Back Up Tables
Topic E: Delete Tables

Lesson 4: Working with Views

Topic A: Create a View
Topic B: Manipulate Data in Views
Topic C: Create Aliases
Topic D: Modify and Delete Views

Lesson 5: Indexing Data

Topic A: Create Indexes
Topic B: Drop Indexes

Click here to reach us by Email Contact Us
About | Terms of Use | Privacy Visit our Facebook page   Visit ot Linkedin page   View our Tweets