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


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