by Mark Long | Released January 2017 | ISBN: 9781491978429

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 ServerMark 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. Show and hide more Publisher resources Download Example Code

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. User-Defined Functions
    • Function Basics 00:04:50
    • Understanding Scalar Functions 00:06:52
    • Table-Valued Functions 00:06:10
11. Understanding Subqueries
    • Subquery Basics 00:02:45
    • Scalar Subqueries 00:04:54
    • Multi-Valued Subqueries 00:06:19
    • Correlated Subqueries 00:06:23
12. Conclusion
    • Wrap Up 00:05:27
Show and hide more