Register Now      202-747-5000
Road Map To Learning

Choose Your Learning Adventure:

Select from our standard “off-the-shelf” classes or build a course to target your learning goals. Ready to learn new skills? Contact Softek today!

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