DAY 2 | SELECT & WHERE | 30 Day SQL Challenge | #sql #dataanalysis #dataanalytics #dataengineering

Description:
???? Practice SQL for 30 Days with Stephen.

In Day 2, we cover how to pull data from a table and filter it down to exactly what you need — using SELECT and WHERE.

This includes
- Writing your first SELECT statement
- Choosing specific columns vs SELECT * - Using WHERE to filter rows
- Comparison operators: equals, not equals, less than, greater than, and more
- Combining conditions with AND, OR and NOT


…and more!

Check out the full GitHub repository here:
https://github.com/sdw-online/30-Day-SQL-Challenge

This contains the
- exercises for each day
- datasets used (for each exercise)
- SQL scripts to follow along

Follow along at your own pace - feel free to drop any questions or feedback you have in the comments below.

---

???? Join my data communities:

1. Free community

https://data100x.carrd.co/

1. Private community (invite only)
- https://data100.carrd.co/

---

Become a data analyst using

- Analyst Builder - https://www.analystbuilder.com/?via=stephen-david-williams

(Note - I earn a commission when you purchase any qualifying items via these links.

This does **not** cost you anything, but helps in creating more content!)

---

???? Socials:

- TikTok - https://www.tiktok.com/@sdw.online
- Instagram - https://instagram.com/sdw.online
- LinkedIn - https://www.linkedin.com/in/stephen-david-williams-860428123/
- Facebook - https://www.facebook.com/profile.php?id=61563980937900
- GitHub - https://github.com/sdw-online
- Twitter/X - https://twitter.com/sdw_online

---

???? Free Resources:

- Tableau Visual Vocabulary - https://www.tableau.com/en-gb/solutions/gallery/visual-vocabulary

Here are some of the free resources I've created that you may find useful for your own data projects:

- My articles/ blogs - https://medium.com/@sdw-online
- How I broke into data - https://datapro.carrd.co/

---

???? Installation links:

Download these resources mentioned in the project:

- PostgreSQL - https://www.postgresql.org/download/
- pgAdmin - https://www.pgadmin.org/download/

---

???? Music used:

Morning Routine by Ghostrifter Official | https://soundcloud.com/ghostrifter-official
Music promoted by https://www.chosic.com/free-music/all/
Creative Commons CC BY-SA 3.0
https://creativecommons.org/licenses/by-sa/3.0

---

⏲️ Timestamps:

0:00 - Intro
0:XX - Your First SELECT Statement
0:XX - Selecting Specific Columns
0:XX - Formatting Your Queries
0:XX - WHERE — Filtering Rows
0:XX - Comparison Operators
0:XX - AND, OR & NOT
0:XX - Recap