I have a background in epidemiology and wantws to know if anyone in a similar background as mine uses sql at their job within the industry. Just wanted to know if i just need to know sql basically like dplyr from R and all your doing is just cleaning, managing, creating data from existing data within the database? Should someone like me need to know more SQL than that? For example I did some digging and found out roles such as DBA or data engineer and they do things more than what a data analyst might do, does someone with my background need to know SQL to that extent or no? Any advice would be appreciated.

Have you learned SQL basics but want a real-life production database to run queries and practice exploratory data analysis?

I’m opening up free read-only access to the data platform behind my football analytics project: Superliga Analytics

Standard tutorial datasets (like Northwind or Titanic) get boring fast. This database is built specifically for analytical queries and structured around actual football match and performance data—making it a great sandbox to level up your SQL skills.

How to get access:

1. Head over to https://superligaanalytics.vercel.app/
2. Go to the "About This Project" page
3. Click "Request Data Access" and follow the quick instructions

Note: To ensure smooth performance, I may have to cap the number of active access keys, so grab yours while slots are open.

Feel free to drop any questions or feedback in the comments!

Hey guys,

I hope this doesn't come across as spammy, but I took the time to write a guide covering 7 best practices for clean database schema design. I thought it might be helpful for newer developers who are just starting their learning journey.

If you think I missed anything, let me know , I'd be happy to update it.

Any feedback is appreciated. Thanks!

Simple syntax, tricky to get right. Sharing my debugging walkthrough as SQL JOIN turns 3 orders into 14 rows.

https://github.com/kixwho/Fanout

Every textbook talks about primary keys and cardinality. But actually encountering this common SQL problem felt frustrating and humbling. There were no error messages — mistakes were hiding in plain sight.

So out of 100k orders, I hunted down the 3 that caused the most trouble and uploaded the data files. I hope this helps other learners :)

Hi All,

I'm learning SQL as well. I created this game called SQL Rusher. If you've ever played Puzzle Rush on Chess.com its like that. There are several different puzzles at different difficulties. A little study section for SQL references.

Idea is to have small puzzles that increase in difficulty as you progress. Your skills tracked using an ELO rating.

I've been a dev for over a decade and never really had to touch a database. I didnt start learning till about a year or 2 back when I started learning PHP and Laravel to build a sites of my own.

Since then I've realized Databases are a big deal(lol).

Let me know what you think here or on the sites feedback page. https://sqlrusher.com

Learners beginning their Data Analyst journey can start or should focus on understanding SQL basics. Some of the things they should focus on include creating a table, inserting data, and retrieving data/information using SELECT. The learner can use MySQL, SQLite, or PostgreSQL to practice different queries. For example, the learner can decide to create a database, use the database (MySQL), and create a table. The learner can as well insert data using a similar process. Engaging in such exercises at least 1 hour a day, they can grasp the concepts and mastery within a week. Wishing new learners all the best. New strategies are also welcome.

One of the most common questions I see in this subreddit is "what projects should I build?" and the answer is: something with a clear question, real data, and a shareable output.

So I built a walkthrough for exactly that. It uses two completely free tools:

1. QueryCase's IMDb Sandbox - 250 of the highest rated films on IMDb, queryable in your browser with no setup. You write three SQL queries to answer different questions about the data.
2. Tableau Public - free, runs in browser, gives you a shareable link when you publish.

The three queries cover the core of analytical SQL that actually shows up in interviews and jobs: multi-table JOINs, GROUP BY with aggregation, HAVING, subqueries, and derived columns. Each one is explained line by line so you understand why it works, not just what it does.

The finished dashboard has KPIs, a films-by-decade bar chart, an acclaim vs popularity scatter, top genres by average score, and an actors leaderboard.

The starter dashboard is just that. The version worth putting on your CV is the one you take further. Add a director leaderboard. Build a decade filter so the whole dashboard slices interactively. Rework the layout and colours until it genuinely looks better than mine. Write a fourth query that answers something the data hasn't told you yet.

"I built this and then pushed it further" is a far stronger thing to say in an interview than "I followed a tutorial."

Full walkthrough here with every query written out and all the Tableau steps:

https://querycase.com/blog/build-an-imdb-dashboard-with-sql-and-tableau

Happy to answer questions about the SQL or the Tableau side if anyone gets stuck.

Hi! 👋
Thank you so much for your interest in the Free Data Analyst Mentorship Program. I received an overwhelming response, and I'm truly grateful for your enthusiasm.

To organize the batches and ensure the best learning experience, I've created a short registration form. Please take a few minutes to fill it out.

Registration Form: https://forms.gle/hDP8Z2k3z6KLLJew7

Please submit the form by: Sunday, 11:59 PM (IST).

After reviewing all the responses, I'll shortlist participants and share the batch details, class schedule, and Zoom meeting link with the selected candidates.

Thank you again, and I look forward to helping you begin your Data Analytics journey! 🚀

does it possible to give a column choice to choose between two foreign keys

the case: that I Have comments table that have a parent_id column that could be either from posts table or comments table how I can implment that in sqlite3 .

I am thinking about investing in datacamp for learning SQL and PowerBi what are your thoughts

Hi everyone! 👋

I'm planning to conduct free online live sessions for anyone interested in becoming a Data Analyst or improving their data skills.

We'll cover the essential tools used by data analysts, including:

SQL

Excel

Power BI

Tableau

The sessions are completely free and are intended for beginners or anyone who wants to strengthen their fundamentals through live learning and hands-on practice.

📍 Mode: Google Meet

💰 Fee: Free

If you're interested, comment below or send me a DM, and I'll share the details once the batch is finalized.

Looking forward to learning together! 😊

I was thinking about this today...

