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.
Curriculum for 70-764 Video Course
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
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