Master Microsoft SQL Server 2022

Master Microsoft SQL Server 2022 outlines free editions (Express and Developer) and paid editions (Enterprise and Standard), with Express 16 cores/64 GB, Developer unrestricted, and Standard 24 cores/128 GB.

Learn to create tables in SQL Server 2022 with Management Studio, covering memory-optimized, temporal, ledger, graph, external, and file tables, and define columns with varchar, nvarchar, and date types.

Select appropriate data types for table design to optimize storage and network efficiency while ensuring data integrity, and choose the smallest data type that fits while previewing popular data types.

Learn how to populate columns with default values, such as setting state to Ohio and using Getdate for created date, then save changes and verify inserts.

Attach the AdventureWorks database, restore it, and open a query window to execute select statements that retrieve literals, built-in functions, and aliased columns from human resources.department.

Discover self-join, or equijoin, by joining the sales.customers table to itself with aliases, using an on clause to compare records within the same table and reveal sales representatives.

Group by and count tally addresses per city and state province in the Adventureworks 2022 database, using count and order by to reveal the top city-state combinations.

Learn aggregate functions in SQL Server 2022, including count all, count distinct, sum, average, min, max, stddev, var and population variance, plus approximate count distinct and approximate percentile functions.

Learn to use the sum aggregate function to compute the total line total and total order quantity per sales order ID, count distinct products, and sort by order total descending.

Apply the having clause with group by to filter color groups by aggregated product counts, such as counts greater than 25.

Explore built-in SQL Server functions across aggregate, string, mathematical, date and time, and logical categories. Learn which functions take zero or multiple arguments, with getdate as an example.

Learn how to concatenate first, middle, and last names using the plus operator with separators, and compare the concat and concat with separator functions, including null handling.

Learn how to use case statements in SQL Server 2022 to implement conditional logic, categorize job titles into managers, staff, and others, and alias the result as employee category.