SQL Querying 2 – Supported – Full Day

$ 470.00

Class Duration: 7.5 Hours

Class Agenda

Resource Setup 30 Minutes
Morning Session 3 Hours
Lunch 1 Hour
Afternoon Session 3 Hours
Other Breaks Prescribed by Instructor

Building on our SQL Querying 1 class, SQL Querying 2 will teach you how to identify and use advanced querying techniques to handle large amounts of data allowing you to query multiple tables simultaneously and with increasing frequency.

Recommended Preparation: SQL Querying 1 

  • Search Based on Values from a Subquery
  • Compare Values from a Subquery
  • Search Based on the Existence of Records
  • Generate Output Using Correlated Subqueries
  • Perform Multiple-Level Subqueries
  • Insert Rows
  • Modify and Delete Data
  • Create a Table
  • Create a Table with Constraints
  • Modify a Table’s Structure
  • Delete Tables
  • Create a View
  • Manipulate Data in Views
  • Modify and Delete Views
  • Create Indexes
  • Drop Indexes
  • Define a Transaction
  • Commit Transactions
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Scroll to Top