enquiry@technidata.in
Explore Courses
Software Development
Cyber Security
Infrastructure & Cloud DevOps
AWS
Azure
VMware
Data & Database Administration
Sql dba
Oricle DBA
Snowflake
Data Science & Business Analytics
Generative AI & ML
Software Testing
SAP Modules
HR Solutions
Placements
IT Jobs
Non IT Jobs
HR OPS
Clients
About Us
Reach Us
Home
Data & Database Administration
Sql dba
Sql dba
Curriculum
10 Sections
30 Lessons
10 Weeks
Expand all sections
Collapse all sections
SQL Database Fundamentals
3
1.1
SQL Server Editions & Licensing
1.2
Instance vs Database
1.3
SQL DBA Roles & Responsibilities
Installation & Configuration
3
2.1
System Database Overview
2.2
Server Configuration Options
2.3
SQL Server Management Studio (SSMS)
Database Architecture & Storage
3
3.1
Filegroups & Allocation
3.2
Memory Architecture
3.3
TempDB Architecture
Security & User Management
3
4.1
Users, Roles & Permissions
4.2
Encryption & Data Security
4.3
Auditing & Compliance
Backup & Recovery
3
5.1
Restore Scenarios
5.2
Disaster Recovery Planning
5.3
Recovery Models
Performance Monitoring & Tuning
3
6.1
Indexes & Statistics
6.2
Query Execution Plans
6.3
Blocking & Deadlocks
Maintenance & Automation
3
7.1
Maintenance Plans
7.2
Database Health Checks
7.3
Patching & Upgrades
High Availability & Disaster Recovery
3
8.1
Failover Clustering
8.2
Log Shipping
8.3
Replication Overview
Monitoring, Troubleshooting & Optimization
3
9.1
Troubleshooting Production Issues
9.2
Capacity Planning
9.3
Performance Baselines
Advanced DBA & Real-World Scenarios
3
10.1
Security Best Practices
10.2
Migration & Upgrade Scenarios
10.3
Real-Time DBA Case Studies
This content is protected, please
login
and
enroll
in the course to view this content!
X
Name
Email
Phone
Your message (optional)
X
Name
Email
Phone
Your message (optional)
