This course is from the Exam 70-761 series-

1. Basic Database Concepts

2. Manage data with Transact-SQL

3. Query data with advanced Transact-SQL Components

4. Program Database by using Transact-SQL

In this part of the course series, you will learn about-

• What are T-SQL Select Queries?

• Query Multiple Tables Using Joins

• Implement functions and aggregate data

• How to Modify Data

• Query Data Using Subquery and APPLY

• Query Data Using Table Expression

• About Group and Pivot Data

• About Constraints