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
Orphan users Finding and Fixing
Important Queries
Module5: Database Backups and Restoration
Database Backups
Why we need backups
Types of Backup
Full Backup
Differential Backup
Transaction Log Backup
Copy-only, Mirrored, Split and Tail log Backups
Differences between backups
Backup Strategy
Understanding how the data moving from Log to Data File, CHECKPOINT
Monitoring the space usage of Log File and fixing
Checking the backup files VALID or CORRUPTED
Backup storage tables
Important Queries
Performing Restorations
Types of Restoration
Attach and Detach
Shrinking files
Module6: Recovery Models of Database
Types of Recovery Models
Full
Bulk Logged
Simple
Differences between Recovery Models
Setting Recovery Models according to the Scenarios with examples
Module7: Automation of SQL SERVER
Working with SQL SERVER Agent
Creating Jobs
Managing Jobs and Resolving i
www.magnifictraining.com - "Oracle scm purchasing Online Training" contact us:info@magnifictraining.com or +919052666559,9052666558 By Real Time Experts from Hyderabad, Bangalore,India,USA,Canada,UK, Australia,South Africa.
