SQL Server 70-761: Querying Data with Transact-SQL
Course Features
Duration
12.51 hours
Delivery Method
Online
Available on
Limited Access
Accessibility
Desktop, Laptop
Language
English
Subtitles
English
Level
Intermediate
Teaching Type
Self Paced
Video Content
12.51 hours
Course Description
Course Overview
International Faculty
Post Course Interactions
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