Here is the discord link: https://discord.gg/ugEyQQXe4

Kicked off my 116-day journey today with the database track.

What I did:

• Went through a beginner-friendly MySQL tutorial covering the basics
• Took detailed notes instead of just passively watching
• Went back and revised everything at the end of the day to actually retain it

Nothing groundbreaking yet — Day 1 is really about building the habit of consistent, focused learning rather than covering a lot of ground. Planning to move into SELECT/WHERE and filtering queries next.

Will keep posting updates as I go — open to any tips on solidifying SQL fundamentals early on.

Sometime back, someone mentioned that we only post SQL-related information concerning learning, projects, or developments. I think it is good to post such content because it allows or encourages others to continue learning. Through the information provided from different sources, one can gauge themselves, including testing the new information. I have had challenges with project development, but with new information each day, I understand how to deal with them. I consider SQL, like any other programming language, something that requires daily learning & practice.

I am thinking of creating a multiplayer game website online where 2 players can play sql games with each other like sql queries and table or multiple choice question and a timer on it . What are you guys view on it? #sql

I'm looking to learn SQL. I'm familiar with the fundamentals. I want to reinforce then and move on to learning intermediate and advanced level SQL. Can you please recommend a website/ platform and course/ pathway. There are thousands of online web-sites and resources..it's kind of overwhelming. I'm looking for a platform that offers lessons and hands-on practice. It can be a paid site. Could you please provide recommendations? Appreciate your help.

Hey everyone,

I'm in the final year of my BCA, and starting today I'm committing to 116 days (Sept 7 – Dec 31) of focused, practical learning instead of just studying for exams. Posting here for accountability and to connect with others doing the same.

Roadmap — 3 tracks, done in sequence, each building on the last:

• T1 – Database (SQL): fundamentals through advanced queries, ending with a schema design project
• T2 – Backend (Java): core Java through Spring Boot, building a REST API on top of the T1 database
• T3 – Frontend (HTML/CSS/JS): fundamentals through a full UI that connects to the Java backend

Method for each track: tutorials first → practice problems → a project that applies it. By the end I should have one complete full-stack project built from scratch.

I'll post weekly recaps here, and daily bite-sized updates on X/Instagram if anyone wants to follow along there too. Open to feedback on the roadmap or resource recommendations — thanks for reading!

i'm an android software engineer with quite a good experience but i just use framework/libraries APIs. now i'm interested in databases especially SQLlight because that's what we use in android. can you give me good resources (beginner friendly) to learn SQL databases and relational databases well and maybe some resources as extra for some deeper learning.

Passed the course, write joins comfortably, pull whatever anyone asks for. Then I was asked to design the tables for a small internal tool and produced something that fell apart the moment there were two of anything. Querying and designing turn out to be unrelated skills and only one of them was taught. Have looked at Boot.dev and DataCamp and they seem to teach opposite halves of this. how did you learn the design half.

Hi everyone,
I’m a complete beginner and want to learn SQL from scratch and eventually become really good at it.
I’m looking for some guidance on how I should approach learning it step-by-step.

A few things I’d like to know:

1. Where should I start as a complete beginner?
   
2. What topics/skills should I learn first and in what order?
   
3. Which courses, YouTube channels, books, or certifications would you recommend?
   
4. Are there any courses that are actually worth paying for?
   
5. What practical projects should I do while learning?
   
6. Roughly how long would it take to become job-ready/proficient?

I’d really appreciate a roadmap from someone who has already learned this from scratch.

Thanks!

I just published Lesson 10 of my SQL course, focused on CTEs (Common Table Expressions) in PostgreSQL.

In this lesson, I explain how the WITH clause can help turn complicated nested queries into cleaner, more readable SQL.

We cover:

- What CTEs are

- How the WITH clause works

- CTEs with GROUP BY and aggregate functions

- Using CTEs with JOIN

- Multiple CTEs

- CTEs vs. subqueries

- Common mistakes

- Practical exercises using the Pagila database

I tried to keep it beginner-friendly and focused on actually writing queries rather than just explaining the theory.

YouTube: https://youtu.be/Koka7IGgPM4?si=132b-FlrYXd9ePyC

Would love to hear any feedback on the explanation or examples!

Hi everyone,

I’m currently learning/practicing Python, SQL, and PySpark, mainly with a data engineering goal.

I’m looking for a platform where I can regularly solve problems and improve my hands-on skills, especially:

1. Python — syntax, problem solving, data manipulation

