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

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

by Mark Long
Released January 2017
Publisher(s): Infinite Skills
ISBN: 9781491978429

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

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.

Table of contents

  1. Introduction
    1. Welcome To The Course
    2. About The Author
    3. Course Overview
    4. Understanding Transact-SQL
    5. SQL Server 2016 Certifications
    6. Examples And Code
  2. Understanding Databases
    1. What Is A Database?
    2. Database Structure And Purpose
    3. Database Terminology
    4. Understanding Data Types
    5. Statement Types
  3. Getting And Installing SQL Server 2016
    1. SQL Server 2016 Editions
    2. Getting SQL Server 2016
    3. Installing SQL Server 2016
    4. Installing SQL Server Management Studio
    5. Attaching The Sample Database
  4. Basic Select Statements
    1. Basic Select Structure
    2. Using The Where Clause
    3. Column Aliasing
    4. Using Distinct
    5. Ordering Results
    6. T-SQL Concatenation
    7. Multipart Naming
  5. Advanced Select Statements
    1. Like And In
    2. Union
    3. Intersect And Except
    4. Paging Results
    5. Understanding Case Expressions Part - 1
    6. Understanding Case Expressions Part - 2
    7. Using Pivot Part - 1
    8. Using Pivot Part - 2
  6. Querying Multiple Tables
    1. Database Structure
    2. Table Relationships
    3. Using The Join Statement
    4. Table Aliasing
    5. Join Types
    6. Join Types Examples
  7. Grouping Data
    1. Using Built-In Functions
    2. Understanding Group By
    3. Understanding Having
    4. Understanding Grouping Sets
    5. Using The Graphical Query Tool
  8. Modifying Data
    1. Inserting Data
    2. Insert Demo
    3. Insert Select
    4. Select Into
    5. Updating Data
    6. Update Demo
    7. Deleting Data
    8. Delete Demo
  9. Programming Objects With T-SQL
    1. Understanding Stored Procs
    2. Stored Procedure Demo
    3. Using Input Parameters
    4. Using Output Parameters
    5. Understanding Table Variables
    6. Understanding CTEs Part - 1
    7. Understanding CTEs Part - 2
    8. Understanding Masking
    9. Masking Demo
  10. User-Defined Functions
    1. Function Basics
    2. Understanding Scalar Functions
    3. Table-Valued Functions
  11. Understanding Subqueries
    1. Subquery Basics
    2. Scalar Subqueries
    3. Multi-Valued Subqueries
    4. Correlated Subqueries
  12. Conclusion
    1. Wrap Up

Product information

  • Title: Querying Data with Transact-SQL - Exam 70-761 Certification Training
  • Author(s): Mark Long
  • Release date: January 2017
  • Publisher(s): Infinite Skills
  • ISBN: 9781491978429