
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