Course Overview

This complete video course guides you hands-on through all the concepts and skills you’ll need to manage data effectively with SQL Server 2016 and Transact-SQL, and prepare for Microsoft’s MCSA Exam 70-761. T-SQL expert and Microsoft Certified Trainer Marilyn White presents nearly 13 hours of video lessons fully aligned to Microsoft’s official exam topics, including 43 video lab walk-through demos with downloadable .sql files for extensive realistic practice. There’s no better way to master the core techniques of T-SQL data management, querying, and basic programming.

Description

In the SQL Server 70-761: Querying Data with Transact-SQL LiveLessons video training course, renowned SQL Server trainer Marilyn White guides you through every concept and skill you’ll need to effectively manage data with Transact-SQL (T-SQL). This course is designed to fully prepare you for Microsoft’s Exam 70-761, the first of two exams required for Microsoft Certified Solutions Associate (MCSA) certification on SQL Server 2016 Database Development.

You’ll learn through 11 well-organized video lessons and 100 concise sublessons, including 43 lab walk-through demonstrations with downloadable .sql files you can explore and run on your own. Organized to reflect Microsoft’s official Exam 70-761 “Skills Measured” list, each lesson corresponds to a major topic required by Microsoft for mastery.

White begins by introducing the SQL Server 2016 tools and concepts you’ll need to work successfully with data. Next, she turns to advanced T-SQL components for querying data, and introduces essential techniques for programming databases with T-SQL.

Ideal for all working and aspiring SQL Server database professionals, this course combines incomparable hands-on MCSA 70-761 exam preparation with practical skill-building for real-world data management.

What You Will Learn

• Navigate and efficiently use Microsoft’s SQL Server data management tools
• Plan and build efficient queries that satisfy business requirements
• Manage relational, non-relational, and temporal data
• Retrieve the right data from multiple tables by writing proper JOIN statements
• Modify data with INSERT, UPDATE, DELETE, and DML OUTPUT statements
• Use powerful T-SQL functions and understand their performance impact
• Group, pivot, and unpivot data to gain deeper insights
• Query and output JSON or XML data
• Create sophisticated queries by using T-SQL components
• Program databases with stored procedures, user-defined functions, and views
• Implement error handling and transaction control
• Choose, implement, and convert data types
• Establish data types and NULLS
• Avoid common errors in writing T-SQL statements and programs