Interested in any of our courses? Contact our career coaches via email at info@kiawitech.com or call us at +1 (346) 404-4120. Zero tech skills? No problem! We train you from scratch!

courses details

Microsoft SQL Server Database Administration (DBA)

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.

Description

$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

Course Overview

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

Good laptop of 16GB of total physical memory running on Windows PRO version

Required 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



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

Module 1: Microsoft Azure Fundamentals

Module 2: Understanding Azure Platform As A Service (PAAS)

Module 3: Azure Virtual Networks

Module 4: Infrastructure As A Service (IAAS) Azure Storage

Module 5: Interview Bootcamp and Mentorship

review

Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam.

Add a Review

Your email address will not be published. Required fields are marked *

Maik

Review for test

Your Rating *

About the instructor

Dr. Denis Kiawi / Instructor

Dr. Denis Kiawi is the Founder and Chief Executive Officer (CEO) of KiawitechIT Academy. With more than 10 years of Professional experience as Senior Database Administrator and Clous Solution Architecht, Dr. Kiawi shares his knowledge with his IT trainees in the fields of MSSQL Server Database Administration and Azure Cloud Computing. He also doubles as a professional coach and mentor.\\r\\n In his early career, Dr. Kiawi rose to the summit of astronomical studies by obtaining a rare and highly competitive scientific PhD in ‘Infrared studies of astronomically relevant metallic clusters and their interactions with simple molecules’. Dr. Kiawi dwelled in academia for years before transitioning to take over the world of information technology. He created the life changing KiawiTechIT academy, which is today transforming ordinary people into IT gurus. KiawiTechIT Academy is, in fact, a product of the Kiawi Group of companies, which comprises of; KiawiTechIT Academy LLC, The Kiawi Investment Ltd, Kiawi Foundation and the Kiawi Farms. KiawiTechIT Academy was created with the aim of giving back to society through education with focus on specialized fields of information technology like database administration (DBA), Azure cloud Computing and Amazon Web Services (AWS). Under his erudite leadership, the Academy has successfully graduated and placed over 300 trainees in the job market around the world.\\r\\n

Dr. Ernest N. Tingum / Instructor

Dr. Ernest Ngeh Tingum is a professional, highly analytical and proactive Database Administrator based in Windhoek, Namibia. He is a Microsoft SQL Server Database Administration Instructor at KiawiTechIT Academy. He is a certified Microsoft Azure Administrator and also has experience working with Amazon Web Services (AWS) cloud computing. He has worked in diverse environments and has experience in over 25 Countries Worldwide.

Cyprain Fang Awah / Instructor

Mr. Cyprain F. Awah is the Director of Programs and a Senior Instructor for MSSQL Server Database Administration and Azure Cloud Computing at KiawiTechIT Academy. With a fervent passion and over 18+ years diverse experience, varied certifications and accomplishments in several I.T. fields, Cyprian, is a future-ready Senior I.T. Engineer, Consultant and instructor in Database Management, Networking, Cloud Computing, Server Administration, POS, Intercom, Surveillance & Security Systems, a technopreneur and general I.T. Solutions Provider. He is also an IT Career Coach and mentor to many successful IT professionals in the field.

Milton Chia / Instructor

Milton Chia is the DIrector of Public Relations and Instructor for MSSQL Server Database Adminstration at KiawiTechIt Academy. He brings more than 15 years of hands-on experience in the field of Information Technology where he started off in the branch of Cyber Security. He holds multiple IT certifications including MCSA SQL 2016, Comptia Security +, AWS Cloud Practitioner, AWS Solutions Architect, SAFe Scrum Master Certified, and PSM. Mr. Milton Chia also doubles as career coach and mentor for multiple successful Database administrators.

Maxime Tonshir / Instructor

Maxime is an experienced and certified Senior MSSQL Server Database Administrator with extensive pedagogic skills and experience. He brings more than 7 years of experience in the IT field, with proven and certified knowledge in Business Intelligence and Data Analysis, Microsoft Office Specialist Expert and Microsoft SQL Server Database Administration.

Tabi Enowkenwa / Instructor

Tabi is a seaseoned senior MSSQL Server Database Administrator with cross IT industry experience and skills in \\r\\n MS Azure Cloud Computing, MariaDB and MaxScale Database Administration.\\r\\nHe is proficient in Database Design, performance tuning, high availability and disaster recovery solutions (HADR) both in MSSQL ans Azure environments. He is equally a specialist in MariaDB installations, efficiency and scalability as well as deployments.

Shanceline Fon / Instructor

Shanceline is a certified Senior MSSQL Server Database Administrator with multiple years of experience both in the classroom and on the field. She brings handson pedagogic and practical experience to the classroom for exchange with KiawiTechIT Academy\\\\\\\\\\\\\\\'s trainees.

$ 3,500.00
  • Course level Intermediate
  • Course Duration 180 days
  • Lessions 7
  • Quizzes 2
  • Certificate Yes

secure payment

  • Monday : 01:00 pm - 04:00 pm CST
  • Thursday : 01:00 pm - 04:00 pm CST
  • Monday : 01:00 pm - 04:00 pm CST
apply now
  • Monday : 08:00 pm - 11:00 pm CST
  • Wednesday : 08:00 pm - 11:00 pm CST
  • Thursday : 08:00 pm - 11:00 pm CST
apply now

Where your most innovative Self Starts

Our Vision is to make careers in the IT industry accessible and affordable for all, by providing a platform where full potentials can be attained.

register now