Certificate in Microsoft SQL SEVER 2012

Microsoft SQL SERVER 2012 – Basic Level for the Beginners

  • Installing, Configuring SQL Server
  • SELECT Statement
  • Creating Tables and Enforcing Data Integrity
  • Designing and Creating Views, Inline Functions, and Synonyms
  • Inserting, Updating, and Deleting Data
  • Designing and Implementing T-SQL Routines
  • Introducing Indexes
  • Configuring and Maintaining a Backup Strategy

 

MS SQL SERVER- Advanced Level – Industry oriented

  • Merging Data
  • Querying Full-Text Data
  • Querying and Managing XML Data
  • Implementing Transactions, Error Handling, and Dynamic SQL
  • Using Tools to Analyze Query Performance
  • Implementing Indexes and Statistics
  • Mirroring and Replication
  • Clustering

Programme Duration:   3 Months
Saturdays  : Basic Level:  9.30 a.m. – 12.30 p.m.
Advanced Level :  1.30 p.m. –   4.30 p.m.

Phone: 021 221 6400  |  Hotline:0776 28 48 45
Web: www.exampoint.lk  |  Mail: info@exampoint.lk