From ‣
Table of Contents
👋 Welcome to the Course
This course I wish I would have had before I started in Data Analytics
- SQL is one of the easiest tools to learn, and feel you can master the basics by the end of this
SQL is the top required skill of Data Analysts, Data Engineers, and also Data Scientists (actually #2)
Top Skills & Pay of Data Nerds
If this is your first language to learn, you’re in the right place
What is SQL?
SQL stands for Structured Query Language
It’s the language used to connect with a database, which is where companies store all their data
My Experience
Used this in all Data Analyst roles I’ve been a part of
- From Corporate America to MrBeast
🤔 What we’ll be covering?
Get you set up running SQL on your computer along with a final project to show your skills
🕵️♀️ Who is this for?
- Beginners to SQL
- No coding Experience
- No analytics Experience
1️⃣ Basics Section
- What is SQL? a database?
- All the basics of SQL queries
- Common Keywords
- Simple Analysis
- Joins
- Start practicing writing SQL queries
2️⃣ Advanced Section
- Advanced techniques in SQL
- Creating your database
- More complex Analysis
- Subqueries & CTEs
- Learn to run SQL on your machine
3️⃣ Project Build
- Build a real-world project to showcase your skills
- Explore data science job postings to extract insights
🙌 Support the Course
This course is completely free 🆓
You’ll get all these resources to complete the course:
📺 Step-by-step video instructions
📲 Platform to run SQL queries
🎤 Best practices for using SQL
💽 Resources to setup SQL on your computer
📂 Guided project to showcase
For those who want to support more future tutorials like this, contributing affords the following:
🔢 Additional Practice Problems
🗂️ Access to all SQL Queries
📝 Step-by-step Notes & Cheatsheet
🌠 Certificate of Completion
How this course was built?
🤙 Kelly Adams - The brains behind the course
Kelly Adams is the co-creator of the course
- She’s the brains behind the lesson plan and exercises
Feel free to connect with Kelly here:
You can also check out her other work on her website:
Data Analyst | Kelly Adams | Sacramento, CA
All this wouldn’t have been possible without the help of Kelly Adams 🙌
What is SQL?
💽 What is SQL?
Structured Query Language (SQL) is the standard database management language
- Pronunciation: Can be spoken as S-Q-L or Sequel
- Utility: Essential for accessing and managing data in relational databases
- Versatility: Used in various sectors for data analysis, database management, and more
💽 What is a database?
A database is a collection of data
- Structure: Allows for efficient data storage, retrieval, and management
- Types of Databases: Includes relational databases (organized in tables) and non-relational databases (for unstructured data)
📝 What is a query?
A query is a request for data from a database, allowing you to perform various operations:
- Operations: Includes creating, reading, updating, and deleting data (CRUD)
- Examples:
- Creating Data: Add new records using
CREATE& INSERT INTO
- Reading Data: Retrieve data with
SELECT
- Updating Data: Modify existing records using
UPDATE
- Deleting Data: Remove records with
DELETE
🏢 Where are databases stored?
- Local Computer: Ideal for personal or small-scale applications and development
- Server Storage: Suitable for larger, enterprise-level applications with remote access needs
🐘 What are the different types of databases?
Popular Database Options
- Relational Databases (course focus): Store data in tables with predefined schemas. Examples include MySQL, PostgreSQL, and SQLite
- Non-Relational Databases: Designed for unstructured data, offering more flexibility. Examples include MongoDB, Cassandra, and Redis
Stack Overflow Developer Survey 2023
Relational Database
- Characteristics: Data stored in rows and columns, ideal for structured data.
- Use Cases: Widely used in traditional applications for complex queries and transactions.
👋 Intro to Course
Basics
Comparisons
Practice Problem 1