SQL Server DBA Hands-On Online Training, Support By Realtime Experts

SQL Server DBA Training helps to gain you the knowledge on SQL DBA, SQL Server instances, SAN storage, and security. Our professional training also covers disaster recovery, replication, using jobs and database maintenance tasks, etc. You will also get an exposure to industry based Real-time projects in various domains.



FOR FREE DEMO contact :

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk : raavi.sriraja@gmail.com

Blog: http://apex-it-online-trainings.blogspot.in


SQL Server DBA Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided

SQL SERVER DBA COURSE CONTENT

(the course agenda can be modified as per your requirements):


SQL Server Introduction & Installation

SQL Server Installation

Services & Authentication

SQL Server Components & Firewall

SSMS

Configuration Tools & SMO

Protocols & Server Aliases

Linked Servers & Types

SQL Server 2012 Database Design

SQL Database Creation

Files & File Group Options

Data File Recommendations

Log File Recommendations

DB Offline & Online Options

Database Modifications

SQL Server Tables and Data

Table Design and T-SQL Data Types

INSERT & SELECT Options

Aliasing

Schemas

Tables & File Group Usage

DELETE versus TRUNCATE

Data Validations and Constraints

Constraints - Properties & Objects

UNIQUE KEY and NOT NULL

PRIMARY KEYS & Usage

Composite Keys

CHECK and DEFAULTS

Basic Queries & Join Queries

EXISTS

APPLY

WHERE

ORDER BY

GROUPING

HAVING

Sub Queries & Nested Queries

Bulk Operations – Local & Remote

Views & Row Data Security

Views as Virtual Objects

Views as Physical Objects, SCHEMA BINDING

ENCRYPTION

Issues with ALTER TABLE

System Views & Dynamic Management Views

Views with Joins and Views

Indexes and Query Tuning

Architecture of Table Indexes

Clustered & NonClustered Indexes

SORT_IN_TEMPDB

ONLINE

FILLFACTOR and PAD_INDEX

Execution Plans and Performance

Unique Indexes and Uses

Working with Indexed Views

Stored Procedures and Benefits

Stored Procedures & Use

Variables and Parameters

SCHEMABINDING

ENCRYPTION

INPUT & OUTPUT Parameters

Dynamic SQL Queries

Procedure Cache & Recompilation

User Defined Functions and Usage

Functions Use & Types

Scalar & Table-Valued Functions

SCHEMABINDING

ENCRYPTION

System Functions and Events

Date

Time

String and Metadata Functions

Triggers and Cursors - Memory Limitations

DML Triggers & Performance

INSERTED and DELETED tables

STATIC and DYNAMIC cursors

SCROLL & FORWARD_ONLY

LOCAL and GLOBAL cursors

KEYSET Cursors and Usage

Embedding Cursors in SPs

Transaction Concepts in RealTime

Transaction Types & Use

Blocking - DML Operations

Blocking - DDL Operations

COMMIT & ROLLBACK Options

SAVEPOINT & CHECKPOINT

Deciding Transaction Types

Querying SQL_MODULES View

Basic SQL DBA

Transaction Locks and DeadLocks

Significance of LOCKS and Usage

Types of Locks and Lock Hints?

Isolation Levels - Types & Usage

Choosing best Isolation Level

TempDB Issues with Isolation Levels

Recovery Models and Options

Choosing Best Recovery Model

Real-time Data Deployment Issues

Database Backup Strategies

Need for Backups Strategies

Database Backups and Partial Backups

FORMAT

INIT

SKIP

CHECKSUM Options

Backup using T-SQL Scripts & UI

Backup validations and Restore Paths

MSDB History Tables

Backup Audits

Compressed Backups and Expiry

Log backups and Truncation options

Backup Audit Tables in MSDB

Database Restores and Recovery Paths

SQL Server Jobs and Alerts

Data Replication and Process

Log Shipping and DB Mirroring

Security and Data Encryption

Server Audits and DB Monitors

Advanced SQL DBA

Database Maintenance Plans

Partitions and Full Text Indexes

Database Engine Tuning Advisor DTA

Alerts and TroubleShooting

DB Engine Configurations and PBM

Server Updates and Upgrades

Windows and SQL Cluster Configurations

SQL Cluster Issues and Troubleshooting