After successfully completing this course, you will be able to: • Describe key capabilities and components of SQL Server 2016. • Describe T-SQL, sets, and predicate logic. • Write a single table SELECT statement. • Write a multi-table SELECT statement. • Write SELECT statements with filtering and sorting. • Describe how SQL Server uses data types. • Write DML statements. • Write queries that use built-in functions. • Write queries that aggregate data. • Write subqueries. • Create and implement views and table-valued functions. • Use set operators to combine query results. • Write queries that use window ranking, offset, and aggregate functions. • Transform data by implementing pivot, un-pivot, rollup and cube. • Create and implement stored procedures. • Add programming constructs such as variables, conditions, and loops to T-SQL code. • Design and Implement Tables. • Describe advanced table designs • Ensure Data Integrity through Constraints. • Describe indexes, including Optimized and Column-store indexes • Design and Implement Views. • Design and Implement Stored Procedures. • Design and Implement User Defined Functions. • Respond to data manipulation using triggers. • Design and Implement In-Memory Tables. • Implement Managed Code in SQL Server. • Store and Query XML Data. • Work with Spatial Data. • Store and Query Blobs and Text Documents.