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. 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.

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