SQL Server Database Administration (DBA) Training

course contents

Section 1: Querying SQL Server & T-SQL

  1. Introduction

  2. Installing & Configuring SQL Server

  3. Database Design & TSQL

  4. Normalization

  5. Table & Constraints

  6. Joins & Views

  7. Indexes

  8. Functions & Stored Procedures

  9. Cursors & Triggers

  10. Transactions, Locking & Blocking

Section 2: Administering SQL Server

  1. Database Backup

  2. Database Restore

  3. Managing Security

  4. Snapshot & Encryption

  5. SQ Server Agent & Maintenance Plans

  6. Partitions

  7. FTS, MoT & Temporal Table

  8. PBM & Linked Server

  9. Data Migration

  10. Mirroring

  11. Log Shipping

  12. Replication

  13. Windows Failover Cluster

  14. Always On Availability Groups

  15. Migration, Update & Upgrade

  16. Performance Monitoring & Tuning

course includes

  • Rich Course Materials

  • Recorded Videos of Each Class

  • Reading Materials

  • Lab Exercises

  • Microsoft Certification Materials

  • Mock Interview

  • Resume Preparation

  • Placement Assistance

  • On the Job Support

class schedule

  • Saturday: 9:45 am - 12:15 pm CST

  • Wednesday: 6:00 pm - 8:00 pm

  • Total Hours: 70 

Orientation Class

© 2019 GuzzoTech Consulting LLC