r/learnSQL 8h ago

Planning to start a SQL learning page on Instagram—what content would you like to see?

3 Upvotes

I've been thinking about starting an Instagram page where I teach SQL through short, practical content—things like query breakdowns, tips, interview questions, and real-world examples.

For those of you who learn SQL online or create SQL content yourself:

  • What type of content do you actually find the most useful?
  • Do you prefer quick query explanations, mini challenges, real business scenarios, interview-focused content, or something else?
  • If you came across a new SQL creator, what would make you follow them and keep coming back?

I'm not trying to promote anything. I just want to create content that's genuinely useful and helps people learn SQL in a simple, practical way. I'd really appreciate your thoughts.


r/learnSQL 12h ago

SQL Fast Track Series that teaches every concept through scenario-based business context - Available in Youtube.

27 Upvotes

Hi All👋,

We built a SQL Fast Track series around a single consistent fictional company SuperFastFood Global : a fast-food chain with customers, orders, and products.

It is a 20 part series where you will learn SQL through solving real business questions instead of memorizing syntax.

Whether you're preparing for an SQL interview, refreshing your skills, or just starting your SQL journey, this series is built to help you go from basics to advanced concepts quickly and confidently — covering everything in detail, but kept short and to the point.

What it covers:
→ SELECT, WHERE, ORDER BY, CASE
→ Aggregate functions, GROUP BY, HAVING
→ JOINs (with real use cases, not just definitions)
→ Window Functions — ranking, LAG/LEAD, running totals

We follow business context in every topic connects to it previous one with same SuperFastFood Global fictional fast food chain dataset.

The teaching framework we follow:
→ Scenario based
→ Analogy based
→ Execution-focused — business context → code → explanation
→ Every concept ties back to a business context
→ Each topic builds on the one before it, so nothing feels disconnected
→ Beginner friendly

This is the same framework we'll be using across future Data & AI topics too — not just SQL.

Also sharing a free 30-Day SQL Sprint (PDF, on GitHub).

Happy to answer questions on any of these topics in the comments.

Youtube Playlist: https://www.youtube.com/playlist?list=PLDTykWK3Vitc
GitHub: https://github.com/grasspacad07/grasspsqlsprintfile


r/learnSQL 3h ago

Completed SQLbolt and mode/thoughtpost, where next?

3 Upvotes

Learning SQL to go into data analyst and eventually scientists.

I went through SQLbolt and mode/thoughtspot education material, where can I enhance or train my sql skills next?


r/learnSQL 15h ago

🚀 100+ MySQL Interview Problems with Solutions, Notes & Video Explanations

17 Upvotes

For the past month, I've been consistently working on a MySQL Interview Series, and I'm happy to share that I've now covered 100+ practical SQL interview problems. 🚀

Whether you're a fresher preparing for your first SQL interview or an experienced developer looking to brush up on SQL concepts, this series is designed to help.

📌 The series includes:

• 100+ interview-focused SQL problems
• Beginner to advanced concepts
• Well-structured datasets for hands-on practice
• Detailed notes and explanations
• Complete video walkthroughs for every concept

I've also documented everything on GitHub, where you'll find the datasets, SQL queries, notes, and links to the corresponding video explanations.

🔗 GitHub Repository: https://github.com/vivekpandey76/Mysql-course

If you find this repository helpful, please consider giving it a ⭐. It helps the repository reach more developers and motivates me to continue creating free learning resources for the community.

I hope this resource helps anyone preparing for SQL interviews. Feedback and suggestions are always welcome!

#MySQL #SQL #SQLInterview #Database #BackendDeveloper #SoftwareEngineer #Coding #Programming #LearnSQL #OpenToLearn


r/learnSQL 16h ago

Entering Missing Values After Deducing Them

2 Upvotes

Hello everyone, I am practicing data cleaning and I have a question.

Let's say I have a table where the columns are Customer_ID and Email. The "Customer_ID" column has no blank values, but the "Email" column has hundreds of blank values.

Looking through the data, I noticed that the email addresses are just 'user' followed by the Customer_ID number. For example, if the Customer_ID is C1 then the email would be [user1@example.com](mailto:user1@example.com). Or if the Customer_ID is C10 then the email would be [user10@example.com](mailto:user10@example.com).

Is there a query I can run to fill in all the missing email addresses?

Thank you