fbpx

SQL Server 2022 DBA

 

sql server dba training

Online Training | Classroom | Virtual Classes

  • SQL Server DBA Training with 100% placement assistance
  • 1860 testers placed in 600 companies in last 8 years
  • Real time expert trainers
  • Indutry oriented training with corporate casestudies
  • Free Aptitude classes & Mock interviews

About SQL Server DBA Training Course

SQL Server DBA maintains and manages all the database duties including its design, the implementation and support. It also helps in assembling, fabricating and grading the databases for further use. MindQ offers the best SQL Server DBA Training in Hyderabad that is a thorough paced course that will teach you everything you need to build, configure a server, maintain a SQL Server disaster recovery plan, ways to design and manage a secure solution. We have excellent training staff who use effective practical training methodologies to give the students hand-on experience throughout the training program. Our SQL Server Database course curriculum is customized to meet the needs of the industry and is creatively segregated into 7 modules to cover all the core concepts effectively. We at MindQ Systems in Hyderabad provide a certificate marking the completion of the course along with placement assistance that can help students kick start their career in the right direction.

SQL Server 2022 DBA Training Curriculum

MS SQLServer 2022

DatabaseAdministration
With AlwaysOn & Clustering
Techniques
Module 1: SQL Server
Architecture
Introduction to SQL Server 2019/2022
βœ“ Overview on RDBMS and Beyond
Relational
βœ“ Components & Services of SQL Server
2019/2022
βœ“ Roles of production DBA
βœ“ System Databases
βœ“ Master, Model, MSDB, Tempdb & Resource
SQL Server 2022 Editions & Capacity
Planning
βœ“ Principal Editions [Enterprise, BI, Standard]
βœ“ Specialized Editions [Web]
βœ“ Breadth Editions [Developer, Express]
βœ“ Hardware Requirements
βœ“ OS and Software requirements
Pages & Extents
βœ“ Pages
βœ“ Extents [Uniform & Mixed]
βœ“ Database Files o Primary data files
o Secondary data files o Log files
βœ“ Database File groups [Primary &
Userdefined]
Thread and Task Architecture
βœ“ Allocating threads to CPU
βœ“ Affinity Mask
βœ“ IO and Processor affinity mask

 

Memory Architecture
βœ“ 32-bit Vs 64-bit Architecture
βœ“ Dynamic Memory Management
βœ“ Effects of min and max server memory
βœ“ Buffer Management
βœ“ The Relational Engine
βœ“ The Command Parser
βœ“ The Query Optimizer
βœ“ The Query Executor
βœ“ Using AWE
βœ“ Configuring Memory Settings
βœ“ The Buffer Pool and the Data Cache
βœ“ Checkpoints
βœ“ Hot Addition of memory
βœ“ Difference between Checkpoint & Lazy
writer
T-Log Architecture
βœ“ Transaction Log Logical Architecture
βœ“ Transaction Log Physical Architecture
βœ“ Recovery phases [Analysis, Redo & Undo]
βœ“ Checkpoint Operation
βœ“ Write-Ahead Transaction Log
βœ“ Managing T-log
βœ“ Truncating and shrinking the log file
βœ“ Managing T-Log issues by using DBCC
commands
Module 2: Installing,
Upgrading, Configuration,
Managing services and
Migration
SQL server 2019/2022 Installation
βœ“ Planning the System/Pre-Requisites
βœ“ Installing SQL server 2019/2022
βœ“ Installing Analysis Services
βœ“ Installing & Configuring Reporting Services
βœ“ Uninstalling SQL server

