What it is about:-

This module will teach students how to write necessary Transact-SQL queries for MS SQL Server 2016. This module is planned for Database Developers, Database Administrators, and Business Intelligence professionals. After completing this module, students will be able to: explain the basic architecture and concepts of MS SQL Server and comprehend the differences and similarities between Transact-SQL and other computer languages.

This module will teach students how to maintain a MS SQL Server 2016 database. After completing this module, students will be able to explain core database administration tasks, restore databases from backups, carry out ongoing database maintenance and set up and configure SQL Server 2016.


  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Executing queries which sort data using ORDER BY
  • Using Column and Table Aliases
  • Querying with Cross Joins and Self Joins
  • Working with Unknown and Missing Values
  • Writing Queries That Use Character Functions
  • Using Inline Table-Valued Functions
  • Exploring Window Functions
  • Writing Queries with UNPIVOT and PIVOT
  • Describe common database administration tasks
  • Perform post-installation configuration tasks
  • Configure the buffer pool extension
  • Perform copy-only, compressed, and encrypted backups
  • Use Performance Monitor to monitor SQL Server
  • Manage database-level security principals
  • Implement SQL Server audit
  • Manage SQL Server audit
  • Configure Database Mail
  • Generate Database Tuning Recommendations
  • Monitor SQL Server errors
  • Manage Server-Level Security
  • Manage Database-Level Security
  • Use captured traces to test, troubleshoot, and optimize database performance

Who should attend:-

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.


Tk. 26,500/-


Sorry! No course schedule to display right now.
For Further Query Please Contact @ 01713397567-8

Enquiry for MS SQL Server course


For Further Query Please Contact @ 01713397567-8
Other Courses