SQL for Beginners - A Data Analyst Path

Focused View

Tony Alamo

1:14:24

123 View

1. Introduction

1. Day 1 - What is SQL.mp4

02:24

2. Day 2 - Install SQLite (Mac & Windows).mp4

02:19

3.1 sql supporting material.txt

3. Day 2 - Create a Table.mp4

07:33

4. Day 3 - Managing Tables.mp4

09:41

2. Selecting Data From Databases

1. Day 4 - Select, Order, and Filter.mp4

05:09

2. Day 5 - Wildcards and NULL Filter.mp4

04:29

3. Day 6 - Between, And, and Or.mp4

04:52

4. Day 7 - Limit and Case Statements.mp4

04:32

5. Day 8 - Aggregate Functions.mp4

04:53

6. Day 9 - Aggregate Functions With Grouping.mp4

04:08

3. Work With Multiple Tables

1. Day 10 - Inner Join Tables.mp4

10:19

2. Day 11 - Left Join Tables.mp4

03:47

3. Day 12 - Cross Join Tables.mp4

05:02

4. Day 13 - Temporary Tables.mp4

04:06

5. Day 14 - Conclusion.mp4

01:10

Description

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

What You'll 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 is this for?

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.

What You Need to Know?

Just a computer. No programming experience needed, you'll learn everything you need to know.

More details

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:
What is SQL?
Managing Tables
Queries
Aggregate Functions
Multiple Tables
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:
On day one, create your project even before starting the first lesson (create and adapt the database as you progress).
Go through the lessons and make updates to your project as you go.
Once you go through all the lessons, share your final version of your database with a description stating how it's used.
Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

Hey, there! My name is Tony.After graduating as an engineer in Boston I jumped straight into Data Analytics - starting at a startup accelerator in Cambridge, MA where we worked to start web companies from scratch and launch them out to the world. We did exciting work building projects from scratch and immediately saw their impact on the company’s bottom line.Even though this was super exciting work, I eventually decided to turn my focus to what I'm genuinely passionate about - learning how to learn and teaching others how to do the same. Learning is a skill like any other and there are strategies we adopt to make the best use of our energy and time.The brain is like a muscle we never learned how to train, and learning is one of the best brain exercises there are. Throughout my lessons, my goal is to share practical skills with you at the same time that I teach you powerful learning strategies. I hope you find my Udemy courses and YouTube videos helpful and that you join me on my journey to wake up and live a more meaningful life in the present moment, one brain exercise at a time.I'll see you around!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.