SQL Server DBA - Understanding System Database

In this video series, we will discuss SQL Server administration topics and see how to implement them in SQL Server.

We will start by installing and configuring SQL Server and will go up-to the most advanced topics of security, replication and mirroring.

In this video, we will discuss about the different system databases available in SQL that will come with SQL server installation by default.

SQL Server editions
Install and configure SQL Server
Understanding system databases
Types of queries
Normalization
Database objects
Data attributes and constraints
Backup and recovery options
Security
SQL Server agent
Server management tools
Performance optimization tools
Different database status
Isolation models
Replication
Mirroring