Mindmajix
  • Courses
  • > SQL Server DBA Training

SQL Server DBA Training

1759
SQL Server DBA Training
4.5 1541

SQL Server DBA Training is designed to enlighten all that is required to perform SQL DBA, SQL Server instances, SAN storage and security. Our professional training gets you started to a career as a SQL Server DBA.


Date :
09 Dec 2016
Course Duration (Hrs):
30
Date :
10 Dec 2016
Course Duration (Hrs):
30
Date :
11 Dec 2016
Course Duration (Hrs):
30
Date :
16 Dec 2016
Course Duration (Hrs) :
30
Date :
17 Dec 2016
Course Duration (Hrs):
30
Date :
18 Dec 2016
Course Duration (Hrs):
30
Contact Us Now!    

The SQL Server Database system from Microsoft Corporation has gained popularity over the last years, and it is believed to be one of the bestest relational database systems in this marketplace.

SQL provides high-quality database support which exceeds performance expectations. SQL Database Administrator performs the task of monitoring of database server. SQL DBA also manages the hundreds of SQL Server instances, SAN storage and security.

SQL Server DBA Training Overview

Our training course is carefully designed for starters as well as for working professionals. The course includes SQL Server Architecture in detail, Understanding Query Design, Query Performance Tuning, Troubleshooting, Disaster Recovery (DR) and High Availability (HA) Solutions including SQL Clustering with Always-On (AAG). 

We bring to you the technical and practical training on SQL DBA where the trainee can enhance the complete knowledge of database theory, database design, RDMS, distributing computing architectures, storage, recovery etc.

All the sessions are completely practical – LIVE to understand Business Level critical data development and management.

The sessions are well explained by 10+years experienced Skilled IT Professionals.

 

SQL Server DBA Training Curriculum

SQL Server Fundamentals & T-SQL 

curriculum_moduleSQL Server Introduction & Installation

Get started with the introduction, installation and components of sql server, configuring tools, providing services and authentication and many more are learnt in this module.

Topics- SQL Server Installation
Services & Authentication
SQL Server Components & Firewall
SSMS
Configuration Tools & SMO
Protocols & Server Aliases
Linked Servers & Types

curriculum_moduleSQL Server 2012 Database Design

Know the creation and modification of sql database, recommendations of data and log files and the offline/online options of db.

SQL Database Creation
Files & File Group Options
Data File Recommendations
Log File Recommendations
DB Offline & Online Options
Database Modifications

 curriculum_moduleSQL Server Tables & Data

Here, you’ll learn about the aliasing, schemas, data types and table design of T-SQL and also the comparison between delete & truncate.

Table Design and T-SQL Data Types
INSERT & SELECT Options
Aliasing
Schemas
Tables & File Group Usage
DELETE versus TRUNCATE

curriculum_moduleData Validations and Constraints

This chapter describes about the constraints and it’s properties & objects and also the different keys and it’s uses.

Constraints – Properties & Objects
UNIQUE KEY and NOT NULL
PRIMARY KEYS & Usage
Composite Keys
CHECK and DEFAULTS

curriculum_moduleBasic Queries and JOIN Queries

Learn the different types of queries and bulk operations in the lesson.

EXISTS
APPLY
WHERE
ORDER BY
GROUPING
HAVING
Sub Queries & Nested Queries
Bulk Operations – Local & Remote

 curriculum_moduleViews and Row Data Security

This chapter describes the views as physical & virtual objects, types of views and the issues with alter table.

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

curriculum_moduleIndexes and Query Tuning

You’ll know the types, architecture, working, performance and uses of indexes.

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

curriculum_moduleStored Procedures and Benefits

About Stored Procedure and it’s use, types of parameters, dynamic sql queries and also procedure cache & recompilation are included in this module.

Stored Procedures & Use
Variables and Parameters
SCHEMABINDING
ENCRYPTION
INPUT & OUTPUT Parameters
Dynamic SQL Queries
Procedure Cache & Recompilation

curriculum_moduleUser Defined Functions and Usage

Different types of functions and the uses of it are discussed in this chapter.

