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

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

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

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