Microsoft SQL Server 2016: Querying Data with Transact-SQL - 70-761
Microsoft SQL Server 201618 H 16 M
From your very first query, to crafting the most advanced server-side procedures, this Transact-SQL course will get you working with Microsoft SQL servers in no time.
Episodes
Episodes
- Querying Data with T-SQL
- Overview
- Introduction to Transact-SQL
- Introduction to Transact-SQL Part 2
- Retrieving Data with SELECT
- Retrieving Data with SELECT Part 2
- Combining Results with JOIN
- Combining Results with JOIN Part 2
- Combining Results with JOIN Part 3
- Modifying Data with T-SQL
- Adding Data with INSERT
- Changing Data with UPDATE
- Removing Data with DELETE
- Recording Changes with OUTPUT
- Working with Functions
- Querying Data with Functions
- Querying Data with Functions Part 2
- Aggregating Data
- Performing Arithmetic
- Working with Dates
- System Functions
- Working with Data Types
- Data Types
- Data Types Part 2
- Custom Data Types
- Converting Data Types
- Converting Data Types Part 2
- Conditions and Nulls
- Programming Databases with T-SQL
- User Defined Functions
- Stored Procedures
- Creating Views
- Transactions
- Transactions Part 2
- Error Handling
- Error Handling Part 2
- Advanced Transact-SQL
- Subqueries
- Subqueries Part 2
- Grouping Sets and Cubes
- Grouping Sets and Cubes Part 2
- Ranking Data with Window Functions
- Ranking Data with Window Functions Part 2
- Pivot and Unpivot Data
- Table Expressions and Apply
- Working with JSON and XML
- Working with XML
- Working with JSON
Overview
8 M



- Episode Description
- Transcript
This course introduces viewers to Microsoft Transact-SQL, the language used to input and retrieve data from Microsoft SQL servers. The series is designed for viewers of all experience levels as it walks through running your very first query all the way through crafting advanced server-side stored procedures.
Just you? Training a whole team? There's an ITProTV plan that fits.
With more than 5,800 hours of engaging video training for IT professionals, you'll find the courses you and your team need to stay current and get the latest certifications.