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)
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