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

MP4 | Video: AVC 1280x720 | Audio: AAC 48KHz 2ch | Duration: 13 Hours | 22.5 GB

Genre: eLearning | Language: English

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 102 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.

Learn How To

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