832-304-1771

Course Outline

Administering Microsoft SQL Server Databases – 20462 Course Outline

Course Duration 3 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
After completing this course, students will be able to:
• 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

 

Live Virtual Class Format
A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content is highly prohibited.