SQL SERVER DBA

SQL SERVER DBA

We are providing Exclusive Training on SQL SERVER DBA by Faculty from top MNC’s with highly skilled domain expertise will train & guide you with real time applications and case studies. We also help you in resume preparation and provide job assistance till you get job.

Key features

v  SQL SERVER DBA

v  Case studies

v  Exercises

v  Sample applications

v  Resume preparation and more

Our training features:

ü  You will receive top quality instruction that weare famousfor online trainings.

ü  Training from professional experts with Real time project scenarios and  real-time examples

ü  Excellent course material will be provided

ü  State-of-the-art lab with required software for practicing

ü  Resume preparation and job assistance

COURSE TOPICS:

SQL Server DBA Online TrainingCourse Duration - 45 Days  

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 issues
• Monitoring Jobs
• Monitoring Tables
• Log Shipping
• Mirroring
• Replication
• Clustering

                                             HIGH AVAILABILTY CONCEPTS

Module1:  Log Shipping

• Log Shipping
• Working with Log Shipping
• Terminology
• Pre-requisites to implement Log Shipping
• Different modes of Log Shipping
• Configuring Log Shipping
• Monitoring
• Manually Performing Failover
• Log Shipping Tables
• Discussing Real Time Scenarios

Module2:  Database Mirroring

• Working with Database Mirroring
• Terminology
• Pre-requisites to implement Mirroring
• Pre check mirroring ports ENABLED or DISABLED
• Architecture
• Operating Modes
• Differences between Modes
• Port numbers involved in Mirroring
• Requirements for Mirroring
• Configuring Mirroring
• Mirroring failover
• Issues on Mirroring

Module3:  Replication

• Working with Replication
• Terminology
• Pre-requisites to implement to Replication
• Types of Replications
• DISTRIBUTOR Database
• Agents involved in Replication
• Configuring Replication
• Resolving Issues

Module4: Clustering

• Introduction about clustering
• Clustering Architecture
• Importance of IP’s involved in Clustering
• SAN importance
• Drive dependency
• Nodes in Clustering
• Important commands

    ** DIFFERENCES BETWEEN ABOVE HIGH AVAILABILTY CONCEPTS**

                                      ADVANCED CONCEPTS

Module1:  Monitoring Tools

• System Monitor
• SQL Server Profiler
• SQL Server and Windows Error Logs

Module2:  Database Performance Tanning

• Indexes
• Types of indexes
• Fragmentation in Indexes
• Types of Fragmentations
• Database Tuning Advisor
• Dead Locks
• Blockings
• Terminating Processes

Module3:  Managing the SQL Server and Databases

• Starting SQL Server in Single user mode
• Changing the Default path of Database files
• Modifying the Logical and Physical names of database files

High Lights:

• Discussions on Real time scenarios
• Replying to Questioner mails on subject doubts
• Resume Preparations
• Providing material  

 Call Us : 08019871850
 Mail Us : infoprofessionalonlinetraining@gmail.com