IIRF Online > Development > Database Design & Development > SQL Server > Certified MS-SQL Server Administrator
Certified MS-SQL Server Administrator by Vskills
Course Highlights
- Government certification
- Certification valid for life
- Lifelong e-learning access
- Learning Hours: 13 hrs
- Life Time Job Support
- Job Profile Tagging
Skills you will learn!
Curriculum
3 Topics
Introduction to Relational Databases
Understanding SQL Server Editions and Versions
Database Objects (Tables Views Indexes etc.)
3 Topics
System Requirements
Installation Options (Standalone Clustered etc.)
Post-installation Configuration
3 Topics
Creating Databases
Schema Design
Data Types and Constraints
3 Topics
SQL Query Language (SELECT INSERT UPDATE DELETE)
Data Manipulation Language (DML)
Query Optimization and Performance Tuning
3 Topics
Authentication Modes (Windows Authentication SQL Server Authentication)
User and Role Management
Permissions and Access Control
3 Topics
Database Backup Strategies
Database Restore Processes
Backup and Restore Options
4 Topics
SQL Server Always On Availability Groups
Database Mirroring
Log Shipping
Failover Clustering
4 Topics
Query Execution Plans
Indexing Strategies
Monitoring and Tuning
Performance Counters and DMVs
3 Topics
SQL Server Agent Jobs
T-SQL Scripting
PowerShell for SQL Server Administration
4 Topics
Database Maintenance Plans
SQL Server Profiler
SQL Server Management Studio (SSMS)
SQL Server Data Tools (SSDT)
4 Topics
Transactional Replication
Snapshot Replication
Peer-to-Peer Replication
Data Distribution
3 Topics
ETL (Extract Transform Load) Processes
Package Creation and Deployment
SSIS Catalogs
3 Topics
Report Design and Development
Report Deployment and Configuration
Report Subscription and Security
3 Topics
Multidimensional and Tabular Models
Cube Design and Processing
MDX and DAX Queries
3 Topics
Database Corruption and Recovery
Error Handling and Event Logs
Troubleshooting Common Issues
2 Topics
Planning and Performing Upgrades
Applying Service Packs and Cumulative Updates
3 Topics
Security Auditing
Encryption and Data Masking
Compliance and Regulatory Requirements
2 Topics
Azure SQL Deployment Options
Management and Monitoring in the Cloud
2 Topics
Backup and Restore Strategies
Business Continuity and High Availability Planning
Certified MS-SQL Server Administrator
Related SQL Server Courses
Thank You!
Your review has been submitted successfully.