
Exam 70-764: Administering a SQL Database Infrastructure
As competing database platforms experience slow growth or even loss of marketshare, Microsoft's SQL Server 2016 database platform marketshare continues to expand. rnrnObtaining certification on the SQL Server 2016 data platform is a great way to get the attention of potential employers or to move to higher levels in your current career.rnrnSQL Server 2016 provides many new and enhanced functionalities that continue to change how database technologies are being used to capture, manage, and deliver data in today's data-centric environment.rnrnYou can achieve an MCSA: SQL 2016 Database Administration certification by passing exams 70-764 which is covered in this course, along with exam 70-765, Provisioning SQL Databases, also available from VTC.rnrnIn this course, Mark Long brings over 20 years of experience with SQL Server along to help you get acquainted with SQL Server 2016 and help you get prepared to take the 70-764 exam.rn
Course content
Welcome/Intro5 lessons
SQL Server 2016 Essentials4 lessons
Installing SQL Server10 lessons
- Getting Hands on with SQL Server 2016 pt. 16:46Free
- Getting Hands on with SQL Server 2016 pt. 24:44Free
- Installing SQL Server 2016 pt. 17:02Free
- Installing SQL Server 2016 pt. 27:21Free
- Verifying the Installation5:45Free
- Getting SSMS3:57Free
- Attaching the Sample dB pt. 16:07Free
- Attaching the Sample dB pt. 24:34Free
- Getting Help6:59Free
- MMC6:22Free
SQL Server Basics14 lessons
- Understanding Databases6:571 credit or ad
- Table Basics5:001 credit or ad
- Understanding Primary Keys5:051 credit or ad
- Understanding Data Types pt. 17:191 credit or ad
- Understanding Data Types pt. 27:261 credit or ad
- Understanding Normalization5:171 credit or ad
- Creating a Database7:131 credit or ad
- Database Types6:591 credit or ad
- System Databases pt. 17:271 credit or ad
- System Databases pt. 25:421 credit or ad
- Database Files7:131 credit or ad
- Understanding Transaction Logs5:251 credit or ad
- Understanding Schemas5:301 credit or ad
- Understanding Synonyms3:361 credit or ad
SQL Server Security17 lessons
- Securing SQL Server6:561 credit or ad
- Principals and Securables6:151 credit or ad
- Principal and Securable Hierarchy3:401 credit or ad
- Authentication Modes pt. 16:141 credit or ad
- Authentication Modes pt. 23:201 credit or ad
- Understanding Permissions5:081 credit or ad
- Monitoring Permissions6:151 credit or ad
- Understanding Roles4:471 credit or ad
- Fixed Server Roles5:531 credit or ad
- Managing Fixed Server Roles4:241 credit or ad
- Fixed Database Roles3:051 credit or ad
- User-Defined Roles4:521 credit or ad
- Row-Level Security6:071 credit or ad
- Row-Level Security Example pt. 17:031 credit or ad
- Row-Level Security Example pt. 27:201 credit or ad
- Dynamic Data Masking6:081 credit or ad
- Dynamic Data Masking Example6:361 credit or ad
Encryption8 lessons
- SQL Server Encryption7:181 credit or ad
- Always Encrypted pt. 16:581 credit or ad
- Always Encrypted pt. 26:341 credit or ad
- Backup Encryption pt. 15:391 credit or ad
- Backup Encryption pt. 24:151 credit or ad
- Transparent Data Encryption6:471 credit or ad
- Always Encrypted vs. TDE3:351 credit or ad
- Encryption for Connections7:141 credit or ad
Automating SQL Server 201610 lessons
- SQL Server Agent6:111 credit or ad
- Understanding Automated Administration7:231 credit or ad
- Jobs, Operators, Schedules & Alerts pt. 17:231 credit or ad
- Jobs, Operators, Schedules & Alerts pt. 25:391 credit or ad
- Multiserver Administration6:311 credit or ad
- Using The Maintenance Plan Wizard5:091 credit or ad
- Policy Based Management5:381 credit or ad
- Policy Evaluation Modes2:331 credit or ad
- Create a Table Naming Policy pt. 17:291 credit or ad
- Create a Table Naming Policy pt. 23:521 credit or ad
Managing Indexes10 lessons
- Index Basics5:281 credit or ad
- Clustered Indexes6:091 credit or ad
- Pages and Extents6:301 credit or ad
- Understanding FillFactor5:041 credit or ad
- Nonclustered Indexes7:071 credit or ad
- Optimizing Indexes7:301 credit or ad
- Reorganizing and Rebuilding Indexes pt. 17:071 credit or ad
- Reorganizing and Rebuilding Indexes pt. 23:261 credit or ad
- Columnstore Indexes5:281 credit or ad
- Managing Columnstore Indexes4:151 credit or ad
Performance and Monitoring11 lessons
- Performance and Monitoring Basics3:171 credit or ad
- Monitoring Current Sessions5:371 credit or ad
- Database Consistency Checks6:411 credit or ad
- Recovering from Corruption4:501 credit or ad
- Identify TempdB Usage6:001 credit or ad
- Configure the Data Collector pt. 16:341 credit or ad
- Configure the Data Collector pt. 24:531 credit or ad
- Utility Control Point7:141 credit or ad
- Capturing Query Plans4:101 credit or ad
- Managing the Query Store5:021 credit or ad
- Using the Query Store5:591 credit or ad