SQL for Beginners - A Data Analyst Path

Manage databases and explore data like a pro with the most popular programming language to do so.

Ratings: 4.00 / 5.00




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.

What You Will Learn!

  • Learn how to turn data into insightful, real-world solutions.
  • Learn to program in SQL from scratch, the most popular programming language used to manage and explore databases.
  • Create your own databases and fill them with data to later explore using SQL queries.
  • Learn how to use SQL to create and explore tables with data on your own local database.
  • Manage tables, run queries, apply aggregate functions, work with multiple tables, and temporary tables.
  • Gain one valuable skill nowadays: to know how to work with data.

Who Should Attend!

  • If you're completely new to SQL programming and are curious about data science.
  • You're looking to learn how databases work and how they are managed.
  • You find big data intriguing and want to learn more about ways to explore data.
  • You're curious about jobs in data analytics down the line and is looking for an excellent first step.
  • You want to stretch your brain by learning something new.