Scribd Logo
Upload

Welcome to Scribd!

  • 619 views

    MS SQL DBA Course Content

    Uploaded by

    tejareddy
    The document outlines the topics that will be covered in a SQL Server database administration training course. It includes sections on installing and configuring SQL Server, patching and upgrading, database concepts, backup and recovery, security, high availability and disaster recovery options like log shipping and mirroring, performance tuning, new features of recent SQL Server versions, real-world troubleshooting scenarios, and tools used by database administrators. The course aims to prepare attendees for the role of a database administrator through hands-on instruction and assessments.

    Copyright:

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

    MS SQL DBA Course Content

    Uploaded by

    tejareddy
    619 views5 pages
    The document outlines the topics that will be covered in a SQL Server database administration training course. It includes sections on installing and configuring SQL Server, patching and upgrading, database concepts, backup and recovery, security, high availability and disaster recovery options like log shipping and mirroring, performance tuning, new features of recent SQL Server versions, real-world troubleshooting scenarios, and tools used by database administrators. The course aims to prepare attendees for the role of a database administrator through hands-on instruction and assessments.

    Original Description:

    sql

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document outlines the topics that will be covered in a SQL Server database administration training course. It includes sections on installing and configuring SQL Server, patching and upgrading, database concepts, backup and recovery, security, high availability and disaster recovery options like log shipping and mirroring, performance tuning, new features of recent SQL Server versions, real-world troubleshooting scenarios, and tools used by database administrators. The course aims to prepare attendees for the role of a database administrator through hands-on instruction and assessments.

    Copyright:

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

    MS SQL DBA Course Content

    Uploaded by

    tejareddy
    The document outlines the topics that will be covered in a SQL Server database administration training course. It includes sections on installing and configuring SQL Server, patching and upgrading, database concepts, backup and recovery, security, high availability and disaster recovery options like log shipping and mirroring, performance tuning, new features of recent SQL Server versions, real-world troubleshooting scenarios, and tools used by database administrators. The course aims to prepare attendees for the role of a database administrator through hands-on instruction and assessments.

    Copyright:

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

    1) Overview of SQL Server

     History of SQL Server versions and Editions


     Responsibilities of Database Administrator/DBA Operations
     Over view of SQL Services
     SQL server software life cycle
     Interview Q&A

    2) Installation and Configuration

     Pre installation steps


     Installation
     Post installations steps
     Adding/removing features
     Issues & Troubleshooting
     Interview Q&A

    3) Patching/Service pack installation

     Over view of SQL Server service packs, CU and hotfix


     Pre patch/service pack installation steps
     Patching on standalone servers
     Patching on Cluster servers ( Active/Passive & Active/Active)
     Post patch/service pack installation steps
     Removing the service pack
     Issues & troubleshooting
     Interview Q&A

    4) Overview of Databases

     Server Architecture
     Creating Databases & Over view of database properties
     Database Architecture
     Log Architecture
     Over view of System databases
     Interview Q&A
    5) Backup and Restoration

     Backup types
     Performing Backup and Restoration
     Recovery Model
     Data Recovery Methods for user & system databases
     Page level restore
     Database movement methods ( Attach/Detach, Import/export, copy only & Script Generation)
     Database file movement
     Linked server and creation
     Interview Q&A

    6) Security

     Authentication modes
     Creating logins and users
     Understanding server and Database roles
     Assigning/Removing roles to logins/users
     Granting/revoking object level access
     Security Auditing
     Issues & Troubleshooting
     Interview Q&A

    7) Migration and Up gradation

     Side by side upgrade


     Inplace up grade
     Database Refresh
     Edition upgrade
     Interview Q&A

    8) Automation

     Maintenance plan
     Jobs and alerts
     Database mail configuration
     Interview Q&A

    9) Disaster Recovery and High Availability


    1) Logshipping

     Overview
     Pre requisites
     Configuration
     Failover process
     DR Test
     DB Refresh
     Patching on Log shipping databases
     File Adding and users adding
     Issues & Troubleshooting
     Interview Q&A

    2) Database mirroring

     Overview
     Types of mirroring
     Pre requisites
     Configuration
     Failover process
     DR Test
     Patching
     DB Refresh on mirroring
     File Adding and users adding
     Snapshot creation
     Issues & Troublingshooting
     Interview Q&A

    3) Replication (Snapshot, Transactional and Merge replication)

     Overview
     Pre requisites
     Types of Replication
     Configuration
     Tables adding & removing
     Patching
     Issues & Troubleshooting
     Interview Q&A

    4) Always ON

     Overview
     Pre requisites
     Configuration
     Failover process
     Patching
     DB Refresh on always on
     File Adding and users adding
     DR Test
     Issues & Troubleshooting
     Interview Q&A

    5) Clustering

     Overview
     Pre requisites
     Configuration (Active-Active & Active – Passive)
     Failover process
     Disk adding
     Patching
     Issues & Troubleshooting
     Interview Q&A

    10) Performance tunings

     DBCC and DMV's


     Locks
     Isolation levels
     Blocking
     Dead locks
     Indexes
     Update stats
     Fragmentation
     Query Execution
     Query store
     Interview Q&A

    11) SQL Server 2012, 2014 and 2016, 2017 & 2019 DBA New features

    12) Real time scenarios/Issues

    13) DBA Course Test Scenarios

    14) Ticketing process

    15) Tools
    Ticketing Tool: Remedy,SM9

    Backup Tool: Lite speed backup tool and Networker

    Monitoring Tool: SCOM and Idera performance tool

    Performance Tool: Perfmon, Profiler and Extended Events

    16) Security features

    TDE

    Always encryption

    You might also like