SETC Training844-434-7382
 Find a Course: 
 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

SQL Server Training


The learning experience was excellent.
Comment from Law Society of Upper Canada

1. Title

  • Introducing SQL: The Basics of Database Querying (SQLINT, 2 days)
    View PDF

2. Course Pre-requisites

  • Previous relational database experience

3. Target Audience

  • IT Professionals who want to learn how to use SQL to perform database queries

4. Dates and Pricing


2 People for Guaranteed Live or Virtual Delivery $1,150.00 per person

5. Outline

Module 1: Structured Query Language (SQL) Basics

Topic 1: Choosing data

Topic 2: Using the Where Clause

Topic 3: Ordering Data with the Order By Clause

Topic 4: Using Expressions

Topic 5: Working with Dates

Topic 6: Working with NULL Values

Topic 7: Working with Functions

Module 2: Modifying Data

Topic 1: Using the INSERT Statement

Topic 2: Adding Table Records Using INSERT INTO

Topic 3: Using the UPDATE Statement

Topic 4: Using Update with Sub-Queries

Topic 5: Using the DELETE Statement

Module 3: Working with Aggregate Data

Topic 1: Retrieving Aggregate Values with the Group By Clause

Topic 2: Using GROUP By with Order By and Where

Topic 3: Using TOP

Topic 4: Using CUBE and ROLLUP

Topic 5: Advanced Aggregate Operations

Module 4: Joining Data

Topic 1: Database Integrity and Constraints

Topic 2: About Primary Keys and Foreign Keys

Topic 3: Performing an Inner Join

Topic 4: Performing an Outer Join

Topic 5: Performing a Cross Join

Topic 6: About Working with NULL Values

Topic 7: Performance Considerations: Indexes and Keys

Module 5: Advanced SQL Querying

Topic 1: Creating and Using Views

Topic 2: Performance Considerations and Limitations

Topic 3: Creating and Using Simple Sub-Queries

Topic 4: Creating and Using Advanced Sub-Queries

Topic 5: Comparing Sub-Queries and Views: Which is Better?

Topic 6: A Note on Indexed/Stored Views

Topic 7: A Few Useful Scripts

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette