Database Management System – SQL Server

Categories: DATABASES
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

By the end of this course you will be a professional SQL database administrator and be able to apply for SQL jobs

  • Administration of SQL database through Microsoft Windows
  • You will be able to troubleshoot everyday SQL related issues
  • You will manage SQL servers in a corporate environment
  • You will write basic to advance SQL queries
  • Troubleshoot everyday SQL database related issues
  • Know how to answer specific business questions by using SQL’s aggregate functions
  • Run reports for management so they can make financial decisions

Course Content

Module 1: Introduction to Database Administration

Module 2: Installing and Configuring SQL Server 2017 and 2019

Module 3: Databases and Storage

Module 4: Backup

Module 5: Restoring

Module 6: Importing and Exporting Data

Module 7: Trace flags

Module 8: SQL Server Security

Module 9: Database Maintenance

Module 10: Monitoring SQL

Module 11: SQL Server high availability and disaster recovery

Module 12: Azure SQL Database