Upgrading to SQL server 2019/2022
βœ“ Upgrading the server by applying service
packs
βœ“ Upgrading the server by applying Hot fixes
βœ“ In-Place Vs. Side-by-Side upgradations
βœ“ Pre-Upgrade Checks/pre-requisites
βœ“ Upgrade advisor
βœ“ In-Place Upgradation from SQL server
2012/2016 to 2019/2022
βœ“ Best Practices to follow while upgrading
Managing services
βœ“ Server/Engine Connectivity issues
βœ“ Security/Firewall access issues
βœ“ Starting and Stopping Services through
βœ“ Configuration manager
βœ“ Net Command
βœ“ Management Studio
βœ“ Start Up parameters
βœ“ Starting SQL server in single user mode
βœ“ Starting SQL server with minimal
configuration
Configuring SQL Server 2022
βœ“ Configuring Network Protocols from SQL
Server configuration manager
βœ“ Configuring Client Protocols from SQL
Server configuration manager
βœ“ Dedicated Administrator Connection
βœ“ Enabling advanced features by using facets
βœ“ Connecting to DAC
βœ“ Configuring Database Mail
βœ“ Configuring Registered servers
βœ“ Configuring Central Management Servers
[CMS]
βœ“ Querying data from different servers by
using CMS
βœ“ Configuring other settings through
SP_Configure
βœ“ Configuring Server memory settings
βœ“ Configuring Database Settings
βœ“ Tempdb configurationΒ 

Migrating SQL server
βœ“ Side-By- Side Migration Techniques
βœ“ Difference between in-place & Side by Side
Migration/Upgradation
βœ“ Advantages/Disadvantages of In-Place to
Side-by-Side
βœ“ Migrating Databases
1. Migration by using Attach and
Detach Method
2. Migration by using Back and
restore method
βœ“ Migrating Logins [Fixing Orphaned Users]
βœ“ Creating and migrating linked servers
βœ“ Migrating Jobs
βœ“ Data movement by using Import & Export
wizard
Module 3: Security,
Automation & Monitoring
Automating Administrative Tasks
βœ“ About SQL server Agent
βœ“ Creating Jobs, Alerts and Operators
βœ“ Scheduling the Jobs
βœ“ Working with Job activity Monitor
βœ“ Resolving failure Jobs
βœ“ Configuring Alert system in SQL server
agent
Monitoring SQL Server
βœ“ The Goal of Monitoring
βœ“ Choosing the Appropriate Monitoring Tools
βœ“ Monitoring health status by using server
Dashboard & DMV’s
βœ“ Monitoring Job activities by job activity
monitor
βœ“ Monitoring SQL Server process by server
activity monitor
βœ“ Monitoring SQL Server Error
Logs/Windows by log file viewer

Security
βœ“ Security Principles & Authentications
βœ“ Server and Database Roles
βœ“ User-defined server roles
βœ“ Server and Database Principles
βœ“ Server & Database Securable
βœ“ Creating Logins and mapping Users to
databases
βœ“ Creating Schemas & credentials
βœ“ Default Schema for Groups
βœ“ Enabling contained databases
βœ“ Creating users for contained databases
βœ“ Connecting to contained databases from
SSMS
βœ“ Granting to Object level Permissions
Module 4: Backup & Restore,
High Availability &
Replication
Backup & Restore:
βœ“ Recovery Models [Simple, Bulk-Logged &
Full]
βœ“ How Backup Works
βœ“ Types of backups
1. Full backup
2. Diff backup
3. T-log backup
4. Copy Only
5. Mirror
6. Tail-Log
7. Compressed backups
βœ“ Restoring Modes [With Recovery, No
Recovery, Read only/Standby]
βœ“ Disaster Recovery Planning
βœ“ Performing Restore (point-in-time
recovery)
βœ“ Partial availability of database.
βœ“ Database Recovery advisor
βœ“ Backup strategy: Developing and executing
a Backup Plan
βœ“ Creating Maintenance Plans

