SQL for
Business
Analytics

SQL is one of the most important languages in today's data-driven world. You'll understand why that is and learn the basics of how SQL works: what different types of databases are out there, the database management systems that are used, and how SQL language can retrieve specific information from these systems.

Assignment 01: Connect to the course database and begin constructing your own queries for specific data requests. Query individual tables, subsetting by column and row using SQL syntax.

Logic and syntax of join statements is the focus of today's class. Learn how to use a variety of join functions across multiple tables and how to avoid common issues with joining, such as duplicate creation.

Assignment 02: Write queries that join data across multiple tables. Practice with the different types of joins, adding conditional statements to joins and performing joins without creating unwanted duplicates.

This class builds on the last to begin constructing queries that return answers to specific questions. You'll learn how to calculate aggregation and to order operations across one or multiple tables.

Assignment 03: Construct queries using aggregation functions to return specific numeric answers. Practice with ranking results and creating nested queries to answer more complex data requests.

Today, you'll apply the techniques you've learned so far to more complex use cases. You'll be presented with several common data questions in the business arena and practice developing a SQL solution for each of them.

Assignment 04: Continue practicing the techniques covered today to solve for a variety of practical business use cases.

Now that you've nailed querying, it's time for data modification and manipulation. You'll learn how to do that by renaming variables, changing data types, and creating new variables.

Assignment 05: Continue writing queries on your own which modify existing data by renaming variables and changing data types. Perform within-query calculations to create new variables.

Date and time data poses specific challenges for databases. In this class, you'll learn how to write queries using date / time functions and be able to perform specific date time operations.

Assignment 06: Practice working with date time data and the complications involved, such as data types, time zone adjustments, and operations with date time variables.

Today, we're learning time series analysis techniques for working with date time data. This class will teach you how to calculate answers to common business questions, such as aggregations by time period, cohort analysis, and growth analysis.

Assignment 07: Build queries to solve common business use cases involving date time data. Practice performing time period operations and aggregations, cohort analysis, and growth analysis.

Today, you'll deepen your understanding of the language with more involved SQL techniques. Finish this class able to employ methods for nesting queries, reusing created data, and joining data on itself.

Assignment 08: Answer more complicated assigned data problems, specifically focusing on using WITH statements to reference the same created data multiple times, joining data on itself, and managing duplicates with SELECT DISTINCT and ROW_NUMBER functions.

You'll learn how to use windows functions to partition data in order to return data and calculations across multiple dimensions.

Assignment 09: Answer more complicated data problems, specifically focusing on using window functions to execute a variety of data manipulation and aggregations

So far, we've learned how to write queries, structure and manipulate data, and solve common business questions using SQL. In this workshop, you'll bring together the techniques you have learned in the course so far to clearly trace how SQL functionality assists in real-life business scenarios.

Assignment 10: Solve the specific data-centered business use cases from Adam.

SQL is just one piece of the fast-moving data analysis industry. This class prepares you to land a data analyst position with tips from Adam's experience hiring for this role.

Assignment 11: Go to indeed.com or LinkedIn and find a job posting you would like to apply for. Analyze what requirements you already meet and what skills you'll need to further develop to apply for that role. Then, update your resumé accordingly.

Database Administrators (DBAs) oversee access control and database development, and knowing how to communicate and work with them is no less essential than knowing how to work with databases themselves. In this class, you'll learn how to construct specific asks to DBAs for data tasks that are typically only performed by DBAs.

We'll wrap up the course with a discussion of the wider trends in data and where we can expect the industry to go in the near future.

Assignment 12: Craft several database modification requests for specific issues which you are likely to encounter in a business context and which usually require the cooperation of a DBA to execute.