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

Nearly 13 Hours of Expert Video Instruction

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.

About the Instructor

Marilyn White (MCSE, MCTS, MCITP) has 20+ years of IT experience, and has worked with Microsoft Server products as a Microsoft Certified Trainer (MCT) for more than 18 years. For most of that time, she has specialized in SQL Server and SharePoint. She owns White & White Consulting, a New Jersey-based consultancy specializing in systems training and solutions. White has presented at Microsoft launch events for SQL Server and Visual Studio, and served as Technical Learning Guide at Microsoft events. She has authored three Microsoft certification study guides on SQL Server and SharePoint, as well as the video course MCSA Querying Microsoft SQL Server 2012 (Exam 70-461) LiveLessons. White holds a master’s degree in education.

Skill Level

• All levels

• 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

• 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

• Requires a basic working knowledge of databases