2. SQL — queries, joins, CTEs, window functions, etc.

3. PySpark — DataFrames, transformations, aggregations, joins, optimization, etc.

I know platforms like LeetCode, HackerRank, DataCamp, etc., but I’m looking for something that provides good practical exercises, preferably with datasets/projects rather than only algorithmic problems.

What platforms/websites do you recommend for this?

Also, if you’re a data engineer, I’d appreciate knowing how you personally practice these three skills.

Thanks!

Hi! I’m currently working as a Data Analyst, but my role mainly involves using Excel. I’m not very interested in continuing with Excel-based work, and I really want to transition into a career as an SQL Developer.

I’m looking for remote or freelance opportunities that I can pursue alongside my current job while learning and gaining practical experience in SQL.

Could anyone suggest a good learning path, remote job opportunities, or a mentor who can guide me through this transition?

  DROP TABLE IF EXISTS  #x
  SELECT 111 id, '1,3,5' PU_list INTO #x

  SELECT * FROM #x

   id   PU_list        --< current 1 row
  111   1,3,5


   id  PU              --< wanted output, create row for each value in List CSV
  111   1 
  111   3
  111   5

Hi all,
Is it possible to create SQL Server code to produce output like posted above, I need to create separate row for each value in PU_List separated by comma.

Thanks all
VA

I am unsure where to begin with SQL from the Beginner's Edition. Several individuals have suggested to follow Data with Baraa, which appears to offer a similar course on YouTube and Udemy, with a certification. Could you advise me on which course to choose, a free or a paid one?

I honestly don't know anything about SQL right now. I want to start learning it properly, so can you guys suggest how I should begin and what resources I should use? My plan is to learn SQL for data first and then move towards AI and ML. I don't even know if SQL is different depending on whether you are working in data, AI, or ML, so I'm a little confused about that too. If you could suggest some good resources, a proper way to learn it, and what I should focus on if I want to become really good at SQL, I would really appreciate it. Thankkk youuuu

I am a Ruby on Rails developer. I’m looking for some skills that can help me self code review for sql part. I use Claude. Like that can guide me not to write sql that are anti patterns etc

I’ve been revisiting SQL Server PIVOT for reporting scenarios where row-based data needs to be transformed into columns.

A few things I find useful about PIVOT:

• Cleaner reporting output
• Easy aggregation across categories
• Useful for summary-style queries
• Can be more readable than complex conditional aggregation in some cases

I’ve also added the working SQL examples here:

GitHub:
https://github.com/laxmikant-geek/sql-server-examples/tree/main/pivot

And I wrote a more detailed explanation here for anyone who wants the walkthrough:

https://geeksarray.com/blog/how-to-pivot-data-in-sql-server

For those working regularly with SQL Server — do you prefer PIVOT, or do you usually use SUM(CASE WHEN...) for these kinds of transformations?

I know basics but I want to self study. Any tips of good sources that are really effective in teaching and learning?

I recently put together a practical SQL guide after realizing something:

📖 Full article:
https://medium.com/the-code-frontier/sql-keywords-every-developer-should-know-well-beginner-to-advanced-4d705d6c7538?sharedUserId=darvexatechnologies

Most developers learn SELECT, INSERT, UPDATE, and DELETE pretty quickly… but production SQL gets a lot more interesting after that.

Things like:

• INNER JOIN vs LEFT JOIN
• CAST / CONVERT
• DATEADD / DATEDIFF
• GROUP BY / HAVING
• SET NOCOUNT ON
• SET ANSI_NULLS
• Transactions and ROLLBACK
• SCOPE_IDENTITY()
• NOLOCK, ROWLOCK, READPAST
• @@ROWCOUNT, @@ERROR, @@SPID
• EXECUTE AS OWNER
• EXISTS vs IN
• TRY...CATCH

I tried to explain these from a real-world developer perspective, rather than giving textbook definitions — including where they can actually be useful and where you should be careful.

The guide is organized from beginner concepts through more advanced SQL Server features, with examples using a simple Employees and Orders dataset.

📖 Full article:
https://medium.com/the-code-frontier/sql-keywords-every-developer-should-know-well-beginner-to-advanced-4d705d6c7538?sharedUserId=darvexatechnologies

I'm curious:

What SQL keyword, function, or feature do you think developers commonly misunderstand or misuse?

For me, NOLOCK would probably be high on that list. 😄

Would love to hear what you've seen in real production code.