AkiraIT Solutions

Address : HNo:3-7, 4th Floor, Syndicate Bank Building, Nizampet, Hyderabad - 500090 India

Landmark : 4th Floor, Syndicate Bank Building, Nizampet, Hyderabad

City : Hyderabad-500090

Area : HYDERABAD

Phone No. : XXXXXXXXXX

Mobile No. : XXXXXXXXXX

Website : akirait.com/

Institute ID : TK1224

Sql Online Training in Hyderabad by AkiraIT Solutions

Last Updated on : 20 Dec 2017 12:39PM

Sql Online Training in Hyderabad (IT-Training)

About Course

Course Content

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
	Instances
	CASE STUDIES
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
	CASE STUDIES
Module 3	Working With Data Bases
	Working With Data Bases
	Database Architecture
	Creating Databases
	Adding Files and File groups
	CASE STUDIES
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
	CASE STUDIES
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
	CASE STUDIES
Module 6	Automating Administrative Tasks
	Working With database mails
	Configuring Linked Servers
	Creating SQL Server Jobs
	Maintenance Plans
	CASE STUDIES
Module 7	High Availability
	Working With Log shipping
	Features of Log shipping
	Configuring Log shipping
	Monitoring Log shipping
	Jobs
	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
	Configuring
	Monitoring
	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
	Requirements
	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 Get More:http://akirait.com/sql-dba-training/

Course For Training Courses

Course Categories Practitioners Approach To Project Management,

SQL

SQL DBA