Advanced Databases and SQL Querying

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.

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 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.

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.