Introduction to SQL

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.