SQL Server DBA - Installing and Configuring SQL Server

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 see how to download and install SQL Server engine and SSMS. We will also see how we can connect to the SQL engine and made first time configurations.

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