UTOPIA MATH Academy

sql server4

MICROSOFT SQL SERVER DATABASE ADMINISTRATION

Date: To Be Determined
Course Instructor: Yessuf A.
Time: Two Days per week (2 hours/day)
Duration: 8 Weeks
We provide instructor-led SQL Server Database Administrator training that prepares you with all the skills required to become a successful database administrator. After completing this course you will be ready to take the Microsoft Certificate Exam that makes you Certified Database Administrator and opens the door to this widely accepted profession. 
Taking this SQL Server classes is the first step in your carrier to advance your marketability, sharpen your database skills and help your compute in today’s competitive job market.  
Database Administration is one of the best paying jobs in America with an average salary of 90K. There is high demand for database administrators at the moment. According to the Bureau of Labor Statistics, database admin jobs are projected to increase by 11% in the next decade. This growth is due to more companies needing to collect and store data properly. If you have training in cloud-based technologies and databases, there is even more projected growth, with job demand increasing up to 17%, according to the BLS.
Course Syllabus
After completing this course, students will be able to:
  • Understand the Relational Database.
  • Install and Configure SQL Server Instances.
  • Create Databases and database objects.
  • Design a backup strategy.
  • Design restore strategy.
  • Import and Export data.
  • Learn TSQL for database management.
  • Manage SQL Server Security.
  • Query tuning and SQL Server Performance Troubleshooting.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.
  • Configure Database Mail, alerts, and notifications.
  • Design High Availability and Disaster Recovery.
  • Learn ETL (Extraction, Transportation, Load) of Historical Data.