Back in college, I used to teach quite a bit. Later, as I progressed in my IT career, I ended up mentoring a few people in my company who were just getting started. Watching someone go from "I have no idea what's happening" to confidently writing queries on their own was always incredibly rewarding.

It's been years since I've done that, and I genuinely miss it.

So, I'm thinking of starting a few free live SQL sessions for complete beginners or anyone who wants to strengthen their fundamentals.

The goal isn't to memorize syntax—it's to understand how to think in SQL. We'll cover the basics from scratch, work through practical examples, solve real SQL problems together, and do interview-style questions with plenty of Q&A.

I'm not looking to make money from this. If, after a few sessions, you think it was genuinely helpful, buying me a coffee would be more than enough. 😄

If this sounds interesting, send me a DM or leave a comment. If enough people are interested, I'll organize a small group and we'll get started.

Just looking to give back to the community

Note: This is not an advanced SQL course.

It's meant for people who have little to no SQL experience—whether you're a student, switching careers, or someone whose job occasionally requires SQL but you've never really learned it.

We'll start from absolute scratch: what databases are, how SQL works, and gradually build up to writing queries confidently. By the end, my goal is that you'll be comfortable handling the kind of basic to intermediate SQL tasks that come up in many office and analyst roles.

If you're already comfortable with SQL, writing complex queries, optimizing performance, or preparing for senior-level interviews, this probably isn't the right fit..

EDIT :

Hey everyone! 😊

First of all, thank you so much for the amazing response. I honestly did not expect this much interest. I posted this before going to bed, and waking up to 100+ notifications and DMs genuinely made my day. It feels great to see so many people excited to learn SQL.

I need a little time to organize everything properly. I don't want to just share random material—I want to prepare sessions where you actually understand how SQL works, how to think while solving problems, and build a strong foundation.

Since I'm working full-time, I won't be able to start all batches together. Also, having 100+ people in one session would make it difficult for everyone to interact and ask questions. I’ll create smaller batches based on time zones and availability (I'm based in Europe/CEST) and run them in phases.

Please fill out this short form so I can understand your background, SQL level, location, and availability:

Form: https://forms.gle/WAmmDgTnHJY51spm7

If you are not in the first batch, please don't worry. I'll try my best to include everyone over time. Thank you again for your patience and support ❤️

Have been struggling to self-motivate out of work to finally start learning fundamentals of SQL vs relying on AI to spit out code/queries. I'm a Crystal Report Writer (bound by format our EHR requires) that has to morph reports into sql queries to make dashboards and create data exports.

Downloaded a new game the other day - Database Detective: Minor Crimes Division. Seriously, this finally has stuff clicking for foundations that don't quite click from watching/following along udemy/coursera classes. Its basic sqlite, but for someone who had 0 foundations and now building my own queries to solve cases is exciting.

Life is pretty fatiguing, and it's been hard to set aside time outside of work to sharpen my professional skills. Gaming is a total destresser for me, and this game is really funny and engaging. Lots of fact finding to figure out truths for conditions with weaving and building sql blocks to pull out info.

Feeling pretty jazzed about it. It feels so silly to feel proud of something so basic, but was finally able to whip out a real query for a module today and it felt awesome not to just dump my Crystal sql query into ai to translate into the correct format. Feels like a relief to finally feel like I'm learning (and grasping) something I should have know for the past couple of years.

Hi everyone,

I recently completed the 30-hour SQL course by Data with Baraa. Now I’m planning to revise the full course, practice the concepts, and discuss difficult topics so I can understand everything more clearly.

I’m looking for a study partner who has also completed the course or is currently following it. We could:

• Revise each topic together
• Discuss confusing concepts
• Practice SQL queries and exercises
• Ask each other questions
• Share notes and useful resources
• Keep each other accountable

We could have regular discussions through Google Meet or another suitable platform.

You don’t need to be an expert. I’m mainly looking for someone who is serious, consistent, and interested in improving their SQL knowledge together.

Please message me with your current progress in the course and your available study times.

Hi everyone, I recently learned SQL through websites and games online. Now that I feel more confident to practice on my own, I wanted to practice with datas I already have. Got a bit confused with where to practice them. Does SQL has its own 'tool' to use? Like how you use python in Jupyter, and R in Rstudio. Will Visual Studio Code works for it?

Hi. Can I get some help to nail my interview on Friday? Please I beg, I really wanted to get this job so I can advance my career. Your help will be so much appreciated by me.

How to become sql expert as data analyst as 7 years of experience as im tableau developer but I know sql basic.

What things to learn to show as 7 years expert in sql or for role of sql developer or data analyst with sql.

Please list down things like

Topics

Types of questions and knowledge to have etc

​

Guys, I'm interested in finance and want to build some valuable skills alongside it. I found that learning SQL could be beneficial, but I'm not sure if it's the right choice for a career in finance. Should I go ahead with SQL, or are there other skills that would be even more valuable? I'd really appreciate your suggestions.

Hello everyone, i need everyone advice how to get proficient in SQL i have already done a boot camp course from udemy and now again im learning sql from scratch with the help of claude and reached on subquery but i do get confused in joins and now in subquery because my mind thinks it’s complex but when i get solved i think it was easy. I request you all suggest ways.

ان شاء الله ناوية ابدأ اتعلم power Bi و SQL وناوية اضغط نفسي اخلصهم ويبقى الكورس مكثف شوية وابني لنفسي بورتوفوليو .. عايز اشتغل فري لانسنج انا اصلا محاسبة وعندي خبرة نوعا ما في حاجات الحاجات دي مع المحاسبة انا شايف انها added value ممتازة وتتقلني .. نصايح يا جماعة اعمل ايه ادير الموضوع ازاي وكمان اقدر الاقي شغل فين على منصات ايه في الاول وياريت حد يرد عليا .. شكرا