
Microsoft SQL Server Database Administration (DBA)
$3500 ( instructor-led)
$2000 (Self paced through recorded videos and hand-on labs)
$1200 (For our trainees attending from Africa. This is a 60% discount aimed at empowering those from third-word countries thanks to a collaboration from the Kiawi Foundation)
- \300+ Hours of intensive hands-on training
- \Duration: 6-8 months depending on your previous background
- \Facilitated by top Sr. Databases administrators
- \Group Projects/ Capstone Project
- \Direct path to becoming certified
- \Certification: Microsoft Certified Associate (MSCA)
- \Exams: 70-764 and 70-765
Microsoft SQL Server Database Administration (DBA)
$3500 ( instructor-led)
$2000 (Self page through recorded videos and hand-on labs)

- \300+ Hours of intensive hands-on training
- \Duration: 6-8 months depending on your previous background
- \Facilitated by top Sr. Databases administrators
- \Group Projects/ Capstone Project
- \Direct path to becoming certified
- \Certification: Microsoft Certified Associate (MSCA)
- \Exams: 70-764 and 70-765
Course Overview
This course lets you gain full proficiency in the SQL Database as an administrator. We provide the best online training classes to help you learn database administration (using SQL Server), database design, implementation, support, and maintenance. Moreover, you will work on real-world industry projects at the end of this program.
You will learn the skills of a SQL Server Database Administrator, which include; install SQL Server in a Production environment following best practice, review storage, data and log files necessities, understand the importance of backups and restores, configure security and more..
Expectations and Goals
Students in this program are expected to gain knowledge in managing SQL Server Databases.
Audience
- Database Administrators and Developers
- Project Managers, Analysts, and Testers
- Big Data and Hadoop Professionals
- Individuals looking for a career change, who are interested in learning about the benefits of Microsoft SQL Server
Course Materials
Required Materials
- Good laptop of 16GB of total physical memory running on Windows PRO version
Required Text Books
Books online
- 1) Microsoft SQL Server 2012 Step by Step (Step by Step Developer) 1st Edition by Patrick LeBlanc (Author)
- 2) Microsoft SQL Server 2016: A Beginner’s Guide, Sixth Edition 6th Edition by Dusan Petkovic (Author)
- SQL Server 2017 Administration Inside Out 1st Edition by William Assaf (Author), Randolph West (Author), Sven Aelterman (Author), Mindy Curnutt (Author)
- SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance 5th ed. Edition by Grant Fritchey (Author)
- SQL Server 2017 Administrator’s Guide: One stop solution for DBAs to monitor, manage, and maintain enterprise databases by Marek Chmel (Author), Vladimir Muzny (Author)
- MCSA SQL 2016 Database Administration Exam Ref 2-pack: Exam Refs 70-764 and 70-765 1st Edition by Victor Isakov (Author), Paul Marquardt (Author), Joseph D’Antoni (Author)
Possible Career After the training:
- Database Administrators
- Database Engineer
- Microsoft Azure Administrator
- Database Solution Architect
- Sr. Microsoft Developer
- Sr. Database Administrators
Instructors | Office Location & Hours | |
Denis Kiawi, PhD Mrs. Forster Nchanji Mr. Zebedde Kiawi Mr. Romeo Mambel Mr. Milton Chia Beltus Ndisang | [email protected] Forster.Nchanji@kiawitech.com | 1426 Hackberry Heights Dr Richmond 77406 TX USA: Mon- Fri: 8-5 pm |
- Computer basics
- SQL Server Overview
- Installing and Configuring SQL Server 2017
- Designing SQL Server databases
- Creating your First Table in SQL Server
- Building and managing Indexes in SQL Server
- Table compression
- Table Partitioning
- Database snapshots
- SELECT STATEMENTS
- DML Operations
- Scalar Functions
- Stored Procedure
- Views
- Data Manipulation Triggers
- Replication Technology
- Database Maintenance
- Managing and maintaining indexes and statistics
- Maintenance Plans
- Monitoring in SQL Server
- Automating SQL Server administration
- SQL Server Security
- High Availability Solutions in SQL
- Disaster Recovery Technologies in SQL
- Administering Microsoft SQL Server AlwaysOn Availability Groups
- SQL Performance Tuning
Project 2 – Windows Patching.
Project 3 – SQL Server Patching and Service packs upgrade (e.g SP for SQL 2016).
Project 4 -In-place and Side-by-side upgrade from SQL 2017 or 2019.
Project 5 – Creating an Availability Group (AG) in SQL Server.
Project 6 – SQL Server Decommissioning.
Project 7 – Configuring Log shipping in a 2 node cluster.
Project 8 – Configuring Database Mirroring in a 2-node cluster.
Project 9 – Configuring Replication.
Project 10 – Managing Logins and Permission for a multi-user environment.
Project 11 – SQL Server Monitoring using External Tools.
Project 12 – Using external Tools for Backup and Restores.
Project 13 – Working with Data Domain Replication Technology.
Project 14- Configuring Disaster Recovery Technologies in SQL.
Project 15 – Working with Remedy Ticketing Systems– Handling day-day tasks of DBA.
Project 16 – Database References.
Project 17 – Application Deployment in Production Servers.
Project 18 – SQL Server Performance Tuning and Monitoring.
Project 19 – Introduction to SSIS/SSRS/SSAS.
Project 20 – Introduction to Microsoft Azure.