SQL Server Database Administration

SQL Server Database Administration

This course is intended for those who want to work as SQL Server Database Administrators. This course equips learners with the necessary skills and knowledge to effectively manage Microsoft SQL Server Administration 2019. It covers essential topics such as installation, configuration, security, backup and recovery, and performance optimization.

Prerequisites: Students are required to have at least Bachelor in Computer Science (or related field) OR Associates with at least two years of work experience in IT field. Students are also required to have a good knowledge of Microsoft Word, Excel, Access, PowerPoint, Internet, extensive knowledge in computer hardware, software, fundamentals of networking and Microsoft Office. An admission test will be taken to qualify a student to be enrolled.

 

An Overview of SQL Server 2012/2014/2016

Demonstration: 04 Hours
Lab : 01 Hour
Total: 05 Hours

An Overview of SQL and PL/SQL

Demonstration: 08 Hours
Lab : 02 Hours
Total: 10 Hours

Configuring SQL Server 2012/2014

Demonstration: 04 Hours
Lab : 01 Hour
Total: 05 Hours

Creating and Configuring a Database

Demonstration: 04 Hours
Lab : 01 Hour
Total: 05 Hours

Monitoring/Tuning SQL Server Performance

Demonstration: 08 Hours
Lab : 02 Hours
Total: 10 Hours

Optimizing SQL Server Performance

Demonstration: 04 Hours
Lab : 01 Hours
Total: 05 Hours

Securing SQL Server

Demonstration: 04 Hours
Lab : 01 Hours
Total: 05 Hours

Automating Tasks with Jobs and Alerts

Demonstration: 04 Hours
Lab : 01 Hours
Total: 05 Hours

Importing and Exporting Data

Demonstration: 04 Hours
Lab : 01 Hours
Total: 05 Hours

Database Replication

Demonstration: 08 Hours
Lab : 02 Hours
Total: 10 Hours

Backing Up and Restoring Databases

Demonstration: 08 Hours
Lab : 02 Hours
Total: 10 Hours

Maintaining Data Reliability

Demonstration: 04 Hours
Lab : 01 Hours
Total: 05 Hours

Maintaining High Availability of Data

Demonstration: 08 Hours
Lab : 02 Hours
Total: 10 Hours

Cloud Integration

Demonstration: 08 Hours
Lab : 02 Hours
Total: 10 Hours

SQL Server Integration Service (SSIS)

Demonstration: 08 Hours
Lab : 02 Hours
Total: 10 Hours

SQL Server Reporting Service (SSRS)

Demonstration: 08 Hours
Lab : 02 Hours
Total: 10 Hours

SQL Server 2012 -MCSA Exam

Demonstration: 08 Hours
Lab : 02 Hours
Total: 10 Hours

REAL-TIME PROJECT BASED BOOT CAMP on SQL Server Database Administration

Demonstration: 0 Hours
Lab : 05 Hours
Total: 05 Hours

Comprehensive Interview training

Demonstration: 10 Hours
Lab : 0 Hour
Total: 10 Hours

Seminar and Presentation

Demonstration: 14 Hours
Lab : 06 Hours
Total: 20 Hours