βœ“ Resolving Backup failures in Real time
scenarios
Log Shipping
βœ“ Log-Shipping Architecture
βœ“ Building DRS for log-shipping
βœ“ Pre-requisites/Log-Shipping Process
βœ“ Deploying Log Shipping
βœ“ Working with Log Shipping Monitor
βœ“ Logs hipping Role changing [Fail-Over]
βœ“ Removing Log Shipping
βœ“ Frequently Raised Errors In Log-Shipping
Database Mirroring
βœ“ Overview of Database Mirroring
βœ“ Operating Modes in Database Mirroring
βœ“ Pre-Requisites for Database Mirroring
βœ“ Deploying Database Mirroring
βœ“ Fail-Over from Principle to Mirror
βœ“ Working with Database mirroring monitor
βœ“ Advantages & Disadvantages of database
mirroring
βœ“ Database Snapshots
βœ“ Using Database Snapshots for reporting
purposes.
AlwaysOn Availability Groups
βœ“ AlwaysOn Overview
βœ“ Understanding Concepts and Terminology
βœ“ Availability Modes
βœ“ Types of fail-overs
βœ“ Pre-requisites for AlwaysOn configuration
βœ“ Configuring Availability Groups
βœ“ Monitoring Availability groups
βœ“ Add/remove database/replica
βœ“ Suspend/resume an availability database
βœ“ Backups on Secondary
βœ“ AlwaysOn Failover Cluster Instances
βœ“ Online Operations

Replication
βœ“ Replication Overview
βœ“ Replication Models
βœ“ (snapshot/Transactional/Merge/Peer to
Peer)
βœ“ Replication agents
βœ“ Configuring Distributor
βœ“ Deploying Transactional Replication for
High Availability
βœ“ Deploying Merge Replication for
Bidirectional
βœ“ Creating Subscriptions [Homogeneous /
heterogeneous]
βœ“ Monitoring Replication by using replication
monitor
Module 5: Windows & SQL
Server Clustering
Windows Server 2019 Clustering
βœ“ What is a cluster and Overview of Windows
cluster
βœ“ Server cluster technologies
1. Server clusters
2. NLB clusters [Network load balancing]
βœ“ Basic architecture of server clusters
βœ“ Networks in clustering [Public & Private]
βœ“ How cluster works
βœ“ Health Detection [Looks alive, Is alive]
βœ“ Introduction to Windows Server 2019
βœ“ Basic elements of a cluster with single
quorum.
βœ“ Adding Roles and features by using server
manager
βœ“ Introduction to fail-over cluster manger
βœ“ Validating the cluster configuration
βœ“ Creating cluster through fail-over cluster
manager
βœ“ Configuring MSDTC as a cluster aware
application

βœ“ Active – passive Vs Active – Active Clustering
βœ“ Adding/Evicting Nodes to/from the cluster
βœ“ Adding volumes to the roles/services in the
cluster
βœ“ Simulating the failover for the resources
Installing SQL Server 2019 Fail-Over
Clustering
βœ“ Pre-SQL Server Installation Tasks.
βœ“ Configure SQL Server–Related Service
Accounts and Service Account Security
βœ“ Stop Unnecessary Processes or Services
βœ“ Check for Pending Reboots
βœ“ Install SQL Server Setup Support Files
βœ“ SQL Server 2019 Setup
βœ“ Install the First Node
βœ“ Add Nodes to the Instance
βœ“ Perform Post installation Tasks
βœ“ Verify the Configuration
βœ“ Set the Preferred Node Order for Failover
βœ“ Configure a Static TCP/IP Port for the SQL
Server Instance
Administering a SQL Server 2019
Failover Cluster
βœ“ Install SQL Server Service Packs, Patches,
and Hot fixes
βœ“ Introducing Failover Cluster Management
βœ“ Monitoring the Cluster Nodes
βœ“ Adding volumes to cluster roles
βœ“ Clustered SQL Server Administration
βœ“ Fail over resources/roles between the
nodes
βœ“ Automatic failover & Failback
βœ“ Destroying a Cluster- Using Failover Cluster
Management
βœ“ Uninstalling a Failover Clustering Instance

Module 6: Performance
Tuning, Indexing &
Optimizing SQL Server
Optimizing SQL server
βœ“ Policy based management
βœ“ Policy based management implementation
βœ“ Creating Policy & Condition
βœ“ Evaluating polices
βœ“ Resource governor
βœ“ Resource pool & Workloads
βœ“ Using resource governor from SSMS
βœ“ Monitoring Resource governor
Indexing
βœ“ Index Architecture
βœ“ How to optimally take advantage of indexes
βœ“ Clustered & Non-Clustered indexes
βœ“ Covering Index or index with included
column
βœ“ Column store Index Overview
βœ“ Column store Index Fundamentals and
Architecture
βœ“ Creating column store index to improve the
performance
βœ“ Index Fragmentation
βœ“ How to determine fragmentation
βœ“ Creating maintenance plan for
rebuilding/re-organizing indexes

