Pay as you go
- Maximum flexibility to learn at your own pace.
- Cancel anytime.
Get access to classroom immediately on enrollment
Write common SQL commands including SELECT, FROM and WHERE and use logical operators such as LIKE, AND and OR.
Write JOINs in SQL to combine data from multiple sources to answer more complex business questions, and understand different types of JOINs and when to use each type.
Write common aggregations in SQL including COUNT, SUM, MIN and MAX, and write CASE and DATE functions, as well as work with NULLs.
Write subqueries to run multiple queries together, learn the types of subquery placement and formatting, and use temp tables to access a table with more than one query.
Learn and apply the basics of data cleaning strategies in SQL to normalize or create a column from existing data, and perform the appropriate data cleaning methodology based on goals for further analysis.
Apply core window functions to tackle analysis tasks that require further targeting or segmentation, and use other window functions including RANK, NTILE, LAG, LEAD new functions along with partitions to complete complex tasks.
Learn how and when to use advanced joins (e.g., self joins) to write queries that run quickly across giant datasets, and learn the high-level tradeoffs with queries, including performance and what you can do to optimize them.
SQL is most commonly used to manipulate and analyze data to inform decision making. In this project, you will act as a data analyst for an organization on a mission to reduce deforestation around the world and to raise awareness about this important environmental topic. First, you’ll clean any erroneous values in a table, join that table to another lookup table to bring in a new categorical and quantitative variable and return a new view of all categories greater than a reference value. Then, you will create and execute SQL queries to perform calculations using variables from those disparate data sets to answer questions for stakeholders. Your analysis will help you better understand which countries and regions around the world seem to have forests that have been shrinking in size, and also which countries and regions have the most significant forest area. Lastly, you will compile your answers and summarize your analysis into a report that can be shared to a leadership team.
Senior Product Manager at CircleUp
Malavica is a Senior Product Manager with over five years of experience. Her work includes building Helio, an ML platform used to identify breakout brands in early-stage consumer packaged goods companies.
Software Developer and Co-Founder DecodeMTL
Ziad is a seasoned software developer who loves mentoring and teaching. Currently working as an independent contractor, he previously co-founded and taught full-stack web development at DecodeMTL, Montreal's first web development bootcamp.
CEO at Mode
Derek is the CEO of Mode Analytics. He developed an analytical foundation at Facebook and Yammer and is passionate about sharing it with future analysts. He authored SQL School and is a mentor at Insight Data Science.
Pay as you go