Free Beginner SQL Course w/ ALL Links & Videos⚡️

We'll learn all the SQL basics here in 31 lessons!

Got BDE?⚡️

Hi BDEs! ⚡️ Welcome to the free Big SQL Energy Beginner Course⚡️

I’ve compiled all 31 lessons of the course below. This page serves as the course HOMEPAGE. Each beginner lesson below contains written material that introduces the concept, provides relevant links (such as datasets, data dictionaries, data models, etc.), and corresponding YouTube videos as well! So be sure to take advantage of BOTH forms of content 😍

The beginner course is perfect for complete newbies because it starts at step 1, however it’s only the tip of the iceberg when it comes to SQL. It likely will not be enough to land a job in data, but it is the perfect preparation for my intermediate course which is much more business problem and job focused. You can even preview 4 lessons for free below:

---

If you’re new here:

💁🏽‍♀️ Who Am I?

I’m Jess Ramos, the founder of Big Data Energy and the creator of the BEST SQL course and community: Big SQL Energy⚡️. Check me out on socials: 🔗LinkedIn, 🔗Instagram, 🔗YouTube, and 🔗TikTok. And of course subscribe to my 🔗newsletter here for all my upcoming lessons and updates— all for free!

⚡️ What is Big SQL Energy?

🔗Big SQL Energy Intermediate is an intermediate SQL course designed to solve real-world business problems hands-on using realistic data and a modern tech stack. You’ll walk away with 2 SQL portfolio projects, portfolio building guidance, access to the Big Data Energy Discord community, and lots of confidence for you upcoming coding interviews! You also get access to all monthly events including masterclasses, office hours, and guest speakers. This course is all of the most important things I’ve learned on the job as a Senior Data Analyst in tech who grew from a $72K salary to over a $150K salary. And now I’m sharing it with YOU! It’s more than just another course— it’s a challenging program designed to upskill your SQL to the intermediate level, get ready to ace your live coding interviews, and build connections in the data community through the Discord and events.

---

⚡️ Big SQL Energy Beginner Course:

* Note: Please take all lessons in order because they build on each other!

• Lesson 0 & 1: 🔗Intro, Setup, select * from

• Lesson 2: 🔗 Order By

• Lesson 3: 🔗 Primary vs. Foreign Keys & Distinct

• Lesson 4: 🔗 Limit & Top

• Lesson 5: 🔗 Data Types & Cast

• Lesson 6: 🔗 String Manipulation

• Lesson 7: 🔗 Arithmetic Operators

• Lesson 8: 🔗 Filtering w/ Where

• Lesson 9: 🔗 Boolean Logical Operators

• Lesson 10: 🔗 Between & Not Between

• Lesson 11: 🔗 IN & NOT IN

• Lesson 12: 🔗 Is Null, If Null, & Is Not Null

• Lesson 13: 🔗 Wildcards

• Lesson 14: 🔗 Like vs. ILike & Wildcard Variations

• Lesson 15: 🔗 Aggregate Functions

• Lesson 16: 🔗 Count(*) vs. Count(column)

• Lesson 17: 🔗 Current Date & Time

• Lesson 18: 🔗 Basic Date Functions

• Lesson 19: 🔗 DateDiff()

• Lesson 20: 🔗 Date_Add()

• Lesson 21: 🔗 Date_Trunc()

• Lesson 22: 🔗 Group By & Aggregate Functions

• Lesson 23: 🔗 Having (vs. Group By)

• Lesson 24: 🔗 Coalesce & IfNull()

• Lesson 25: 🔗 Case & Categorizing Data

• Lesson 26: 🔗 Data Dictionaries

• Lesson 27: 🔗 Data Models & Fact vs. Dimension Tables

• Lesson 28: 🔗 Inner Joins

• Lesson 29: 🔗 Case Study: Calculate a Percent in SQL

• Lesson 30: 🔗 Case Study: Visualizing Data

• Lesson 31: 🔗 Next Steps & Finding Data to Practice

Once you finish all the lessons, post about your experience on social media and TAG ME 🔥 I’d love to hear from you! Be sure to check out 🔗Big SQL Energy Intermediate when you’re done with Beginner and ready to REALLY level up and get serious about your job search.

DM me or email me at courses@bdeanalytics.com if you have questions on the intermediate course!

-xoxo,

Jess Ramos 💕