Microsoft SQL Server 2014 - 70-461
Querying Microsoft SQL Server 201419 H 15 M
This course helps certification candidates by describing, discussing, and demonstrating SQL query writing skills in multiple areas to help you prep for the exam.
Episodes
Episodes
- Create database objects
- Overview
- SQL Server Basics
- SQL Server Basics Part 2
- SQL Querying Basics
- Create and Alter Tables
- Create and Alter Views
- Create and Alter Views Part 2
- Create and Alter Views Part 3
- Create and Modify Constraints
- Create and Modify Constraints Part 2
- Create and Alter DML Triggers
- Work with data
- Basic SELECT Queries
- Basic SELECT Queries Part 2
- Query Using JOINS
- Query Using JOINS Part 2
- Implement Subqueries
- Implement Subqueries Part 2
- Implement Subqueries Part 3
- Implement Aggregate Queries
- Implement Aggregate Queries Part 2
- Implement Aggregate Queries Part 3
- Query Using Synonyms, Except and Intersect
- Understand Data Access Technologies
- Work with Conditions and Nulls
- Work with Table Constraints
- Query and Manage XML Data
- Query and Manage XML Data Part 2
- Implement Data Types
- Implement Data Types Part 2
- Modify data
- Create and Alter Stored Procedures
- INSERT, UPDATE and DELETE
- INSERT, UPDATE and DELETE Part 2
- Combine Datasets
- Work with Functions
- Troubleshoot and optimize
- Optimize Queries
- Optimize Queries Part 2
- Optimize Queries Part 3
- Manage Transactions
- Evaluate Different Operations
- Implement Error Handling
Overview
7 M



- Episode Description
- Transcript
In this episode, Daniel and Ronnie give a general overview of what to expect in the upcoming Querying SQL series. They cover topics like who is the intended audience, what the scope of the series will cover, and what are some specific topics that will be addressed.
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.