Querying Data with Transact-SQL - Exam 70-761 Certification Training

Video description

Querying Data with Transact-SQL - Exam 70-761 Certification Training

Video description

Microsoft's SQL Server database platform is dominant in the enterprise database marketplace, making those with MS SQL Server skills highly sought after in any job market. Possessing a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Database Development certificate tells employers worldwide that you have these skills. Earning the certificate requires you to pass two exams: The MS 70-761 and the MS 70-762. This course prepares you to pass MS 70-761. MS 70-761 is all about Transact-SQL, the programming language central to working with MS SQL Server.

Designed for those relatively new to the world of MS SQL Server, the course covers the basics of database development and then moves into an easy-to-understand, step-by-step, detailed presentation of how to work with Transact-SQL. This course features lots of hands-on coding with plenty of animations, photos, and screenshots all designed to help you grasp Transact-SQL's underlying concepts and technologies.

Understand and practice everything you need to know to pass the Microsoft 70-761 exam
Understand the basics of database design and its impact on data management
Learn Transact-SQL programming - the knowledge set central to working with MS SQL Server

Mark Long is a long term contributor to O'Reilly Media having authored more than a dozen book and video titles including CompTIA Security+ SY0-401 (2014 Objectives), Windows Presentation Foundation Basics, Learning Windows PowerShell, and Securing Windows Networks. He solves IT issues for numerous Fortune 500 companies as the head of his own consulting company. Mark holds the A+ certification and many others, including Microsoft's MCSE, MCDBA, and MCT.

Publisher resources

Download Example Code

Introduction

Welcome To The Course 00:03:25

About The Author 00:03:43

Course Overview 00:04:09

Understanding Transact-SQL 00:04:49

SQL Server 2016 Certifications 00:05:03

Examples And Code 00:03:08

Understanding Databases

What Is A Database? 00:08:08

Database Structure And Purpose 00:06:20

Database Terminology 00:05:54

Understanding Data Types 00:04:43

Statement Types 00:01:40

Getting And Installing SQL Server 2016

SQL Server 2016 Editions 00:04:37

Getting SQL Server 2016 00:05:01

Installing SQL Server 2016 00:10:29

Installing SQL Server Management Studio 00:06:59

Attaching The Sample Database 00:04:19

Basic Select Statements

Basic Select Structure 00:08:29

Using The Where Clause 00:06:08

Column Aliasing 00:04:48

Using Distinct 00:05:41

Ordering Results 00:07:15

T-SQL Concatenation 00:07:29

Multipart Naming 00:07:09

Advanced Select Statements

Like And In 00:08:33

Union 00:07:25

Intersect And Except 00:07:46

Paging Results 00:06:23

Understanding Case Expressions Part - 1 00:07:39

Understanding Case Expressions Part - 2 00:04:35

Using Pivot Part - 1 00:07:10

Using Pivot Part - 2 00:05:07

Querying Multiple Tables

Database Structure 00:07:36

Table Relationships 00:08:54

Using The Join Statement 00:07:02

Table Aliasing 00:06:24

Join Types 00:04:00

Join Types Examples 00:06:07

Grouping Data

Using Built-In Functions 00:05:42

Understanding Group By 00:08:12

Understanding Having 00:05:37

Understanding Grouping Sets 00:07:59

Using The Graphical Query Tool 00:07:45

Modifying Data

Inserting Data 00:06:40

Insert Demo 00:08:02

Insert Select 00:06:53

Select Into 00:05:45

Updating Data 00:04:09

Update Demo 00:06:43

Deleting Data 00:03:31

Delete Demo 00:05:53

Programming Objects With T-SQL

Understanding Stored Procs 00:08:34

Stored Procedure Demo 00:06:22

Using Input Parameters 00:07:30

Using Output Parameters 00:07:07

Understanding Table Variables 00:07:21

Understanding CTEs Part - 1 00:05:55

Understanding CTEs Part - 2 00:04:45

Understanding Masking 00:05:46

Masking Demo 00:03:21

User-Defined Functions

Function Basics 00:04:50

Understanding Scalar Functions 00:06:52

Table-Valued Functions 00:06:10

Understanding Subqueries

Subquery Basics 00:02:45

Scalar Subqueries 00:04:54

Multi-Valued Subqueries 00:06:19

Correlated Subqueries 00:06:23

Conclusion

Wrap Up 00:05:27

Start your Free Trial

Self paced

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.