Brochure
Enquire
- Responsibilities of Database Administrator
- Types of DBA’s
- History of SQL Server – Versions
- What’s new in SQL Server 2022 for Administrators?
- Editions of SQL Server
- Differences between Enterprise and Standard Editions
- Requirements
- Hardware
- Software
- Instances & its advantages
- Types
- Default Instance
- Named Instances
- Home
- Mindmajix Technologies
- Courses
- SQL Server DBA Training and Certification
SQL Server DBA Training and Certification
Quick Facts
| particular | details | ||||
|---|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course and certificate fees
Fees information
₹ 8,000 ₹10,000
certificate availability
Yes
certificate providing authority
Mindmajix Technologies
The syllabus
Starting with SQL Server 2022
Installing and Configuring
- Installing SQL Server 2022
- Pre –Installation Steps
- Installations
- Viewing the Installation process with Log files
- Common issues
- Adding or removing components
- Installing Service Packs
- Configuration
- Configuration of Various Services
- Startup Parameters
- Configuring data files and log file paths
- Memory Configuration
- Remote Connections
- Configuring network protocols, Ports
- Configuring Services
- Configuring default backup folder.
Working with Databases
- Working with Databases
- System Defined databases
- Moving System Databases
- Handling TempDB database
- Database Architecture
- Data Files
- Log Files
- Filegroups
- Extents
- Pages –Types
- Page Architecture
- Tracking Free Space
- Log file full – How to troubleshoot.
- Creating Databases
- Adding files, Filegroups
- SQL Server Architecture
Security in SQL Server 2019
Security Enhancements
Types of Authentications
- Windows Authentication
- Creating logins from Windows users and groups
- Orphan logins
SQL Server Authentication
- Creating SQL logins and testing logins
- Setting Authentication Mode
- Security Auditing
- Understanding Server roles
- Working with users
- Resolving Orphan users
- Understanding database roles
- Understanding permissions
- Major Issues
Backup and Restoration
- Recovery Models Setting Recovery Model
- Full
- Bulk Logged
- Simple
- Database Backups
- Why do we need backups
- Backup Types Copy-Only, Mirrored, and Tail log backups
- Full
- Differential
- Transaction Log
- File or Filegroup
- Backup Devices
- Performing Restoration
- Backup System Databases
- Point-in-time Recovery
- Viewing complete details of the backup process
- Issues related to backups
Introduction to High Availability and Working with Log Shipping
- Introduction to High Availability
- Working with Log Shipping
- Features
- Jobs
- Requirements to implement Log Shipping
- Configuring Log Shipping
- Monitoring Log Shipping
- Manually performing Fail Over
- Transferring Logins
- Log Shipping tables and stored procedures
- Handling Issues
Introduction to Always ON & Replication
Always-ON
- HADR Internals & Advantages
- Setting up HADR
- Adding a DB to the AG
- Patching in Always on
- Adding a Replica in AG
- Setting up Listener & read-only Replicas in AG
- Troubleshooting & maintenance
Replication
- Replication and Advantages
- Replication Entities
- Replication Architecture
- Replication Agents
- Types of Replications
- Configuring Replication
- Snapshot Replication
- Transactional Replication
- Merge Replication
- Peer to Peer replication
- Managing Replication
- Monitoring and Tuning Replication
Clustering SQL Server
- Clustering SQL Server
- Overview of Windows Clustering
- Requirements
- Installation and configuration of SQL Server Clustering
- Applying Service packs and fixes
- Moving groups
- Adding node on a SQL Server Failover Cluster
- Troubleshooting Cluster issues
Automating Administrative Tasks
- Maintenance Plans
- Working with Database Mail Configuring
- Mail Architecture
- Configuring Profiles and Accounts
- Sending Mails
- Implementing Automation
- Configuring SQL Server Agent
- Creating Operators, Alerts, Jobs
- Managing jobs and resolving errors
- Monitoring Jobs
- Auto alert when jobs are enabled, disabled or failed
Advanced Administration Concepts
- Database indexes understanding
- Checking index defragmentation & Maintenance
- Database Health Check
- Understanding SQL Server Profiler
- Creating & Running Traces
- Understanding Extended Events
- Creating & configuring Extended Events
- Monitoring Tools
- System Monitor
- SQL Server Profiler
- Database Engine Tuning Advisor
- Dynamic Management Views
- SQL Server and Windows Error Logs
- TroubleshootingLocks
- Physical Server Performance
- Connectivity to SQL Server
- Database Performance
- Dead Locks
- Transaction Isolation Levels
- Understanding Blocking
- Terminating Processes
- Using the DAC
- Managing Databases
Practice Test & Interview Questions
Instructors
Articles
Popular Articles
prev
next
Latest Articles
prev
next
