This certification lays the foundational skills for querying with SQL (Structured Query Language), the standard language for database interaction. You will start with the basics of database theory, SQL syntax, and the construction of simple queries to select data. As you progress through the course series, you'll learn to sort and filter data, use aggregate functions and group results, and understand the basics of joining tables. By the end of this certification, you'll be equipped to write basic SQL queries that can be used to extract and manipulate data across various database systems.
Who Should Take This Certification?
As a popular database language, SQL is a great entry point for anyone interested in analyzing data. Employees such as marketers, managers, public health specialists, financial planners and accountants, researchers, and insurance experts all use SQL daily. This certification will help you be more competent in data management AND confident in data accuracy and validity. Employees and job seekers looking to improve their database management skills should also consider this certificate for professional development.
Workplace Skills
- Fundamental Querying Skills: Gain the skills to write basic SQL queries, which are essential for any task that involves database lookup or data manipulation.
- Data Sorting and Filtering: Learn to sort and filter datasets to retrieve the precise data you need for reporting and for efficient, relevant interactions with other databases.
- Data Aggregation: Master the use of aggregate functions to summarize data, which provide the big-picture data you need to understand trends and potential future states.
- Advanced Data Functions: Master advanced SQL functions and expressions to perform sophisticated data calculations and manipulations.
- Basic Joins and Relationships: Understand how to join tables to consolidate data from multiple sources, a vital skill for generating comprehensive reports and analyses.
Requirements
This certification includes a series of progressive courses: Introduction to SQL, Intermediate Applications of SQL, Advanced SQL Queries Level 1, and Advanced SQL Queries Level 2. Completing this four-course sequence will result in issuing this certification and the accompanying badge, which may be displayed in your email signature and on LinkedIn.
Schedule
Courses are held monthly and may be taken online synchronously or in person at our training center in Des Peres, St. Louis County, Missouri. Employers and job centers may also request training held at an offsite location. Please contact info@cetc.umsl.edu for further information.
Pathways
This certification satisfies 26 hours of the required courses for the following UMSL Chancellor’s Certificates: Data Analysis, Database Technology, Programming, and Web Development Certifications. Each course is worth 0.65 CEUs.
For More Information
For more information and registration details, please visit the dedicated course area on our website or contact our support team at info@cetc.umsl.edu.