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!
Apply Now

courses details

Accelerated On-Site Training - MSSQL Server Database Administration

This course is an accelerated in-person training for MSSQL Server Database Administration in Stafford-Texas. We provide the best on-site 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

$4000 ( On-site Training)

300+ Hours of intensive hands-on training

Duration: 3 months  ( prior IT background required)

Class Schedule: Monday to Thursday 6-8PM CST

Prerequisites

  • Background in Information Technology (IT) - compulsory
  • On-site availability for in-person training in Stafford-Texas
  • Fast learning capabilities 

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 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 DAntoni (Author)

Possible Career After the training:

Database Administrators

Database Engineer

Microsoft Azure Administrator

Database Solution Architect

Sr. Microsoft Developer

Sr. Database Administrators



Complete SQL Server Database Administration Course

SQL Server Overview

Installing and Configuring SQL Server

Installing and Configuring SQL Server

SQL Server Database Design

Building and Managing Indexes

Table Compression

Table Partitioning

Select Statements

DML Operations

Stored Procedures

Views

Replication Technology

Database Maintenance

Maintenance Plans

Monitoting SQL Server

SQL Server Automation

Disaster Recovery Technologies in SQL Server

SQL Server Performance Tuning

SQL Server Security

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 *

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

Contact Us

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