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