Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Database Administration - Certificate Program (Online On Demand Course)
Introduction
Welcome (3:27)
Introduction to databases and database management systems (6:02)
Who is a database administrator (11:38)
Quiz
Installing, patching and upgrading SQL Server
SQL Server Evolution (11:30)
Install SQL Server 2014 (9:16)
How to patch a SQL Server instance (4:41)
Upgrade SQL 2014 to 2016 (5:15)
Quiz
SQL Server database architecture & configuration
Introduction to database internals & architecture (9:17)
Introducing SQL Server Recovery Models (5:59)
SQL Server system databases (3:38)
Creating a database in SQL Server (2:40)
SQL data and transaction log files (3:42)
Configure data file initial size and auto grow settings (4:02)
Create a filegroup (2:40)
Adjust database compatibility level (1:27)
Configure SQL recovery model (1:53)
Adjust database state (6:41)
Creating a table (7:21)
Add records to a table. Introducing mockdata from mockaroo (10:33)
Quiz
Designing SQL Server Security
Introduction to SQL Server Security (15:00)
Create logins in SQL Server (8:07)
Quiz
Disaster Recovery
How to backup your databases (6:29)
Backup to multiple files & copy only backup (4:29)
Configuring backups using maintenance plans (8:12)
Restore database from backup (6:56)
Creating a SQL Server Agent jobs (8:28)
Quiz
Monitoring SQL Server & Performance tuning/ optimization
Introduction to SQL Server Monitoring (15:12)
Monitoring using task manager, performance monitor and windows logs (9:54)
Monitoring SQL Server - Activity Monitor (3:13)
Mnitoring SQL Server - sp_who2 (7:06)
Monitoring SQL Server - SQL Server logs (5:34)
Monitoring SQL Server - SQL Server profiler (10:05)
Optimizing SQL Server - Introduction (9:14)
Creating indexes (5:15)
Index maintenance (5:27)
Optimizing SQL Server - Query execution plan (6:16)
Optimizing SQL Server - Database engine tuning advisor (6:21)
Optimizing SQL Server - DMVs (3:52)
Quiz
Virtualizing SQL Server
Install vmware workstation (6:13)
Create a new virtual machine (8:18)
Configure vmware - part 1 (8:30)
Configure vmware - part 2 (9:46)
High Availability
Understanding Replication (8:35)
Configure SQL Server replication (6:54)
Understanding Transaction log shipping (5:41)
Configure transaction log shipping (5:38)
Understanding database mirroring (6:34)
Configure database mirroring (4:23)
Understanding SQL Server Failover Clustering (7:10)
Failover clustering - configure shared drive (15:05)
Failover clustering - configure windows failover cluster (7:23)
Failover clustering - configure SQL Server cluster (18:41)
Understanding AlwaysOn Availability Groups (9:06)
High Availability - configure AlwaysON availability groups (18:16)
High Availability Summary (6:26)
Quiz
Bonus section
Steps to uninstall SQL Server 2014 (3:04)
Steps to uninstall SQL Server 2016 (2:02)
Uninstall SQL Server failover cluster (5:20)
Conclusion
Congratulations (1:08)
Mnitoring SQL Server - sp_who2
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock