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

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

Triggers Flow Control The WHILE Loop Cursors Error Handling Raising and Throwing Errors Transactions Transaction Rollbacks Transaction Isolation Quiz Yourself: Additional Programming Constructs

Course Assessment

Course Comprehension Assessment

Conclusion

Querying Databases Using Transact-SQL

Stored Procedures: Output Parameters

Learn about the output parameters in stored procedures.

We'll cover the following...

Syntax
Usage
Example

Stored procedures, unlike functions, do not have to return any data back to the caller. They only execute the ...