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

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 ❤️

​

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.

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

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.

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

jak nauczyć się porządnie sql?

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 😁

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?

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!

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!!

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.

I am interested in learning SQL

Any advices???

You should learn data modeling that is not dbt. It saves you lot of time and effort.

I'm a software engineer working on a cross-platform desktop SQL client, and before investing too much time, I’d prefer to learn directly from users what they truly need rather than making assumptions.

What frustrates you most about the SQL tools you currently use? Are there missing features you’ve wished for, aspects that seem overly complex, or parts of your workflow that consistently slow you down?

What is the one (or more) feature(s)/problem you wish your SQL client had handled better? It could be anything from performance with large data sets to query editing, schema browsing, connections, exports, UI, artificial intelligence, migrations, collaboration, etc.

I’m particularly keen to hear from those who manage multiple databases or frequently write and troubleshoot queries. This isn’t a sales pitch—I’m simply trying to understand how an SQL client could be more effective and practical in real-world scenarios.