Courses

Course Outline

Administering Microsoft SQL Server Databases – 20462 Course Outline

Course Duration 4 months

Training Style:  Live Instructor-Led online Class

Tuition fee: $2,500 (Installment payment is acceptable)

Overview
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012,2014 and 2016 database. The course focuses on teaching individuals how to use SQL Server product features and tools related to maintaining a database.

Note: This course is designed for customers who are interested in learning SQL Server 2012, SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server, but also the important capabilities across the SQL Server data platform.

At course completion, students will be able to do the following:

  • Describe key database concepts in the context of SQL  Server 2012 through 2016
  • Describe database languages used in Server 2012 through 2016
  • Describe normalization and denormalization techniques
  • Describe relationship types and effects in database design
  • Describe the effects of database design on performance
  • Describe commonly used database objects, be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL.
  • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE Constraints, and investigate cascading FOREIGN KEY constraints. 
  • Determine appropriate single column and composite indexes strategies.
    Create tables as heaps and tables with clustered indexes. Also, consider the design of a table and suggest an appropriate structure.
  • Read and interpret details of common elements from execution plans.
  • Design effective non-clustered indexes. 
  • Design and implement views 
  • Design and implement stored procedures.
  • Describe core database administration tasks and tools.
  • Install and configure SQL Server.
  • Configure SQL Server databases and storage.
  • Plan and implement a backup strategy. 
  • Restore databases from backups.
  • Import and export data. 
  • Monitor SQL Server. 
  • Trace SQL Server activity 
  • Manage SQL Server security
  • Audit data access and encrypt data
  • Perform ongoing database maintenance
  • Automate SQL Server maintenance with SQL Server Agent Jobs
  • Configure Database Mail, alerts and notifications
  • Understand Different types of High Availability Solutions

 

 

Modules to be covered

Module 1: Introduction to SQL Server Database Administration

Module 2: Installing and Configuring SQL Server

Module 3: Working with Databases and Storage

Module 4: Planning and Implementing a Backup Strategy

Module 5: Restoring SQL Server Databases

Module 6: Importing and Exporting Data

Module 7: Monitoring SQL Server

Module 8: Tracing SQL Server Activities

Module 9: Managing SQL Server Security

Module 10: Auditing Data Access and Encrypting Data

Module 11: Performing Ongoing Database Maintenance

Module 12: Automating SQL Server Management

Module 13: Monitoring SQL Server by Using Alerts and Notifications

Module 14: Normalization

Module 15: Relationships

Module 16: Performance

Module 17: Database Objects

Module 18: Introduction to Database Development

Module 19: Designing and Implementing Tables

Module 20: Introduction to Indexing

Module 21: Designing and Implementing Stored Procedures

Module 22: Designing and Implementing User-Defined Functions

Module 23: Responding to Data Manipulation via Triggers

Discounts and promotions are currently available

Get In Touch