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

SQL Server 70-761: Querying Data with Transact-SQL | Livelessons
English | Size: 16.29 GB
Genre: eLearning

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.

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

Who Should Take This Course

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

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9

Leave a Comment Cancel reply