SQL Server Database Administration (DBA): 4-Day Intensive Training

 

SQL Server Database Administration (DBA): 4-Day Intensive Training

Overview

Enhance your database management skills with our 4-day intensive training on SQL Server Database Administration (DBA), hosted by Purnama Academy. This course is ideal for database administrators, IT professionals, and developers who want to gain a deep understanding of managing, configuring, and maintaining SQL Server databases, covering key aspects such as installation, security, performance tuning, and disaster recovery.

Our training is delivered by certified and experienced instructors who will guide you through hands-on exercises, ensuring you gain practical experience and the knowledge needed to effectively manage SQL Server environments.

Training Details

• Duration: 4 Days
• Time: 09:00 AM - 04:00 PM (Each Day)
• Methods:
  • Public Offline Training
  • Inhouse Training
  • Online via Zoom
• Contact: For more information and registration, please contact our sales team via WhatsApp at 0838-0838-0001.

Course Syllabus

Day 1: Introduction to SQL Server and Installation

• Morning Session:
  • Overview of SQL Server Editions and Features
  • SQL Server Architecture: Database Engine, SQL Server Agent, SSIS, SSRS, and SSAS
  • Installing and Configuring SQL Server on Different Platforms
• Afternoon Session:
  • Managing SQL Server Instances and Databases
  • Configuring SQL Server Network and Security Settings
  • Hands-on Exercise: Installing and Setting Up SQL Server

Day 2: Database Management and Security

• Morning Session:
  • Understanding and Managing SQL Server Databases: Files, Filegroups, and Transactions
  • Implementing SQL Server Security: Logins, Users, Roles, and Permissions
  • Configuring SQL Server Authentication Modes
• Afternoon Session:
  • Auditing SQL Server and Managing Compliance
  • SQL Server Backup and Recovery Strategies
  • Hands-on Exercise: Managing Security and Backup Configurations

Day 3: Performance Tuning and Optimization

• Morning Session:
  • Monitoring SQL Server Performance: Tools and Techniques
  • Indexing Strategies and Query Optimization
  • Analyzing Query Performance with Execution Plans
• Afternoon Session:
  • SQL Server Profiler and Extended Events for Monitoring
  • Managing SQL Server Workloads with Resource Governor
  • Hands-on Exercise: Tuning SQL Server Performance

Day 4: High Availability, Disaster Recovery, and Final Project

• Morning Session:
  • Configuring SQL Server High Availability: AlwaysOn Availability Groups and Clustering
  • Implementing Disaster Recovery Solutions: Log Shipping, Replication, and Backup Strategies
  • Automating DBA Tasks with SQL Server Agent Jobs and Maintenance Plans
• Afternoon Session:
  • Final Project: Managing and Optimizing a SQL Server Database Environment
  • Course Review and Q&A
  • Best Practices and Future Learning Resources

Registration and Contact

To register for the training or for more information, please contact our sales team via WhatsApp at 0838-0838-0001. We offer flexible training options, including public offline sessions, in-house training, and online via Zoom, to suit your learning preferences.