Description
Understand why T-SQL works as it does, so you can write better code
Review relational theory elements and modern SQL Server architecture
Create tables and defi ne data integrity
Build single-table SELECT queries, multiple-table joins, and subqueries
Utilize derived tables, Common Table Expressions, views, inline table-valued functions, and APPLY
Make the most of UNION, INTERSECT, and EXCEPT set operators
Perform data analysis with window functions, pivoting, grouping sets, and time series
Insert, update, delete, and merge data
Get started with system-versioned temporal tables
Understand and apply transactions and concurrency, including concurrent user connections, locks, blocking, isolation levels, and more
Use SQL Graph to model, create, modify, and query graph-based data
Explore SQL Server programmable objects and programming capabilities
Set up your environment, install sample databases, and fi nd even more help
Reviews
There are no reviews yet.