Functions Use & Types
Scalar & Table Valued Functions
SCHEMABINDING
ENCRYPTION
System Functions and Events
Date
Time
String and Metadata Functions

 curriculum_moduleTriggers and Cursors – Memory Limitations

Understanding the DML triggers & performance, types of cursors and it’s usage and also the inserted & deleted tables.

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

curriculum_moduleTransaction Concepts in Realtime

What are transaction types and it’s use?, blocking the DML/DDL operations, commit & rollback options and many more are learnt in this module.

Transaction Types & Use
Blocking – DML Operations
Blocking – DDL Operations
COMMIT & ROLLBACK Options
SAVEPOINT & CHECKPOINT
Deciding Transaction Types
Querying SQL_MODULES View

Basic SQL DBA  

 curriculum_moduleTransaction Locks and Deadlocks

What is the significance, types, hints, usage of locks?, types of isolation levels & models and the issues of real-time data deployment are discussed in this chapter.

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

curriculum_moduleDatabase Backups Strategies

The focus in this course is to know the types, validations, restore paths and audits of backup, need for backup strategies, different options and MSDB history tables.

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
Media Sets and Media Truncate Options

curriculum_moduleDatabase Restores and Recovery Paths

Learn How to restore the database, types of restore and how can we provide backup or recovery path using T-SQL & UI..

Need for Restores and Types
Backup Verification using T-SQL & UI
Restore Phases and Recovery Path
Database
File Group
File Restores
PARTIAL and Piecemeal Restores
Point-In-Time Restores and Options
Compressed Tail Log Restores
Recovery
MOVE and FILELISTONLY Options

curriculum_module SQL Server Jobs & Alerts

Understand how to Create jobs using UI and T-SQL Scripts, Schedules the Job Steps, Monitoring the Job Activity, How do you configure DB Mail and many more.

Creating Jobs using UI
Creating Jobs using T-SQL Scripts
Understanding Job Steps and Schedules
Backup Schedules & Jobs using Scripts
Job Failures and History View
Enabling and Disabling Jobs
Job Activity Monitor and Agent Status
Alert System and DB Mail Configuration

curriculum_moduleData Replications and DR Process

Get a brief understanding on How to Install Replication and Configure it, Types and Alerts of replication, How to monitor Replication and also about DB Recovery Process.

Replication Architecture and Configuration
Snapshot and Transactional Replications
Merge Replication
DB Recovery process
Peer-Peer with Backup Initialization
Replication Types – PUSH & PULL
Replication Alerts
Warnings and Emails
Replication Monitors and Event Watch
Replication for Load Balancing & DR
Agent Operators, Notifications / Emails
Data Access Modes and Agent Properties

curriculum_module Log Shipping and DB Mirroring

Here you’ll learn about the Log shipping and DB Mirroring configuration and its modes respectively and how can regain the disaster recovery in SQL Server.

Disaster Recovery in SQL Server
Log Shipping Configuration and Modes
Manual DB Failover using Log Shipping
DB Mirroring Configuration and Modes
Automatic and Manual Failover Options
Mirror Monitors
Network Considerations
Comparing Log Shipping and Mirroring

curriculum_moduleSecurity and Data Encryption

Levels of Security Implementation
Server level Logins and DB level Users
Server Roles and User Mappings
Schema Level Security and DB Roles
Table and Column permissions
DB roles
Data Encryption Keys and Certificates
Login Failures
Authentication Audits

curriculum_moduleServer Audits and DB Monitors

Types of Audits and SQL Tools
Server level Audits and Error Logs
Activity Monitors and IO Usage Reports
SQL Profiler, Deadlock Graphs and Filters
DMVs for Query Audits
Tempdb Audits
DMFs for Index
Session and Log Audits
DMFs
DMVs for Queries
Tempdb Audits
Important Queries for DBCC
Important DMVs and DMFs
Security Audits and Profiling

Advanced SQL DBA 

curriculum_moduleDatabase Maintenance Plans (SSIS)

Database Maintenance Plan Strategies
Wizard Based DMPs and Schedules
Control Flow Tasks
Precedence Usage
Index Rebuilds and Reorganization
Deciding Fill Factor and PAD_INDEX Options
Managing MSDB and TEMPDB
Using NOTIFY OPERATOR task in DMP
Using UPDATE STATISTICS and Agent
Maintenance Issues in Real-time

