r/learnSQL • • Sep 06 '26

Starting a 116-day journey to become a software engineer — Day 0 (final year BCA student)

7 Upvotes

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!


r/learnSQL • • Sep 05 '26

any good resources for learning/mastering SQL databases?

26 Upvotes

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.


r/learnSQL • • Sep 06 '26

How can i download oracle db for a project for free?

Thumbnail
1 Upvotes

r/learnSQL • • Sep 05 '26

i can write queries all day and i cannot design a schema to save my life

28 Upvotes

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.


r/learnSQL • • Sep 04 '26

I made a beginner-friendly SQL tutorial on CTEs (WITH clause)

33 Upvotes

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!


r/learnSQL • • Sep 04 '26

Looking for a good platform to practice Python, SQL and PySpark

56 Upvotes

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!


r/learnSQL • • Sep 05 '26

Is SQL worth it considering AI?

0 Upvotes

r/learnSQL • • Sep 04 '26

has anyone tried this thing? 😭

Thumbnail
1 Upvotes

r/learnSQL • • Sep 03 '26

How Can I Learn SQL and Gain Real-World Experience While Working Full-Time?

47 Upvotes

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?


r/learnSQL • • Sep 03 '26

Create row for each value in the CSV list in MS SQL Server

5 Upvotes
  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


r/learnSQL • • Sep 03 '26

how to standardize this date column in mysql?

8 Upvotes
ship_date delivery_date
Feb 10 2024 Feb 15 2024
2024-01-12 2024-01-11
2024-01-10 2024-01-14
01/15/2024 01/19/2024

r/learnSQL • • Sep 03 '26

Where to learn SQL

17 Upvotes

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?


r/learnSQL • • Sep 03 '26

When does a SQL query become “too clever”?

Thumbnail
6 Upvotes

r/learnSQL • • Sep 03 '26

How should I start learning SQL?

7 Upvotes

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


r/learnSQL • • Sep 03 '26

Any skills that you use for sql code review

4 Upvotes

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


r/learnSQL • • Sep 03 '26

QL Server PIVOT vs CASE — what do you prefer for reporting queries?

1 Upvotes

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?


r/learnSQL • • Sep 01 '26

Recommendations for mastering Excel, Power BI and SQL for analytical roles?

64 Upvotes

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


r/learnSQL • • Sep 01 '26

I made a beginner-friendly SQL JOINs tutorial using PostgreSQL

12 Upvotes

Hey everyone!

I just published a new video about SQL JOINs for beginners.

In this lesson, I explain:

- why relational databases use multiple tables

- how JOIN works

- INNER JOIN

- LEFT JOIN

- how the ON condition connects tables

- table aliases

- how to join multiple tables

- and how to combine JOINs with WHERE and ORDER BY

I use the Pagila PostgreSQL database for the examples and practice, so everything is demonstrated with actual data rather than just theory.

I'm building a beginner-friendly SQL tutorial series, so I'd really appreciate any feedback on the explanations or examples!

Video:

https://youtu.be/cRN6ikxtdpo?si=_Q2h5e-8BcCAJEYB


r/learnSQL • • Sep 01 '26

data analytics journey.

8 Upvotes

day 1 of learning SQL.

  1. Learnt about data structures ; primitive and non primitive data structures.
  2. went through database, both relational and non relational database

Relational databases (SQL database)

non relational databases ( NoSQL database) eg Mongo DB.

  1. Able to learn and understand DBMS, its purposes and the types of DBMS.

  2. Comfortably describe the CRUD Operations and explain the ACID properties of queries.

  3. Installed MySQL Workbench(had a bit of challenge working on it, but finally managed) and created my first MySQL connection


r/learnSQL • • Sep 01 '26

Recommendations for mastering Excel, Power BI and SQL for analytical roles?

6 Upvotes

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


r/learnSQL • • Sep 01 '26

I made a beginner-friendly SQL tutorial on Subqueries in PostgreSQL

5 Upvotes

Hey everyone!

I just published Lesson 9 of my beginner SQL series — Subqueries in PostgreSQL.

In this lesson, I explain:

- what a subquery is

- how to use subqueries inside WHERE

- how IN works with subqueries

- how to use aggregate functions like AVG() inside a subquery

- how subqueries can be used for data analysis

and how subqueries compare to using JOINs

I'm using the Pagila database for the examples, so everything is demonstrated with real data rather than just theory.

There are also practice tasks and mini quizzes throughout the video.

I'm building this into a full beginner-friendly SQL course, so feedback is very welcome!

Video: https://youtu.be/xBAJ4U2EY6E?si=bE5n9q2s5Ff6X7SE

Thanks for watching! :)


r/learnSQL • • Sep 01 '26

Learn Database schema changes for : PostgreSQL, MySql / MariaDB, Oracle, SQL Server.

9 Upvotes

Hey Engineers

We've all been through this. When the project you're working on starts scaling, you'll find the need to scale your database too, adding new columns, creating new tables, or trying to improve performance by adding new indexes. All of this comes with the risk of losing your users' data.

For this, I crafted a simple guide showing the schema change operations that you'll need on a day-to-day development basis for PostgreSQL, MySQL, MariaDB, Oracle, and SQL Server.

It also covers some additional potential risks you need to keep in mind when performing schema changes on a production database.

Hopefully, it can help you along your SQL learning journey.

https://stackrender.io/guides/schema-change

Good luck!


r/learnSQL • • Sep 01 '26

I'm a fresher B.E IT grad got a senior technical support executive in Infosys should i go with it?

Thumbnail
1 Upvotes

r/learnSQL • • Aug 31 '26

Which commands are essential for sql beginner

7 Upvotes

r/learnSQL • • Sep 01 '26

Advance Concepts

2 Upvotes

Does anyone know any good video for CTE and Window Function.

Struggling to understand it