Vault™ > SQL101v2: Introduction to Transact-SQL

Access to the Vault™ requires an active Microsoft Live Subscription.

Login Buy Subscription

SQL101v2: Introduction to Transact-SQL

By Peter Avila
5 Days
Live Class Recording
March 11, 2024
Course Description

In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output.

You’ll gain a foundation understanding of a SQL Server database and use the tools available to discover the database definition, submit queries and view results.

We teach students how to write a query the same way that SQL Server processes a SQL statement – following a step-by-step process for creating SQL queries from business requirements. This approach uses the natural way of breaking down a problem into logical steps. Each step can be validated before moving to the next step. This differs from most courses, which present SQL as a set of features.

Class lectures highlight and explain Transact-SQL concepts which are reinforced with extensive follow-along demonstrations and hands-on labs.

Course Outline

Module 1: Discovering the Database

Lessons:

  • Basic Table Metadata
  • Foundations of Relationships of Data Modeling
  • Relationships in Data Modeling
  • Database Diagramming
  • Preparing to Write SQL

 

Module 2: Accessing Tables

Lessons:

  • The Basic SELECT
  • Introducing Joins: Single Join Queries
  • Multiple Join Queries

 

Module 3: Filtering the Data

Lessons:

  • Basic Filtering
  • Complex Filtering
  • Advanced Filtering

 

Module 4: Displaying Data

Lessons:

  • Defining the Result Set
  • Manipulating Numbers and Data Types
  • Controlling Output Rows

 

Module 5: Aggregating Data

Lessons:

  • Grouping Data

 

Module 6:  Modifying the Data

Lessons:

  • Inserting Data
  • Deleting Data
  • Updating Data

 

Course Content
Introduction
Introduction
Introduction (Continuation after break)
SQL Server Common Topology
Module 1 Database Concept
Getting to Know Databases
Foundation of Data Modeling
Foundation of Data Modeling (Continuation after break)
Foundation of Data Modeling (Continuation after lunch)
Basic Table Metadata
Basic Table Metadata (Continuation after break)
Review
Day 1 Review
Module 1 Database Concept
Foundation of Relationships of Data Modeling
Relationships in Data Modeling
Relationships in Data Modeling (Continuation after break)
Relationships in Data Modeling (Continuation after lunch)
Database Diagramming
Preparing to Write SQL
Module 2 Accessing Tables
The Basic SELECT Statement
Introducing Joins: Single-Join Queries
The Basic SELECT Statement (Continuation next day)
Introducing Joins: Single-Join Queries
Introducing Joins: Single-Join Queries (Continuation after lunch - Cross Joins)
Multiple Join Queries
Multiple Join Queries (Continuation after break)
Review
Day 3 review
Module 3 Filtering the Data
Basic Filtering
Basic Filtering (Continuation after Hot lab: Convert subquery to join)
Basic Filtering (Continuation after break)
Complex Filtering
Advanced Filtering
Module 4 Displaying Data
Defining the Results Set
Manipulating Numbers and Data Types
Review
Day 4 review
Module 4 Displaying Data
Manipulating Numbers and Data Types (Continuation next day)
Controlling Output Rows
Module 5 Aggregating Data
Aggregating Data
Module 6 Modifying the Data
Inserting Data
Inserting Data (Continuation after break)
Deleting Data
Updating Data