- Home
- Video Courses
- 70-764 (Administering a SQL Database Infrastructure)
70-764: Administering a SQL Database Infrastructure
Your Microsoft 70-764 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-764 certification test. Ace your Microsoft 70-764 at the first attempt and obtain the Administering a SQL Database Infrastructure credential with ease.
123
77
9 h
4.5
Price $32.99
Today $29.99
Curriculum for 70-764 Video Course
1. Welcome
1 Lectures
00:02:31
2. Getting Started
4 Lectures
00:26:27
3. SQL Server Basics
5 Lectures
00:35:51
4. SQL Server 2016
5 Lectures
00:36:10
5. SQL Server Security
11 Lectures
01:19:33
6. SQL Server Roles
6 Lectures
00:36:01
7. Encryption
11 Lectures
01:23:07
8. Index Management
6 Lectures
00:43:37
9. Backup And Restore
14 Lectures
01:48:29
10. Monitoring SQL Server
13 Lectures
01:33:52
11. Course Summary
1 Lectures
00:06:02
Welcome
| Video Name | Time | |
|---|---|---|
| 1. Introduction | 02:31 |
| Video Name | Time | |
|---|---|---|
| 1. Introduction | 07:05 | |
| 2. Microsoft's SQL Server | 08:11 | |
| 3. SQL Server 2016 Certifications | 07:54 | |
| 4. Examples | 03:17 |
| Video Name | Time | |
|---|---|---|
| 1. Introduction | 07:20 | |
| 2. SQL Server Editions | 06:15 | |
| 3. Understanding Databases | 08:18 | |
| 4. Database Structures | 08:21 | |
| 5. Transact-SQL | 05:37 |
| Video Name | Time | |
|---|---|---|
| 1. Introduction | 08:15 | |
| 2. Installing SQL Server 2016 | 10:26 | |
| 3. Installing SQL Server Management Studio | 04:47 | |
| 4. Attaching The Sample Database | 07:35 | |
| 5. Verifying The Installation | 05:07 |
| Video Name | Time | |
|---|---|---|
| 1. Introduction | 07:29 | |
| 2. Server Level Security | 08:50 | |
| 3. Restarting SQL Server | 05:14 | |
| 4. Creating Logins | 07:55 | |
| 5. Database Level Security | 06:49 | |
| 6. Database User Account Types | 08:27 | |
| 7. Cross Server Authorization | 07:51 | |
| 8. Partially Contained Databases | 06:25 | |
| 9. Dynamic Data Masking | 06:47 | |
| 10. DDM Example - 1 | 05:43 | |
| 11. DDM Example - 2 | 08:04 |
| Video Name | Time | |
|---|---|---|
| 1. Introduction | 07:33 | |
| 2. Fixed Server Roles | 06:25 | |
| 3. Fixed Database Roles | 05:30 | |
| 4. User-Defined Roles | 06:04 | |
| 5. Grant, Revoke, And Deny | 04:37 | |
| 6. Schema Level Permissions | 05:52 |
| Video Name | Time | |
|---|---|---|
| 1. Introduction | 10:00 | |
| 2. SQL Server Encryption Basics | 08:25 | |
| 3. Dark Side Of Encryption | 07:00 | |
| 4. Asymmetric Vs. Symmetric | 06:25 | |
| 5. Encryption Options | 06:15 | |
| 6. Encrypting Backups - 1 | 07:13 | |
| 7. Encrypting Backups - 2 | 06:18 | |
| 8. Transparent Data Encryption | 07:31 | |
| 9. Implementing TDE | 08:26 | |
| 10. Always Encrypted | 09:47 | |
| 11. Implementing Always Encrypted | 05:49 |
| Video Name | Time | |
|---|---|---|
| 1. Introduction | 10:17 | |
| 2. Index Management Basics | 04:16 | |
| 3. Identifying Fragmentation | 06:45 | |
| 4. Repairing Fragmentation | 06:20 | |
| 5. Database Engine Tuning Advisor - 1 | 10:44 | |
| 6. Database Engine Tuning Advisor - 2 | 05:15 |
| Video Name | Time | |
|---|---|---|
| 1. Introduction | 09:50 | |
| 2. Backup Types | 07:40 | |
| 3. Understanding Recovery Models | 09:49 | |
| 4. Copy-Only Backups | 10:12 | |
| 5. Backup Terminology | 05:42 | |
| 6. System Database Backups | 06:47 | |
| 7. Transaction Log Basics | 09:22 | |
| 8. Transaction Log Backups | 08:58 | |
| 9. Tail-Log Backups | 04:38 | |
| 10. Restoring Databases | 10:52 | |
| 11. Restoring With SSMS | 05:00 | |
| 12. Recovering The Master DB | 07:39 | |
| 13. Point In Time Recovery | 06:25 | |
| 14. Understanding Log Shipping | 05:36 |
| Video Name | Time | |
|---|---|---|
| 1. Introduction | 10:10 | |
| 2. Performance And Monitoring | 05:48 | |
| 3. Session Identification Overview | 07:38 | |
| 4. Identifying Blocking Sessions - 1 | 09:34 | |
| 5. Identifying Blocking Sessions - 2 | 05:51 | |
| 6. Understanding UCPs | 07:49 | |
| 7. Data Collector Basics | 05:26 | |
| 8. Data Collector Configuration | 07:40 | |
| 9. Query Store Basics | 08:25 | |
| 10. Understanding Extended Events | 06:46 | |
| 11. Creating An Extended Event - 1 | 08:52 | |
| 12. Creating An Extended Event - 2 | 02:43 | |
| 13. Editing An Extended Event | 07:11 |
| Video Name | Time | |
|---|---|---|
| 1. Summary | 06:02 |
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
