SQL Server 70-761: Querying Data with Transact-SQL

Course Cover
compare button icon

Course Features

icon

Duration

12.51 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

12.51 hours

Course Description

Nearly 13 hours of expert video instruction
This video course will guide you through the concepts and skills necessary to manage data with SQL Server 2016 & Transact-SQL. It also prepares you for Microsoft's MCSA Exam 70-761. Marilyn White, a T-SQL expert and Microsoft Certified Training Trainer, presents almost 13 hours of video lessons that are fully aligned with Microsoft's official exam topics. There are 43 video lab walk-through demonstrations and downloadable.sql file downloads for extensive practice. There is no better way to learn the core skills of T-SQL data and querying, as well as basic programming.
Marilyn White, a renowned SQL Server trainer, guides you through every concept that you need to be able to manage data using Transact-SQL (T–SQL) in the SQL Server 70-761 video training course. This course will prepare you for Microsoft's Exam 761, which is the first of two required exams for Microsoft Certified Solutions Associate (MCSA), certification in SQL Server 2016 Database Development.
You will learn through 11 well-organized video lessons, 100 concise sublessons and 43 lab walk-through demonstrations. Each lesson includes downloadable.sql files that you can open and run on your computer. Each lesson corresponds with a major topic that Microsoft requires to master the exam 70-761 "Skills Measurable" list.
White starts by explaining the SQL Server 2016 tools, concepts, and techniques you will need to work with data. Next, she discusses advanced T-SQL components to query data and teaches essential techniques for programming databases using T-SQL.
This course is ideal for all SQL Server database professionals who are currently working or aspiring to be SQL Server database professionals. It combines hands-on MCSA 70-761 exam prep with real-world skills-building for data management.

Course Overview

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Requires a basic working knowledge of databases

What You Will Learn

Avoid common errors in writing T-SQL statements and programs

Choose, implement, and convert data types

Create sophisticated queries by using T-SQL components

Establish data types and NULLS

Group, pivot, and unpivot data to gain deeper insights

Implement error handling and transaction control

Manage relational, non-relational, and temporal data

Modify data with INSERT, UPDATE, DELETE, and DML OUTPUT statements

Navigate and efficiently use Microsoft’s SQL Server data management tools

Plan and build efficient queries that satisfy business requirements

Program databases with stored procedures, user-defined functions, and views

Query and output JSON or XML data

Retrieve the right data from multiple tables by writing proper JOIN statements

Use powerful T-SQL functions and understand their performance impact

Target Students

For all working and aspiring database professionals in Microsoft SQL Server environments, especially those pursuing the Microsoft Certified Solutions Associate (MCSA): SQL Server 2016 Database Development certification

Course Cover