curriculum_modulePartitions and Full-Text Indexes

Able Partitions and Compressions
Aligned Partitions and FillFactor
Managing Partitions for Query Tuning
Statistics with Indexes and Partitions
Full Text Search Usage and Catalogs
Full Text Indexes for Query Tuning
CHANGE_TRACKING options
Use Tuning Implementations with Cache
Compressed Indexes with Partitions

curriculum_moduleDatabase Engine Tuning Advisor (DTA)

Creating Workload Files using Profiler
Workload Tables with SQL Profiler
TUNING Templates and Column Filters
Index Selectivity and DTA Usage
Filtered Indexes and Index Sizing
Role of Statistics in Performance Tuning
Index Fragmentation and REBUILDS

curriculum_moduleAlerts and Troubleshooting

LOG SPACE Issues – Alerts and Solutions
TEMPDB Issues – Alerts and Solutions
MEMORY Issues – Alerts and Solutions
DB STATE Issues – Alerts and Solutions
Network Issues – Alerts and Optimizations
Using PERFMON Counters and Filters
Replication and Mirroring Thresholds
Activity Monitor and Deadlock Issues

 curriculum_moduleDB Engine Configurations and PBM

Working with SQL Engine Properties
DTC and Remote Connection Properties
Query Governor and Timeout Options
Database State Properties and Options
Policy Based Management (PBM) Usage
Database Facets and Conditions
Scheduling and Reporting Policies
Resource Governor & Browser Tools
Server Properties and Configurations

curriculum_moduleServer Updates and Upgrades

Establish Downtime
Sample Notifications
PRIOR Maintenance activities
Precautions
Applying Patch/hot fix and Service Packs
Verifying Updates and SmokeTest Options
Understanding Upgrade Advisor Issues
Server Upgrades and Smoke Tests
Rollback Service Packs and Precautions
System Database Rebuilds

curriculum_moduleWindows and SQL Cluster Configurations

Windows and SQL Licensing Options
Domain Controller and Active Directory
Windows and Network Configuration
PING tests and DTC Configurations
QUORUM settings and SAN Settings
SQL Server Cluster Installation
SQL Group and RAID Configurations
Virtual SAN Setup and Verification

curriculum_module SQL Cluster Issues and Troubleshooting

SQL Cluster Node Installation
QUORUM Check and DTC Settings
Connection Issues and Drains
SQL Cluster Configurations and Heartbeat
Security Issues with Solutions
Storage Issues with Solutions
Always-On (AAG) Groups and HA
Practical Considerations For HA

 

SQL Server DBA Course FAQs

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

The Training itself is Real-time Project Oriented.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of  the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE and other parts of the world. We are located in USA.

Mindmajix Technologies Inc

14 Pasco Drive
East Windsor, Connecticut, 06088
United States (US)
Phone: 201 378 0518

 

Job Support

Mindmajix Job support’s aim is to train and support as many young IT professionals as possible in achieving their tasks for attaining quality jobs in the regular workforce.

For a fresher in IT, the actual requirement of programming and development standards could be partially or completely different in the job environment. Job support gives graduates that extra guidance before or after they attempt employment into IT sector by assisting them with the SQL Server DBA training by highly experienced and real time professionals with full stack technical background in the SQL Server DBA field. They address your complete issues that you face periodically.

We have wide-spread services across India, USA, Australia and other countries, assisting software employed people to excel in their jobs when they have an onset of a worsening condition.

Our trainers support you solve your technical problem and guide you to the right path in order to obtain a favourable solution. Once we understand your project, the subsequent problems are solved even better and faster.

What we assure?

* Our trainers make it a point to make you capable of understanding the real world scenarios.

* Our trainers will provide exceptional Technical assistance and help you out solve your Technical problems at your jobs in an efficient way.

* We assist the person learn a new job, and ensure extra assistance or a different format for learning the role vividly.

We Specialize in providing most reliable support and you can entirely entrust to us.

Drop Us A Query


Course Reviews

4.5

1541 ratings
  • 51079
  • 4231
  • 3154
  • 262
  • 115
Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.