Microsoft SQL Server Implementation & Administration
Course Features
Lectures36
Quizzes5
Duration3 months
Skill LevelAdvanced
Students30
CertificateYes
AssessmentsYes
This course will teach you about basic architecture and concepts of MS SQL Server, comprehend the differences and similarities between Transact-SQL and other computer languages and how to maintain a MS SQL Server database. After completing this course, you will be able to explain core database administration tasks, restore databases from backups, carry out ongoing database maintenance and set up and configure SQL Server 2016.
Course Requirement
- 1SQL Server Architecture
- 2Installing SQL Server
- 3Upgrading SQL Server
- 4Managing and Troubleshooting the Database Engine
- 5Automating SQL Server
- 6Service Broker in SQL Server
- 7SQL Server CLR Integration
- 8Securing the Database Instance
- 9Change Management
- 10Configuring the server for Optimal Performance
- 11Optimizing SQL Server
- 12Monitoring your SQL Server
- 13Performance Tuning T- SQL
- 14Indexing your Database
- 15Implementing replication
- 16Clustering SQL Server
- 17Backup and Recovery
- 18SQL Server Log Shipping
- 19Database Mirroring