Locking & Concurrency
βœ“ Isolation Levels in SQL Server
βœ“ Locking in SQL Server
βœ“ Resolving concurrency effects in SQL Server
βœ“ Lock modes – Shared, Update, Exclusive,
Intent, Schema, bulk-update, key-range
βœ“ Lock escalation in SQL server
βœ“ Blocking [SP_Who2]
βœ“ Resolving blocking issues in SQL Server
βœ“ Working with Activity Monitor
βœ“ Live & Dead Locks
βœ“ Trace flags to capture dead locks
βœ“ Capturing dead lock information in error
logs
βœ“ SQL Profiler [How to capture events data by
using Profiler]
βœ“ Capturing deadlock events in profiler
βœ“ Deadlocks and deadlock chain detection.
Performance Tuning
βœ“ Factors That Impact Performance
βœ“ Tools used SQL Profiler, Database Tuning
Advisor, System Monitor
βœ“ Introduction to Database Tuning Advisor
[DTA]
βœ“ Analyzing the profiler data by using DTA
βœ“ Performance Monitor [System Monitor]
βœ“ Correlate SQL Profiler Data with
Performance Monitor Data

Learn with Mind Q, Kick start your corporate career.

SQL Server DBA Training Highlights

  • Free demo class
  • Job-oriented training
  • 100% placement assistance
  • Expert SQL experts with 12+ years of experience.
  • 50+ hours of instructor led training
  • Availability of online + offline + weekend training modes.
  • 24*7 assistance provided.
  • Professional resume preparation guidance
  • Hands-on practical training.

SQL Server DBA Training Certificate

We provide a SQL Server DBA course completion certificate that is absolutely free and optional. The certificate can be printed out like a hard copy or given digitally according to your requirement. You can link it to your professional LinkedIn accounts which can be listed in your resume.

Who Should Learn SQL Server DBA Training?

  • Any graduates
  • People who want advanced training in Database.
  • Developers
  • Web developers
  • UI developers
  • UX developers
  • MVC developers

Skills you will gain from our Accessibility course

  • Configuring servers
  • Design and manage servers
  • Automate regular tasks like backups.
  • Database maintenance tasks.
  • Understanding of system security
  • Installation and configuration of SQL server 2016
  • Automating administrative tasks
  • Plan, deploy, and launch migration

Career opportunities after taking the course

  • SQL Administrator
  • SQL Database Administrator
  • SQL Server Database Administrator.
  • SQL Server Administrator
  • Database administrator.

FAQ

Can I get a free demo class?

Yes, we can arrange a free SQL Server DBA demo class.

Will I get a refund if I drop out of the course?

You can get the refund only within the first 3 days of enrolling in the SQL Server DBA course after which no refund can be issued.

What if I miss a SQL Server DBA training class?

You can attend our live batch or we can also arrange for backup classes.

What are the modes of SQL Server DBA training in MindQ Systems?

We offer online SQL Server DBA training, classroom SQL Server DBA training and weekend training

Will I get a SQL Server DBA certificate?

You will be given a SQL Server DBA course completion certificate after the training program.

What about SQL Server DBA placement?

We will provide assistance and guidance throughout the course that will help you perform well in the job interviews and job trials. We will also offer further assistance by forwarding your resume with our tied up companies.

 

Training Features

We offer a wide range of high quality of teaching and extra-curricular activities.

Instructor-Led Training Sessions

Our trainers are right on your screen available to answer any question you may have.

Expert Trainers

We encourage nothing less than the BEST. Our trainers are real-time experts with years of experience.

Flexible Schedule

We have classes on most hours of the day. You plan your availability accordingly and schedule a demo.

Industry Specific Scenarios

Since all our faculty hail from industry, our trainers are masters in explaining scenarios that are used and preferred in the market.

Pin It on Pinterest

Share This