This self-paced CertPREP IT Specialist Databases course serves as a foundation layer of many web and data applications, business reporting functions, and prediction algorithms. In this course, students will learn:

• how to design and optimize a database
• how to create, update and delete records and tables
• how to filter and aggregate data
• how to automate certain procedures

Taken together, these skills will serve as an entry point into data-related careers in reporting, data engineering, and automation.

Course components:

• Lessons
• MeasureUp Practice Test for IT Specialist Databases. Practice Mode with remediation and Certification mode to simulate the test day experience.
• Labs

Duration: Approximately 36 hours of primary course content. Each learner will progress at their own rate.

Audience:

Designed for any learner interested in obtaining a working-level proficiency with databases. After completing this course, you will be able to perform the basic responsibilities of an entry-level professional in the IT field or take advanced database courses that will allow you to become a database administrator.

Prerequisites:  None

Required course materials: Self-paced CertPREP IT Specialist Databases Courseware.

Course objectives:

Upon successful completion of this course, students should be able to:  

• Translate business case into a normalized database design
• Create and maintain tables, views, and stored procedures that support business operations
• Create and maintain tables, views, and stored procedures that support reporting functions
• Optimize and troubleshoot queries