MS SQL Server Administration

Microsoft SQL Server continues to be one of the world’s most popular and top databases. Database is a heart of IT which is needed to stored all critical data and information. This training course will provide you all the necessary skills you need to be a successful database administrator.

Course Objectives

After completing this course, students will be able to
  • Start from scratch by installing Microsoft SQL Server 2016 and create a practice environment for yourself.
  • You will be familiarized with some of the core concepts of RDBMS / SQL Server.
  • Ins and outs of SQL Server Management studio.
  • Create and connect SQL server colud database using Amazon AWS and Microsoft Azure.
  • Create, alter and drop database.
  • Create, alter and drop tables.
  • Insert, update and delete records from tables.
  • Constructing your SELECT statement to retrieve data from SQL Server.
  • Filter out unwanted data by using WHERE clause as well as, you would know how to order your result set by using ORDER BY clause.
  • Use UNION / UNION ALL operators
  • Group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.
  • SQL Server. Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Cross Join and Self Join.
  • String functions, date functions, and system functions.
  • Create your own function.
  • Create, alter and drop Stored Procedure and advantages of stored procedure.
  • Create, alter and drop Trigger and its advantage.
  • Create, alter and drop View and its advantage.
  • Temp tables and its advantage.
  • Handel exceptions in SQL Server.
  • Import data from excel file, flat file, another SQL server database and MySQL.
  • Export data to excel file, flat file and another SQL server database
  • Bulk Insert &  Cursors.

Target Audience

  • System Engineer
  • IT Professionals

Course Pre-Requisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.

Course Summary

Course Fee

৳ 20,000

Training Method


Total Modules


Course Duration

60 Hours

Total Session


Class Duration

3 Hours

Details Course Outlines


Create Transact-SQL SELECT queries


Query multiple tables by using joins


Implement functions and aggregate data


Modify data


Query data by using subqueries and APPLY


Query data by using table expressions


Group and pivot data by using queries


Query temporal data and non-relational data


Create database programmability objects by using Transact-SQL


Implement error handling and transactions


Implement data types and NULLs