AI Features

0% completed

All LessonsFree Lessons (4)

Before We Start

Introduction to the Course Course Structure

T-SQL Basics

Introduction to T-SQL Databases: Creating and Removing Tables: Creating and Removing Inserting Data in Tables Retrieving Data from Tables Filtering the Data from Tables Query Limits, and Distinct and Ordered Data Updating and Deleting Data from Tables Quiz Yourself: T-SQL Basics

Querying Multiple Tables

Table Relationships Foreign Key Constraints: Inserting Data into Dependent Tables Querying with Joins Types of SQL Joins Quiz Yourself: Querying Multiple Tables

Grouping and Aggregation

Aggregate Functions Uses of the GROUP BY Function Window Functions The PARTITION BY Clause Quiz Yourself: Grouping and Aggregation

Subqueries

Introduction to Subqueries Use Cases for Subqueries Comparing Values Operators: EXISTS and IN Quiz Yourself: Subqueries

Course Assessment

T-SQL Fundamentals Assessment

Built-in Functions

Working with String Values Date and Time Functions Casting and Conversion Handling NULL Quiz Yourself: Built-in Functions

T-SQL Programming Basics

Views Variables Temporary Tables Scalar-Valued Functions Table-Valued Functions Stored Procedures Stored Procedures: Input Parameters Stored Procedures: Output Parameters Quiz Yourself: T-SQL Programming Basics

Additional Programming Constructs

Raising and Throwing Errors

Transaction Rollbacks

Transaction Isolation

Quiz Yourself: Additional Programming Constructs

Course Assessment

Course Comprehension Assessment

Conclusion

Querying Databases Using Transact-SQL

The WHILE Loop

Learn how to use the WHILE loop in T-SQL.

We'll cover the following...

Syntax
Examples
- Printing multiple times
- Calculating the factorial

The WHILE loop is one of the most straightforward constructs in T-SQL. It is easy and ...