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

SQL Server Training


I really liked the fact that we could follow using the manual PDF files on our individual machines. This allowed to easily/quickly scroll back/forth the slides without having to interrupt the class to ask to go back to certain slides when needing to review something. This also allowed to easily search within the manual for specific keywords while doing exercises
Comment from Mitel

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