What you will Learn
In this course, you’ll learn to use Structured Query Language (SQL) to extract and analyze data stored in databases. You’ll first learn to extract data, join tables together, and perform aggregations. Then you’ll learn to do more complex analysis and manipulations using subqueries, temp tables, and window functions. By the end of the course, you’ll be able to write efficient SQL queries to successfully handle a variety of data analysis.
What is SQL?
SQL (Structured Query Language) is a programming language designed for managing data in a relational database. It’s been around since the 1970s and is the most common method of accessing data in databases today. SQL has a variety of functions that allow its users to read, manipulate, and change data. Though SQL is commonly used by engineers in software development, it’s also popular with data analysts for a few reasons:
- It’s semantically easy to understand and learn.
- Because it can be used to access large amounts of data directly where it’s stored, analysts don’t have to copy data into other applications.
- Compared to spreadsheet tools, data analysis done in SQL is easy to audit and replicate. For analysts, this means no more looking for the cell with the typo in the formula.
SQL is great for performing the types of aggregations that you might normally do in an Excel pivot table—sums, counts, minimums and maximums, etc.—but over much larger datasets and on multiple tables at the same time.
Course Outline for SQL
-
SQL Basics
- Learn to write common SQL commands including SELECT, FROM, and WHERE
- Learn to use logical operators in SQL
-
SQL Joins
- Learn to write INNER JOINs to combine data from multiple tables
- Learn to write LEFT JOINs to combine data from multiple tables
-
SQL Aggregations
- Learn to write common aggregations in SQL including COUNT, SUM, MIN, and MAX
- Learn to write CASE and DATE functions, as well as work with NULL values
-
Subqueries and Temp Tables
- Learn to write subqueries to run multiple queries together
- Learn to use temp tables to access a table with more than one query
-
SQL Data Cleaning
- Learn how to perform data cleaning using SQL
-
Window Functions
- Learn to use window functions to tackle more analysis tasks
Course Duration:
1 month
6 credit hours / week
REGISTER FOR THE COURSE
Fill form to book your class
[forminator_form id=”493″]
