SQL DBA training in Hyderabad

Kosmik technologies is the best institute for SQL DBA training in Hyderabad. we offer classroom and online SQL DBA training in Hyderabad by certified faculty. we provide online SQL DBA training institutes in Hyderabad on SQL Server, Managing services, Configuring SQL Server, SQL Server Installation, Security, Migrating SQL server...

SQL DBA Course Content

Introduction to SQL Server 2012

Overview on RDBMS and Beyond Relational

System databases

What is new features in SQL Server 2012

SQL Server Component Overview

Components of SQL Server

Protocols

The Relational Engine

The Query Optimizer

Pages & Extents

Pages

Extents [Uniform & Mixed] Managing Extent Allocations

Tracking Free Space

Files and Filegroups

Primary data files

Secondary data files

Log files

Database Filegroups [Primary & User-defined]

SQL server 2008R2/2012/2014 Installation

Installing SQL Server 2008R2

Planning the System/ Pre-Requisites

Best Practices on Installation

Case Study on Moving System Databases

Upgrading to SQL server

Upgrading the server by applying service packs

SQL Server Upgrade Advisor

In-Place Upgrade to SQL Server 2012

Best Practices to follow while upgrading

Configuring SQL Server

Central Management Services

Best Practices on configuration/Database settings

Network Protocols from SQL Server configuration manager

Temp-db Configuration

Possible failures while shrinking temp-DB in SQL Server

Managing services

Starting & Stopping Services through

1. Configuration manager in SQL Server

2. Net Command

Start Up parameters

Starting SQL server in single-user mode command line

starting SQL Server in minimal configuration mode temp-DB

we have 3 case studies such as

Resolving temp-DB error [Error: 5123] Rebuilding System databases Changing SQL Server Collation in 2008

Migrating SQL server



Difference between in-place & Side by Side Migration/Up-gradation

Migrating database by using Backup and restore method

Using Attach and Detach Method for Migrating database

Migrating Logins [Fixing Orphaned Users] Import & Export

Security

Fixed Server Roles

Availability Groups

User-Defined Server Roles

Instance-Wide Settings

Creating Logins

Fixed Database Roles

Database users

Permissions

Indexing

Performance Tuning

Automating Administrative Tasks

Shrinking the log file

Recovery Models

Types of backups

Third party Backup Tools

Recovery states

Log Shipping

Database Mirroring

Clustering