- Home
- Video Courses
- 70-761 (Querying Data with Transact-SQL)
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.
141
66
6 h
4.5
Price $32.99
Today $29.99
Curriculum for 70-761 Video Course
1. Welcome
1 Lectures
00:03:14
2. Getting Started
4 Lectures
00:17:11
3. Databases
5 Lectures
00:27:11
4. SQL Server 2016
5 Lectures
00:31:31
5. Basic Select Statements
7 Lectures
00:47:12
6. Advanced Select...
8 Lectures
00:54:57
7. Querying Multiple...
6 Lectures
00:40:12
8. Grouping Data
5 Lectures
00:35:25
9. Modifying Data
8 Lectures
00:47:48
10. Programming Objects...
9 Lectures
00:56:58
11. User-Defined Functions
3 Lectures
00:17:55
12. Understanding...
4 Lectures
00:20:24
13. Course Summary
1 Lectures
00:05:27
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
5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.5
Similar Courses
19 Lectures
1 h
28 Lectures
2 h
103 Lectures
10 h
93 Lectures
8 h
92 Lectures
8 h
106 Lectures
9 h
117 Lectures
8 h
657 Lectures
5 h
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.
- Trusted by 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo
