Querying Data with Transact-SQL (exam 70-761) 19:36 hours

T-SQL Querying

Course: 2 Hours, 9 Minutes

• Course Introduction
• SQL Server 2016 Architecture Overview
• SQL Server 2016 Editions and Components
• SQL Server 2016 Functions and Capabilities

SQL Server Management StudioFilter and Modify Data in SQL Server 2016

Course: 2 Hours, 21 Minutes

• Course Introduction
• SELECT Statements Overview
• Writing SELECT Statements in SQL Server 2016
• Calculated Expressions

Microsoft SQL Server 2016: Querying

Course: 2 Hours, 14 Minutes

• Course Introduction
• ORDER BY Clause
• Sorting Data
• Filtering Data
• WHERE Clause
• Predicates and Operators

Microsoft SQL Server 2016: Querying

Course: 1 Hour, 36 Minutes

• Course Introduction
• ORDER BY Clause
• Sorting Data
• Filtering Data
• WHERE Clause
• Predicates and Operators

Microsoft SQL Server 2016: Querying

Course: 2 Hours, 20 Minutes

• Course Introduction
• Aggregate Functions Overview
• SUM Aggregate Function
• AVG Aggregate Function
• MIN Aggregate Function
• MAX Aggregate Function
• COUNT Aggregate Fuction
• Aggregating Distinct Valuesnction
• NULL and Aggregate Functions

Microsoft SQL Server 2016: Querying

Course: 1 Hour, 36 Minutes

• Course Introduction
• Subqueries Overview
• Scalar Subqueries
• Writing Effective Scalar Subqueries
• Multi-valued Subqueries

Microsoft SQL Server 2016: Querying

Course: 1 Hour, 35 Minutes

• Course Introduction
• UNION vs. UNION ALL Operators
• Writing Queries That Use the UNION Operator
• Writing Queries That Use the UNION ALL Operator
• Mixed UNION and UNION ALL Operators

Microsoft SQL Server 2016: Querying

Course: 1 Hour, 57 Minutes

• Course Introduction
• Understanding Stored Procedures
• Using Stored Procedures
• Input parameters
• Output parameters
• Table-valued Functions
• Scalar-valued User-defined Functions
• TRY...CATCH Error Handling
• RAISERROR Statements

•TestPrep 70-761 Querying Data with Transact SQL  Test your knowledge on the skills and competencies measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.

Developing SQL Databases (exam 70-762)19:38 hours

SQL Server 2016 Database Objects

Course: 1 Hour, 48 Minutes

• Course Introduction
• Creating Tables
• Dropping Tables
• Altering Tables
• Adding and Removing Columns
• Duplicating Tables
• Renaming Tables
• Constraints
• Naming Conventions

Microsoft SQL Server 2016: Developing

Course: 2 Hours, 5 Minutes

• Course Introduction
• Index Design Basics
• Tables Without Clustered Indexes
• Clustered vs. Nonclustered Indexes
• Creating Clustered Indexes
• Creating Nonclustered Indexes
• Creating Unique Indexes
• Creating Filtered Indexes
• Creating Indexes with Included Columns
• Deleting Indexes
• Modifying Indexes

Microsoft SQL Server 2016: Developing

Course: 1 Hour, 33 Minutes

• Course Introduction
• Columnstore Index Overview
• When to Implement a Columnstore Index
• Creating a Clustered Columnstore Index
• Columnstore Indexes Data Loading
• Columnstore Versioned Feature Summary
• Columnstore Indexes Query Performance
• Columnstore for Real-time Operational Analytics
• Columnstore Indexes for Data Warehousing
• Columnstore Indexes Defragmentation

Microsoft SQL Server 2016: Developing

Course: 2 Hours, 29 Minutes

• Course Introduction
• Types of Data Integrity
• Enforcing Data Integrity
• Entity and Referential Integrity

Microsoft SQL Server 2016: Developing Triggers and Functions

Course: 1 Hour, 55 Minutes

• Course Introduction
• Creating DML Triggers
• Creating CLR Triggers
• DML Trigger Security
• Implementing DDL Triggers
• Gathering DDL Trigger Information
• DDL Events and Event Groups
• Implementing Triggers
• Specifying First and Last Trigger
• Managing Transactions in Logon Triggers
• Disabling Logon Triggers
• AFTER Trigger
• INSTEAD Trigger

Microsoft SQL Server 2016: Developing

Course: 1 Hour, 43 Minutes

• Course Introduction1
• Transactions
• BEGIN TRANSACTION
• COMMIT TRANSACTION
• COMMIT WORK
• ROLLBACK TRANSACTION
• ROLLBACK WORK
• SAVE TRANSACTION
• DML Statements and Transactions
• Transactions in High-concurrency Databases
• Explicit Transactions
• Implicit Transactions

Microsoft SQL Server 2016: Developing

Course: 1 Hour, 47 Minutes

• Course Introduction
• Locking Basics
• Concurrency Effects
• Understanding Deadlocks
• Minimizing Deadlocks
• Handling Deadlocks
• Remediating Deadlocks
• Troubleshooting Locking Issues
• Lock Escalation Behavior

Microsoft SQL Server 2016: Developing

Course: 1 Hour, 59 Minutes

• Course Introduction
• Creating Statistics
• Modifying Statistics
• Viewing Statistics Properties
• Updating Statistics
• Maintenance Tasks

Microsoft SQL Server 2016: Developing

Course: 2 Hours, 12 Minutes

• Course Introduction
• Workloads
• Resource Governor
• Enabling Resource Governor
• Configuring Resource Governor
• Creating a Resource Pool
• Creating a Workload Group
• Disabling Resource Governor
• Memory Configuration

Microsoft SQL Server 2016: Developing

Course: 2 Hours, 7 Minutes

• Course Introduction
• Performance Metrics
• Performance Baseline
• Performance Monitor
• Dynamic Management Objects
• Troubleshooting Performance Issues
• Azure SQL Database Performance