Advanced Databases and SQL Querying

Master SQL views by creating simple and joined views using template explorer templates and custom queries, testing them on sample tables like sales territory, and granting access to view results.

Explore how triggers automatically run actions on insert, update, or delete, enabling automated emails, logging, and validation in a sales table scenario.

Explore how SQL triggers fire on insert, update, or delete to enforce rules, with table-level and database-level examples that rollback or log changes.

Explore SQL computed columns that derive values from other columns, such as calculating a full name from first name and last name in an employee table.

Explore computed columns in SQL by creating a table with first name and last name, then defining a computed full name that derives its value from other columns.

Discover SQL stored procedures to encapsulate query logic and centralize rules. Build parameterized procedures for selecting, inserting, updating, and deleting data on a shopping site.

Explore creating and managing SQL stored procedures, from template-based setup to from-scratch coding. Learn parametrized procedures with default values, output parameters, and return values.

Explore user defined functions in SQL, including scalar and table valued variants, and compare them to stored procedures. Learn how to define, pass parameters, and return values within queries.

Explore how SQL user defined functions differ from stored procedures, and learn to create scalar and table-valued functions, pass parameters, and call them within queries to compute YTD sales.

Explore how transactions ensure data integrity through commit and rollback, and learn the acid properties—atomicity, consistency, isolation, durability—and how they govern reliable database behavior and error handling.

Master transactions and error handling in SQL by using begin transaction, commit, rollback, and try/catch with raise error, while managing deadlocks and debugging strategies.

Explore common table expressions and grouping sets to simplify complex queries by storing temporary result sets and applying rollup, cube, and grouping across multiple dimensions.

Explore ranking functions in SQL to assign ranks based on salary order, handle ties, and bucket data into groups, including use cases like finding the second highest salary.

Explore ranking functions in SQL by applying the rank function to postal codes from the Adventure Works address table, observe grouping into 10 groups, and understand ordering criteria.

Explore xml basics: understand tag-based data, schema definition, and how to parse and transform xml with xslt for loading into a database and etl workflows.

Explore the sql xml datatype and learn to convert relational data to xml. Learn to query and parse xml with OpenXML and value to map data into columns.