Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    SQL Server DBA Training - 2 Weekends

    Uploaded by

    Praveen Madupu
    SQL Server DBA Training_2 weekends

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    SQL Server DBA Training - 2 Weekends

    Uploaded by

    Praveen Madupu
    4 views5 pages
    SQL Server DBA Training_2 weekends

    Original Title

    SQL Server DBA Training_2 weekends

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    SQL Server DBA Training_2 weekends

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    4 views5 pages

    SQL Server DBA Training - 2 Weekends

    Uploaded by

    Praveen Madupu
    SQL Server DBA Training_2 weekends

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 5

    https://www.sqldbachamps.

    com Praveen Madupu +91 98661 30093


    Sr SQL Server DBA, Dubai
    [email protected]

    Here’s a 2-weekend SQL Server DBA training plan designed to provide foundational skills for individuals with 0
    to 2 years of experience. The goal is to cover essential topics in SQL Server administration, including database
    management, backup and recovery, performance tuning, and security.

    Each weekend will consist of hands-on exercises and practical demonstrations.

    Training Plan Overview

    Duration: 2 weekends (8 hours per weekend)


    Total Time: 16 hours
    Focus Areas: SQL Server Fundamentals, Backup & Recovery, Maintenance & Monitoring, Performance Tuning,
    Security, Automation
    Training Structure: 4 sessions per weekend (2 hours per session)

    Weekend 1: SQL Server Fundamentals & Database Administration (8 hours)

    Session 1: Introduction to SQL Server Architecture and Management (2 hours)

    Objective: Understand SQL Server architecture and navigate SQL Server Management Studio (SSMS).

    ● Topics:
    ○ Overview of SQL Server Editions and Versions
    ○ SQL Server Architecture (Instance, Databases, Tables, Indexes)
    ○ SQL Server Management Studio (SSMS) Overview
    ○ Introduction to SQL Server Services (SQL Server Agent, SQL Browser)
    ○ Basic SQL Queries: SELECT, INSERT, UPDATE, DELETE
    ● Hands-On:
    ○ Install SQL Server Express Edition and SSMS
    ○ Navigate SSMS and execute basic SQL queries
    https://www.sqldbachamps.com Praveen Madupu +91 98661 30093
    Sr SQL Server DBA, Dubai
    [email protected]
    Session 2: Database Creation, Configuration, and Management (2 hours)

    Objective: Learn how to create and manage SQL Server databases and instances.

    ● Topics:
    ○ Creating and Configuring Databases (Files, Filegroups)
    ○ Database Properties (Collation, Auto-growth, Compatibility Level)
    ○ Creating and Managing Tables
    ○ Indexes and Constraints (Primary Key, Foreign Key, Unique, Default)
    ○ SQL Server System Databases (master, model, msdb, tempdb)
    ● Hands-On:
    ○ Create and configure a database
    ○ Create tables, set indexes, and apply constraints

    Session 3: Backup and Recovery Strategies (2 hours)

    Objective: Understand and implement backup and recovery strategies for SQL Server databases.

    ● Topics:
    ○ Importance of Backup and Recovery
    ○ Types of Backups: Full, Differential, Transaction Log
    ○ SQL Server Recovery Models (Full, Simple, Bulk-Logged)
    ○ Backup Best Practices
    ● Hands-On:
    ○ Perform full, differential, and transaction log backups
    ○ Configure the recovery model for a database

    Session 4: Restoring Databases and Recovery Scenarios (2 hours)

    Objective: Learn how to restore databases and recover data from different types of backups.

    ● Topics:
    ○ Restoring Databases (Full Backup, Differential, and Transaction Log)
    ○ Point-in-Time Recovery
    ○ Dealing with Database Corruption
    https://www.sqldbachamps.com Praveen Madupu +91 98661 30093
    Sr SQL Server DBA, Dubai
    [email protected]
    ○ Practice Recovery Scenarios
    ● Hands-On:
    ○ Restore a database from a full backup
    ○ Practice point-in-time recovery
    ○ Simulate and recover from a corrupted database

    Weekend 2: Performance Tuning, Security, and Automation (8 hours)

    Session 1: SQL Server Performance Tuning Basics (2 hours)

    Objective: Understand performance tuning and optimize SQL Server queries.

    ● Topics:
    ○ Importance of Performance Tuning
    ○ Indexes and Their Role in Performance (Clustered vs Non-Clustered)
    ○ Query Execution Plans
    ○ Identifying and Optimizing Slow Queries
    ● Hands-On:
    ○ Analyze and optimize a slow query using execution plans
    ○ Create and manage indexes for better performance

    Session 2: Monitoring SQL Server and Database Maintenance (2 hours)

    Objective: Learn how to monitor SQL Server performance and implement maintenance plans.

    ● Topics:
    ○ Monitoring SQL Server Performance (Activity Monitor, Performance Counters)
    ○ SQL Server Logs and Error Handling
    ○ Database Integrity Checks (DBCC CHECKDB)
    ○ Index Maintenance (Rebuild, Reorganize)
    ○ SQL Server Agent and Job Scheduling
    ● Hands-On:
    ○ Use Activity Monitor to check system performance
    ○ Configure and schedule a maintenance plan for backups and index maintenance
    https://www.sqldbachamps.com Praveen Madupu +91 98661 30093
    Sr SQL Server DBA, Dubai
    [email protected]
    ○ Use DBCC CHECKDB for database consistency checks

    Session 3: SQL Server Security and Permissions Management (2 hours)

    Objective: Learn to manage SQL Server security, including authentication and permissions.

    ● Topics:
    ○ SQL Server Authentication Modes (Windows vs SQL Authentication)
    ○ Creating Logins and Database Users
    ○ Server-Level Roles vs Database-Level Roles
    ○ Permissions (GRANT, DENY, REVOKE)
    ○ Securing SQL Server Databases (Encryption, Data Masking)
    ● Hands-On:
    ○ Create logins and assign permissions to users
    ○ Configure database roles and grant/revoke permissions
    ○ Implement encryption and data masking on sensitive columns

    Session 4: Automation and High Availability Fundamentals (2 hours)

    Objective: Automate SQL Server tasks and introduce high availability options.

    ● Topics:
    ○ Automating Tasks with SQL Server Agent Jobs
    ○ Configuring Alerts and Notifications
    ○ Introduction to High Availability (Clustering, AlwaysOn Availability Groups, Log Shipping)
    ○ Overview of Disaster Recovery Options
    ● Hands-On:
    ○ Create and schedule an automated job for backups using SQL Server Agent
    ○ Configure alerts for database events (e.g., job failure)
    ○ Conceptual overview of configuring log shipping (demonstration)
    https://www.sqldbachamps.com Praveen Madupu +91 98661 30093
    Sr SQL Server DBA, Dubai
    [email protected]
    Additional Resources for Continued Learning

    ● Books:
    ○ “Microsoft SQL Server 2019: A Beginner’s Guide”
    ○ “SQL Server Performance Tuning” by Grant Fritchey
    ● Online Resources:
    ○ Microsoft Learn: SQL Server Documentation
    ○ SQL Server Central (articles, tutorials, forums)

    Conclusion

    By the end of this 2-weekend SQL Server DBA training, participants will have foundational knowledge of SQL
    Server database administration, covering installation, configuration, backup and recovery, performance tuning,
    security, and automation.

    Hands-on labs throughout the sessions will provide practical experience to manage SQL Server environments
    efficiently.

    You might also like