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: Input Parameters

Learn about the input parameters in stored procedures.

We'll cover the following...

Syntax
Usage
Example

Stored procedures can have input parameters. These are similar to function parameters. We can pass in some data when executing a stored procedure.

Syntax

Declaring parameters for a stored procedure differs slightly from the ...