Zach Grammon

Recipients of Uplimit's Advanced dbt certificate have acquired the expertise to effectively tackle typical obstacles encountered when expanding dbt projects in a team setting. They focussed on automation, workflow streamlining, data quality, and performance optimization. They are now equipped to establish and sustain resilient data transformation and modeling systems to support the growth of their analytics work.

Certification criteria:

Actively participated in Uplimit’s dynamic course on Advanced dbt: attended lectures, project sessions, fireside chat with industry experts, engaged in dynamic peer review sessions, and more.

February 19, 2024 Instructor: Lindsay Murphy

issued by

Completed projects that aimed to enhance dbt (data build tool) projects by focusing on automation and workflow optimization, scaling data quality management, and improving team management.

Learned how to overcome common challenges when scaling dbt projects with a team, covering topics such as automation, workflow optimization, data quality management, and project performance improvement.

Recipients of the Uplimit Advanced SQL certificate have learned to ensure query accuracy, improve maintainability and understandability, and optimize efficiency. This comprehensive course has focused on bringing together all of these topics to equip learners with the skills they need to confidently assess, improve, and maintain complex SQL code on realistic data. Through hands-on projects, learners have gained practical experience and have the ability to excel in any SQL-related tasks.

Certification criteria:

Actively participated in Uplimit’s dynamic course on Advanced SQL: attended lectures, project sessions, fireside chats with industry leaders, and more.

Learned the SQL Style Guide, reworked a query to improve its readability, learned about subqueries & CTEs, and have performed complex joins.

November 20, 2023 Instructor: Meredith Alder

issued by

Developed best practices for evaluating a candidate's SQL tech exercise, tuning queries and joins, and used SQL to analyze key business terms and metrics.

Recipients of Uplimit Intermediate SQL have gained a comprehensive foundation of SQL.They learned how to manipulate tables, query multiple tables, and complete complex subqueries and joins. They've built projects around manipulating single tables, querying multiple tables, and writing complex queries using subqueries including EXISTS, NOT EXISTS, subqueries vs, joins and CTE.

Certification criteria:

Actively participated in Uplimit’s dynamic course on Intermediate SQL: attended lectures, project sessions, and more.

Built projects that apply concepts to create, manipulate, and extract information from a real world data set, split a single table into multiple tables so that there is no redundancy in data, and write queries that involve working with multiple tables, and combined all of this knowledge to complete an advanced project using skills from for the course including subqueries vs. joined and CTE.

October 20, 2023 Instructor: Sanjay Saraf and Chien Ho

issued by

Developed familiarity with fundamentals of SQL and ways to write queries including primary keys and foreign keys, normalization, CROSS JOIN, INNER JOIN and OUTER JOIN, as well as EXISTS, NOT EXISTS, and CTE.