DBA

server

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)

server
  • \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
InstructorsEmailOffice Location & Hours
Denis Kiawi, PhD

Mrs. Forster Nchanji

Mr. Zebedde Kiawi

Mr. Romeo Mambel

Mr. Milton Chia

Beltus Ndisang

denis.kiawi@kiawitech.com

Forster.Nchanji@kiawitech.com

Zebedee.kiawi@kiawitech.com

Romeo.Mambel@kiawitech.com

Milton.chia@kiawitech.com

Beltus.Ndisang@kiawitech.com

1426 Hackberry Heights Dr Richmond 77406 TX USA:  

Mon- Fri: 8-5 pm

  1. Computer basics
  2. SQL Server Overview
  3. Installing and Configuring SQL Server 2017
  4. Designing SQL Server databases
  5. Creating your First Table in SQL Server
  6. Building and managing Indexes in SQL Server
  7. Table compression
  8. Table Partitioning
  9. Database snapshots
  10. SELECT STATEMENTS
  11. DML Operations
  12. Scalar Functions
  13. Stored Procedure
  14. Views
  15. Data Manipulation Triggers 
  16. Replication Technology
  17. Database Maintenance
  18. Managing and maintaining indexes and statistics
  19. Maintenance Plans
  20. Monitoring in SQL Server
  21. Automating SQL Server administration
  22. SQL Server Security
  23. High Availability Solutions in SQL
  24. Disaster Recovery Technologies in SQL
  25. Administering Microsoft SQL Server AlwaysOn Availability Groups
  26. SQL Performance Tuning

Project 1 – Sql installation.
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.