Advanced SQL Querying

1 Day, 9:00-4:00

Course Overview

This instructor-led, hands-on course, will teach you how to work with advanced queries to manipulate and index tables, create views, and create transactions that save or cancel data entry.

Course Objectives

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 indices on table columns and drop inefficient indices
Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction

Course Outline

Using Subqueries to Perform Advanced Querying

Search Based on Unknown Values
Compare a Value with Unknown Values
Search Based on the Existence of Records
Generate Output Using Correlated Subqueries
Filter Grouped Data Within Subqueries
Perform Multiple-Level Subqueries

Manipulating Table Data

Insert Data
Modify and Delete Data

Manipulating the Table Structure

Create a Table
Create a Table with Constraints
Add and Drop Table Columns
Add and Drop Constraints
Modify the Column Definition
Back Up Tables
Delete Tables

Working with Views

Create a View
Manipulate Data in Views
Create Aliases
Modify and Drop Views

Indexing Data

Create Indices
Drop Indices

Managing Transactions

Create Transactions
Commit Transactions

Appendix A: Structure of the Bookstore Database

Cost and Delivery Format Options

We offer the above listed class on our public schedule and as a private group class in the following delivery formats:

Public Class: Live Virtual
Per student	$400

Private Group Class: Live Virtual
1-6 students*	$2400
*$350 per additional student

Private Group Class: At Your Location
1-6 students*	$3550
*$350 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

A computer for each student (with the appropriate software installed), and
An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $150 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization.

Why Choose Softek?

Live, virtual or in-person training
Instructors with 15+ years of experience
Detailed training guide
Certificate of completion
Money-back guarantee