SQL for Beginners - A Data Analyst Path

Description

What is this class about?

You're in the right place if you're looking to learn how to turn data into insightful real-world solutions. SQL is the most popular programming language used to manage and explore data stored in databases. It is a vital tool in any Data Analyst toolkit.

In this class, you'll learn how to use SQL from scratch. We'll download the tools we need to start off by creating our own database and filling it with data and then we'll explore it using SQL queries. This class is the perfect place for you if you're curious about data, how it's stored, and how to explore it.

What will I learn in this class?

Throughout this class, you will learn how to use SQL to create and explore tables with data on your own local database. In this class we'll cover the following:

1. What is SQL?

2. Managing Tables

3. Queries

4. Aggregate Functions

5. Multiple Tables

6. Temporary Tables

Why should I take this class?

Knowing how to work with data is one of the most valuable skills nowadays. That means that learning how to manage and explore data will give you an advantage in this data-filled world that we live in. This course will teach you the things you need to know to start using SQL to manage databases and explore them to get the data you want.

Who is this class for?

This class is meant for absolute beginners; anyone who has no idea what SQL or a database is. It's the perfect place to start learning about data and getting your hands dirty with one of the most popular languages used to access and explore databases. This course is also meant for anyone who's already familiar with SQL but is looking for a structured refresher.

Final Project:

Create your own database and explore the data inside it. Throughout the class, we'll build an example database for a company with three tables: customers, subscriptions, and orders. Feel free to adapt this example to whatever you want!

Follow these steps to complete the class project:

1. On day one, create your project even before starting the first lesson (create and adapt the database as you progress).

2. Go through the lessons and make updates to your project as you go.

3. Once you go through all the lessons, share your final version of your database with a description stating how it's used.

TAKE THIS COURSE