-
Introduction to Microsoft SQL Server 2014
The Basic Architecture of SQL Server
SQL Server Editions and Versions
Getting Started with SQL Server Management Studio
-
Introduction to T-SQL Querying
Introducing T-SQL
Understanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements
-
Writing SELECT Queries
Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions
-
Querying Multiple Tables
Understanding Joins
Querying with Inner Joins
Querying with Outer Joins
-
Sorting and Filtering Data
Sorting Data
Filtering Data with a WHERE Clause
Filtering with the TOP and OFFSET-FETCH Options
Working with Unknown and Missing Values
-
Working with SQL Server 2014 Data Types
Introducing SQL Server 2014 Data Types
Working with Character Data
Working with Date and Time Data
-
Using DML to Modify Data
Inserting Data
Modifying and Deleting Data
-
Using Built-In Functions
Writing Queries with Built-In Functions
Using Conversion Functions
Using Logical Functions
Using Functions to Work with NULL
-
Grouping and Aggregating Data
Using Aggregate Functions
Using the GROUP BY Clause
Filtering Groups with HAVING
-
Using Subqueries
Writing Self-Contained Subqueries
Writing Correlated Subqueries
Using the EXISTS Predicate with Subqueries
-
Using Table Expressions
Using Derived Tables
Using Common Table Expressions
Using Views
Using Inline Table-Valued Functions
-
Using Set Operators
Writing Queries with the UNION Operator
Using EXCEPT and INTERSECT
Using APPLY
-
Using Window Ranking, Offset, and Aggregate Functions
Creating Windows with OVER
Exploring Window Functions
-
Pivoting and Grouping Sets
Writing Queries with PIVOT and UNPIVOT
Working with Grouping Sets
-
Executing Stored Procedures
Querying Data with Stored Procedures
Passing Parameters to Stored Procedures
Creating Simple Stored Procedures
Working with Dynamic SQL
-
Programming with T-SQL
T-SQL Programming Elements
Controlling Program Flow
-
Implementing Error Handling
Using TRY / CATCH Blocks
Working with Error Information
-
Implementing Transactions
Transactions and the Database Engine
Controlling Transactions
Isolation Levels