Introduction to Transact-SQL - Revised

Start Course Now

Modules

Sujets

hours

transact-sql
AdventureWorks Resources
Lab instructions and SQL code files
Module 1
Introducing Transact-SQL
Resources available

In this module, you will be introduced to Transact-SQL and you will learn about Structured Query Language, Data Manipulation Language, Data Definition Language and Data Control Language.

Introducing Transact-SQL - Learning Outcomes

Démarrez Topic

Introducing Transact-SQL - Course Introduction

Démarrez Topic

Introduction to Transact-SQL

Démarrez Topic

The SELECT Statement

Démarrez Topic

Data Types and Working with NULL

Démarrez Topic

Introducing Transact-SQL - Lesson Summary

Démarrez Topic
Module 2
Querying Tables with Select
Resources available

In this module, you will learn how to query tables with select. You will look at removing duplicates and sorting as well as filtering and using predicates.

Querying Tables with Select - Learning Outcomes

Démarrez Topic

Removing Duplicates and Sorting

Démarrez Topic

Filtering and Using Predicates

Démarrez Topic

Querying Tables with Select - Lesson Summary

Démarrez Topic
Module 3
Querying Multiple Tables with Joins and Using Set Operators
Resources available

This module will introduce you to Joins and Queries, you will learn about how to use a join and the various types of joins that are used.

Querying Multiple Tables with Joins and Using Set Operators - Learning Outcomes

Démarrez Topic

Join Concepts and Syntax

Démarrez Topic

Inner Joins

Démarrez Topic

Outer Joins

Démarrez Topic

Cross Joins

Démarrez Topic

Self Joins

Démarrez Topic

Union Queries

Démarrez Topic

Intersect Queries and Except Queries

Démarrez Topic

Querying Multiple Tables with Joins and Using Set Operators - Lesson Summary

Démarrez Topic
Module 4
Using Functions and Aggregating Data
Resources available

This module will introduce you to various functions such as Scalar Functions and Logical Functions. You will also gain a greater understanding of GROUP BY and Filtering with HAVING.

Using Functions and Aggregating Data - Learning Outcomes

Démarrez Topic

Scalar Functions

Démarrez Topic

Logical Functions

Démarrez Topic

Window and Aggregate Functions

Démarrez Topic

Group By and Filtering with Having

Démarrez Topic

Using Functions and Aggregating Data - Lesson Summary

Démarrez Topic
course assessment: Introduction to Transact-SQL - Revised
Module 5
Course assessment
Resources available

Introduction to Transact-SQL - Final Assessment

Start Assessment

Rejoignez-nous maintenant

Introduction to Transact-SQL - Revised

transact-sql

Introducing Transact-SQL

Introducing Transact-SQL - Learning Outcomes

Introducing Transact-SQL - Course Introduction

Introduction to Transact-SQL

The SELECT Statement

Data Types and Working with NULL

Introducing Transact-SQL - Lesson Summary

Querying Tables with Select

Querying Tables with Select - Learning Outcomes

Removing Duplicates and Sorting

Filtering and Using Predicates

Querying Tables with Select - Lesson Summary

Querying Multiple Tables with Joins and Using Set Operators

Querying Multiple Tables with Joins and Using Set Operators - Learning Outcomes

Join Concepts and Syntax

Inner Joins

Outer Joins

Cross Joins

Self Joins

Union Queries

Intersect Queries and Except Queries

Querying Multiple Tables with Joins and Using Set Operators - Lesson Summary

Using Functions and Aggregating Data

Using Functions and Aggregating Data - Learning Outcomes

Scalar Functions

Logical Functions

Window and Aggregate Functions

Group By and Filtering with Having

Using Functions and Aggregating Data - Lesson Summary

course assessment: Introduction to Transact-SQL - Revised

Course assessment

Introduction to Transact-SQL - Final Assessment