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

Cursors

Learn how to iterate a group of rows using cursors.

We'll cover the following...

T-SQL cursor
Syntax
- Example

Data manipulation commands like SELECT, UPDATE, and DELETE always work with groups of rows. We can filter using a WHERE clause if we want to process a specific row. However, there might be times we want to process each row sequentially, ...