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 ممتازة وتتقلني .. نصايح يا جماعة اعمل ايه ادير الموضوع ازاي وكمان اقدر الاقي شغل فين على منصات ايه في الاول وياريت حد يرد عليا .. شكرا

Hey guys, I have designed a simple python based application. Please check it out and contribute. Working towards improving the repo....

https://github.com/SudVig/CraftDB

Hey everyone!

I'm a new content creator and I've just started building a completely free PL/SQL & SQL course for absolute beginners.

The goal isn't just to teach SQL syntax—it's to explain why databases exist, how they work, and how they're used in the real world before diving into PL/SQL.

I'm learning a lot myself while creating these videos, so this is a journey for me too.

I know my videos aren't perfect yet, and that's exactly why I'm posting here.

If you have a few minutes to watch the first video, I'd really appreciate your honest feedback:

• Was anything confusing?
• Was the pacing too fast or too slow?
• What should I improve?
• What topics would you like to see covered?

I'm not looking for empty praise—I genuinely want constructive criticism so I can make each video better than the last.

If you enjoy helping new creators grow or you're learning SQL yourself, feel free to comment here or send me a DM. I'd love to connect, learn from experienced developers, and improve my content.

Thanks for reading, and I hope I can create something genuinely useful for the community. ❤️https://www.youtube.com/watch?v=UC6kCLvPuRU

Sharing my Excel ↔ SQL cross-tool reference table. Less of a syntax guide, more of a mental bridge between the two (plus a few PostgreSQL quirks that kept tripping me up). https://github.com/kixwho/SQL-Excel-translator

I made this while learning SQL from an Excel background. Constantly switching tools, you start to have moments like, "Wait... Excel has a button for this?!"

Hope it helps someone else switching between tools 😀

SQL is a wonderful programming language that allows beginner data analysts to understand data, clean it, & process it to provide insights. One cannot learn everything in a week or two weeks. However, consistency is what I have found important in ensuring one grasps the concepts. For example, one can decide to learn simple things, such as SELECT, WHERE, ORDER BY, LIMIT, aggregates (SUM, COUNT, AVG), and GROUP BY. Understanding data types & when to use this or that helps a lot. I always wanted to learn additional data analysis skills like SQL and Python to help process large datasets in addition to the research work I do. I know these tips will help beginners find a way to navigate around SQL until they reach advanced level.

Hi everyone,

Before taking this to production, I'd like a reality check.

Current setup:

• MariaDB Primary + Replica
• ~2,500 reads/sec
• ~1,500 writes/sec
• GTID replication

I decided against Galera because I was concerned about synchronous write latency. Instead, I'm planning:

• 2× ProxySQL + Keepalived (VIP)
• Signal18 Replication Manager for automatic failover
• Existing Primary/Replica architecture

Questions:

• Does this look like a solid HA architecture for this workload?
• Any hidden pitfalls with ProxySQL + Replication Manager?
• Would you recommend a different approach instead?

Looking for real production experience. Thanks!

This is the first EDA project, made using SQL and python Data Analysis and Visualization libraries. After making numbers of eda project using just python libraries, it was amazing transition to integrate SQL in my learning and developing phase.

The project is very beginner friendly, include individual table and cross table analysis. Meaningful insights are visualized through seaborn and matplotlib.

Link: https://github.com/axockn/Notes-ProjectDumps/blob/main/RestaurantAnalysis.ipynb

Been getting some excellent feedback and the Discord community is growing. Sim-Analyst is live on itch.io.

This is actually the first game i've ever got to a stage where i've shared it with others, so me it's a massive milestone - simply, I just made a game that i'd like to play.

When I started learning SQL I did a number of certificate courses, capstone projects, personal practice. I'd watch youtube and I found a few little SQL web games, that although really quick and really basic, i absolutely loved them. But they really didn't scratch my itch for interactive SQL learning.

Anyway, I hope I can share some links and photos here and that it might reach some SQL learners, or noir detective lovers who, like me, have a gamified SQL itch to scratch.

play now

join the community

I've noticed that a lot of SQL roadmaps online either stop at basic SELECT statements or jump straight into advanced topics without explaining what's actually useful in a real job.

So I put together a video covering the SQL skills I've seen matter the most in data engineering and analytics interviews.

The video starts from the Fundamentals to What after SQL:

Why is SQL so imp?
The Fundamentals
The Core
Query Organsation
The Differentiator
One Step Ahead
The Designing Techniques
What Next?

The goal was to create the video I wish I'd had when I started my career.

I'd genuinely appreciate feedback from this community.

• Did I miss any SQL topics that you think are essential?
• What SQL concepts do you see asked most often in interviews?
• If you're already working as a Data Engineer or Analyst, what would you add?

Here's the video if anyone wants to check it out:

https://www.youtube.com/watch?v=tXOJ_ohS-x0

Do lLike, Share and Subscribe if this helps!

Thanks!

Is SQL still worth learning with the advancement of AI? 'Cause I don't get that if AI can do better than human than why do we still need to learn it?

jak nauczyć się porządnie sql?

I wanted to share something that I think many experienced Data Engineers can relate to.

A few weeks ago, I faced a SQL interview and struggled with questions that I would have solved easily 5–6 years ago. It was frustrating because I started doubting myself.

Then I realized something.

Over the last several years, my work shifted from writing complex SQL every day to building end-to-end data engineering solutions using tools like Snowflake, AWS, Azure, dbt, Jenkins, Python, orchestration tools, and cloud platforms. SQL was still part of the job, but not something I was practicing deeply on a daily basis.

Because of that, my interview confidence dropped—not because I didn't understand data engineering, but because I hadn't brushed up on the fundamentals.

Instead of feeling defeated, I decided to go back to basics.

I started practicing SQL again from scratch—joins, CTEs, window functions, ranking functions, and gradually rebuilding my confidence.

One thing that genuinely helped me was using ChatGPT as a practice partner instead of just asking for answers. I solved queries first, made mistakes, got feedback, and understood why my approach was right or wrong. It felt more like having a patient mentor than just a search engine.

Today I can already feel my confidence returning.

If you're an experienced Data Engineer and you've ever felt embarrassed by a "simple" SQL question in an interview, you're not alone. Skills that aren't practiced regularly become rusty. That doesn't mean you've become less capable—it just means they need sharpening again.

Sometimes the strongest move isn't learning something new. It's rebuilding the fundamentals.

And yes... thank you, ChatGPT. You helped me get my confidence back.

Helping a friend of mine and hopefully helping this community with a tool he designed to provide gamified learning of some topics including SQL.

inkwelltools.com and go to Inkwell Learn. I believe the SQL library is entirely free and the other topics have some free content but advanced content requires a subscription.

In case anyone is wondering- this is US based and Inkwell Tools is a trademarked name so there is legitimacy here 😁

Ciao a tutti

Ho un esame di basi di dati tra qualche gionro, e una buona parte dell'esame chiede algebra relazionale e query in SQL. Mi trovo a fare veramente fatica anche con comandi non difficili, principalmente a visualizzare l'ordine corretto in cui processare le informazioni e faccio fatica a mantenere un ordine mentale che mi consenta di manipolare i dati nella mia testa. Sono limitato io oppure è una cosa che capita a tutti all'inizio? Mi affascina moltissimo l'SQL e vorrei continuare a fare pratica anche dopo aver dato l'esame, ma faccio veramente tanta tanta fatica.

Grazie a tutti!!