Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Gold Training Partner
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
 
 Main Menu
 
Home
View Courses
Site Index
 
 


SQL Level 2: Advanced Querying Overview




  • 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

  • Lesson 6: Managing Transactions

  • Topic A: Create Transactions

  • Topic B: Commit Transactions


 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 8/14/2017
 $535
Enroll

To Inquire About Future Classes

Request a class date

if one is not scheduled.



Comments on the Course

This course expands on SQL Level 1: Fundamentals of Querying by adding insert, update and delete SQL statements.  The course also examines the uses of indexes and transactions.

The SQL information is ANSI standards and can be applied to any RDBMS, including DB2, Oracle, SQL/Server, Sybase, etc.