Module1: Starting with SQL Server
Responsibilities of Database Administrator
Types of DBAs
History of SQL Server
Editions of SQL Server
Tools of SQL Server
Differences between Standard and Enterprise editions
Instances types in SQL Server
Default Instance
Named Instance
SQL Server Services
Instance aware services
Instance unaware services
Module2: Installing SQL Server
Pre-requisites
Installation
Post Installation verification Session
Module3: Functioning of Databases
Database
Types of Database and Brief explanation
System Databases
User Database
Database Architecture
Pages
Extents
File groups
Database
Transaction Architecture
Creating Database
Modifying Database
Adding Files
Moving and renaming of Database files
Database modes
Real time Scenario
Module4: Security
Authentication Types in SQL Server
Types of Login
Windows Login
SQL Login
Creating Users and Logins
Server roles
Password policy
Understanding Database and Server Roles
Permissions
Working on access level issues  Show less