SQL DBA Training

SQL DBA Training Overview:

  • This SQL Online Training teaches developers all the Transact-SQL skills they need to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server.  Gives idea about writing Queries & Sub-queries, working with Joins, etc. As well as database management skills like backup, restore, etc.
  • Today we cannot imagine our life, our business without proper database. We always like to analysis data and get report from data so that they can manage their life and their organization in proper order. That means that there is highly demand of database. database is not only important for storing the data in proper order .Beside this there is also numbers of application where it pays the big roles to perform efficiently. here are some point that he mention there
  • Easy access to data
  • Easy integration and reporting the data
  • Easy sharing of information.
  • Powerful analysis of information.
  • Massive Scale
  • Ready for future.
Module Name Topic Details
Module  1 Starting with SQL Server
DBA Responsibilities
History of SQL Server -Versions
SQL Server 2005/2008/2008 R2/2012 Service Packs
Editions of SQL Server
Tools of SQL Server
Hardware/Software Requirements
Module 2 Installing and Configurations
Installing SQL Server 2005/2008/2012
Pre -Installations steps
Post-Installations steps
Installing Service packs
Configuring Various Services
Startup Parameters
Module 3 Working With Data Bases
Working With Data Bases
Database Architecture
Creating Databases
Adding Files and File groups
Module 4 Implementing Security
Security In SQL Server 2008/2012
Types of Authentications
Understanding Server Roles/ Data Base Roles
Working with Users
Resolving Orphan users
Module 5 Backup and Restoration
Backup Types
Why we need backups
Setting Recovery Model
Understandings T-log architecture
Truncating Log file
Backup System databases
Backup Devices
Performing Restoration
Module 6 Automating  Administrative Tasks
Working With database mails
Configuring Linked Servers
Creating SQL Server Jobs
Maintenance Plans
Module 7 High Availability
Working With Log shipping
Features of Log shipping
Configuring Log shipping
Monitoring Log shipping
Log shipping Tables and Stored Procedures
Working With Replication
Configuring Replication
Types of replications
Replication agents
Managing Replication
Monitoring Replication
Working With Mirroring
Requirements of Mirroring
Servers Involved in Mirroring
Types of Mirroring
Mirroring failover
Hands on
Module 8 Advanced administrations Concepts
Maintenance Plans
Monitoring Tools
Trouble Shooting
Monitoring and Tuning SQL Server
SQL Server Architecture
Managing Data bases
SQL Server Up gradations
Using DBCC Commands
Module 9 Clustering SQL Server
Introduction To Cluster Environment
Overview Of windows clustering
Installing and configuring
Applying Service packs and Hot fixes
Patching clustered Instances
Module 10 SQL Server 2014 DBA Concepts
Introduction to SQL server 2014/2016
Always on (HA/DR) Features
Contained databases
New Updated DMVs