70-761: Querying Data with Transact-SQL
Your Microsoft 70-761 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 70-761 certification test. Ace your Microsoft 70-761 at the first attempt and obtain the Querying Data with Transact-SQL credential with ease.
Curriculum for 70-761 Video Course
Welcome
Video Name | Time | |
---|---|---|
1. Introduction | 03:15 |
Video Name | Time | |
---|---|---|
1. Introduction | 04:09 | |
2. Transact-SQL | 04:49 | |
3. SQL Server 2016 Certifications | 05:04 | |
4. Examples | 03:09 |
Video Name | Time | |
---|---|---|
1. Introduction | 08:10 | |
2. Database Structure and Purpose | 06:21 | |
3. Database Terminology | 05:55 | |
4. Understanding Data Types | 05:07 | |
5. Statement Types | 01:39 |
Video Name | Time | |
---|---|---|
1. Introduction | 04:38 | |
2. Getting SQL Server 2016 | 05:02 | |
3. Installing SQL Server 2016 | 10:32 | |
4. Installing SQL Server Management Studio | 07:01 | |
5. Attaching The Sample Database | 04:20 |
Video Name | Time | |
---|---|---|
1. Introduction | 08:32 | |
2. Using The Where Clause | 06:10 | |
3. Column Aliasing | 04:49 | |
4. Using Distinct | 05:42 | |
5. Ordering Results | 07:18 | |
6. T-SQL Concatenation | 07:32 | |
7. Multipart Naming | 07:10 |
Video Name | Time | |
---|---|---|
1. Introduction | 08:36 | |
2. Union | 07:27 | |
3. Intersect and Except | 07:48 | |
4. Paging Results | 06:25 | |
5. Understanding Case Expressions - 1 | 07:42 | |
6. Understanding Case Expressions - 2 | 04:37 | |
7. Using Pivot - 1 | 07:13 | |
8. Using Pivot - 2 | 05:09 |
Video Name | Time | |
---|---|---|
1. Introduction | 07:38 | |
2. Table Relationships | 08:57 | |
3. Using The Join Statement | 07:04 | |
4. Table Aliasing | 06:25 | |
5. Join Types | 04:00 | |
6. Join Types Examples | 06:09 |
Video Name | Time | |
---|---|---|
1. Introduction | 05:44 | |
2. Understanding Group By | 08:15 | |
3. Understanding Having | 05:39 | |
4. Understanding Grouping Sets | 08:02 | |
5. Using The Graphical Query Tool | 07:47 |
Video Name | Time | |
---|---|---|
1. Introduction | 06:42 | |
2. Insert Demo | 08:05 | |
3. Insert Select | 06:55 | |
4. Select Into | 05:46 | |
5. Updating Data | 04:10 | |
6. Update Demo | 06:45 | |
7. Deleting Data | 03:31 | |
8. Delete Demo | 05:54 |
Video Name | Time | |
---|---|---|
1. Introduction | 08:37 | |
2. Stored Procedure Demo | 06:24 | |
3. Using Input Parameters | 07:33 | |
4. Using Output Parameters | 07:09 | |
5. Understanding Table Variables | 07:23 | |
6. Understanding CTEs - 1 | 05:56 | |
7. Understanding CTEs - 2 | 04:47 | |
8. Understanding Masking | 05:48 | |
9. Masking Demo | 03:22 |
Video Name | Time | |
---|---|---|
1. Introduction | 04:50 | |
2. Understanding Scalar Functions | 06:54 | |
3. Table-Valued Functions | 06:11 |
Video Name | Time | |
---|---|---|
1. Introduction | 02:45 | |
2. Scalar Subqueries | 04:55 | |
3. Multi-Valued Subqueries | 06:20 | |
4. Correlated Subqueries | 06:25 |
Video Name | Time | |
---|---|---|
1. Summary | 05:28 |
Student Feedback
Similar Courses
Only Registered Members can View Training Courses
Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.
Try Free Demo
Try Free Demo
Winter Sale! Get 25% Discount on All Your Purchases!
Enter Your Email Address to Receive Your 25%
OFF Discount Code Plus... Our Exclusive Weekly Deals