This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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)
Monitoring using task manager, performance monitor and windows logs
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock
course builder. Create your online course today.
Start now
course builder. Create your online course today.
Start now
course builder. Create your online course today.
Start now