Querying Data with Transact-SQL - Exam 70-761 Certification Training Course
Prepare to take the Microsoft 70-761 exam and work towards your MCSA: SQL 2016 Database Development Certification
Duration: 6 hours 47 minutes
Chapter: Introduction
Welcome To The Course
Course Overview
Understanding Transact-SQL
SQL Server 2016 Certifications
Examples And Code
Chapter: Understanding Databases
What Is A Database? 08m 7s
Database Structure And Purpose
Database Terminology
Understanding Data Types
Statement Types
Chapter: Getting And Installing SQL Server 2016
SQL Server 2016 Editions
Getting SQL Server 2016
Installing SQL Server 2016
Installing SQL Server Management Studio
Attaching The Sample Database
Chapter: Basic Select Statements
Basic Select Structure
Using The Where Clause
Column Aliasing
Using Distinct
Ordering Results
T-SQL Concatenation
Multipart Naming
Chapter: Advanced Select Statements
Like And In
Union
Intersect And Except
Paging Results
Understanding Case Expressions Part - 1
Understanding Case Expressions Part - 2
Using Pivot Part - 1
Using Pivot Part - 2
Chapter: Querying Multiple Tables
Database Structure
Table Relationships
Using The Join Statement
Table Aliasing
Join Types
Join Types Examples
Chapter: Grouping Data
Using Built-In Functions
Understanding Group By
Understanding Having
Understanding Grouping Sets
Using The Graphical Query Tool
Chapter: Modifying Data
Inserting Data
Insert Demo
Insert Select
Select Into
Updating Data
Update Demo
Deleting Data
Delete Demo
Chapter: Programming Objects With T-SQL
Understanding Stored Procs
Stored Procedure Demo
Using Input Parameters
Using Output Parameters
Understanding Table Variables
Understanding CTEs Part - 1
Understanding CTEs Part - 2
Understanding Masking
Masking Demo
Chapter: User-Defined Functions
Function Basics
Understanding Scalar Functions
Table-Valued Functions
Chapter: Understanding Subqueries
Subquery Basics
Scalar Subqueries
Multi-Valued Subqueries
Correlated Subqueries
Chapter: Conclusion
Wrap Up
No comments:
Post a Comment