Program : Database Administration

Course Name : Getting Started with SQL Server 2012

Course Code Course Fee
INFTE X 1330.1 $ 69

In this course, you will learn the basics to create a well-designed database using SQL Server 2012. SQL Server 2012 is a full-featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. Student will also learn how to manipulate the stored data and return meaningful results to help analyze the data stored. Upon completion of this course, student will be able to create and manage full fledge databases using SQL and T-SQL Commands.

Course Format

This is hand-on course. We apply a powerful learning cycle of short lecture, self learning material, specialized dictionaries, and eBooks. To enhance ones personality IT simulations and Power Point presentations are conducted. Self Assessment tests, Online Assessments and Online Exams are there to test student’s knowledge and skills. This course covers:-

  • Introduction to SQL Server 2012
  • Installing SQL Server 2012
  • Introduction to SQL Server Management Studio
  • Performing Basic SQL and T-SQL operations
  • Stored Procedures and User-Defined Functions
  • Triggers, Transaction, Locking, and Error Handling
  • Indexing, Partitioning, and Resource Governance
  • Policy-Based Management
  • Backup, Recovery, and Master Data Services

Course Location

Online Vlearn Portal