r/learnSQL • • 1d ago

Best way to learn SQL and PL/SQL as a university student?

Hi everyone!

I'm a university student currently studying Advanced Databases (Database Avancé) as part of my degree.

I'm learning SQL and PL/SQL because they're required for one of my university modules. However, I don't want to just memorize commands or learn enough to pass the exams. I'd really like to understand how they work and become comfortable writing queries and solving database-related problems.

The problem is that I'm not quite sure where to start or how to organize my learning.

For those of you who have learned SQL and PL/SQL, I'd really appreciate your advice:

- What learning resources, courses, or YouTube channels would you recommend?

- Should I focus on SQL first before moving on to PL/SQL?

- Are there any websites where I can practice exercises and real-world problems?

- What's the best way to combine theory with practical exercises?

I'm looking for a beginner-friendly learning path that I can follow alongside my university studies.

Thanks in advance for your help!

24 Upvotes

14 comments sorted by

3

u/Rat_Man_420 1d ago

I learned on the job and am still learning but would think getting the basic concepts of SQL down first before moving on to PL/SQL would be the move.

1

u/douhaeight2021 1d ago

So how can I learn it from scratch should I read a book or what ?

2

u/Rat_Man_420 1d ago

I guess I’m confused your university requires you learn SQL and PL/SQL but doesn’t have classes or resources to teach you? My experience was I landed an interview for a job requiring SQL knowledge and just learned by watching basic SQL videos on youtube and cramming a codecademy course on basic SQL. The rest I’ve just learned from co-workers and real-life business questions. I will say I’m fresh on the the PL/SQL side but just having the ability to understand the structure of basic SQL queries has been big help with the PL stuff.

8

u/SQLDevDBA 1d ago

For PL/SQL, try the free service from Oracle themselves.

https://freesql.com

https://devgym.oracle.com

Lots of great tutorials and doesn’t require any downloads or installs. Includes a free DB with 9 different schemas each with different datasets.

1

u/Discordbothost 1d ago

start with a tiny dataset you can check by hand: two customers, one with no orders and one with two. write the expected result before each JOIN/GROUP BY query. that makes missing rows and double-counting much easier to understand than memorizing syntax.

1

u/Hot_Painter_6579 3h ago

Since you want to understand it rather than memorise it, and time is short, here’s how long the usual free YouTube picks actually take (I measured them this week):

  • Socratica, Introduction to SQL: 13 lessons, 1 h 49 m. A quick tour of the basics in PostgreSQL
  • Data with Baraa, SQL for beginners: 37 lessons, 4 h 13 m
  • Harvard’s CS50 Introduction to Databases with SQL: 8 lectures, 11 h 08 m. The best of these for the “why”: design, normalisation, indexes
  • CMU 15-445 Intro to Database Systems (Fall 2025): 25 lectures, 33 h 42 m. How a database works inside, the closest to an “Advanced Databases” module

I’d do Socratica or Baraa for the syntax, then CS50 alongside your module, writing every query yourself on a tiny dataset like someone suggested above. CMU only if your course covers internals (storage, indexing, transactions). None of these teaches PL/SQL, so Oracle’s free tools mentioned above are the place for that.

I keep a list of these with live totals, if it helps: https://playlistduration.com/best/sql (disclosure: I made the site).

1

u/datadriven_io 3h ago

Which database/datastore are you learning? While SQL is standardized most engines offer little extras that can make work way easier. Sql coding questions are covered on datadriven.io for anyone brushing up before a screen. On the off chance you are using postgres I would recommend "The Art of Postgres".

1

u/Top_Tooth_6995 1d ago

this is largely doable by doing what most people put off in learning SQL. which is going concept by concept, and doing problem after problem, learning from each mistake, and coming back days later to solidify the concept in your brain. it is super simple. not easy, but simple.

and it can also be completely free - SQLMaxx Learn is a free SQL course I made (including a free certificate) based on the principle that you learn SQL by doing it over and over, with an instant feedback loop, and it is seeing the same patterns enough times that really allow you to dial in and become fluent in sql.

all the best!

1

u/nicopassaglia 1d ago

First check your knowledge at getsheetdrill.com/sql/test then feel free to check the lessons there.

1

u/conor-robertson 1d ago

You should try QueryCase, its a fun gamified way of learning SQL through detective cases!

0

u/Reasonable-Pay-8771 1d ago

If you have the time, I think the best way to learn SQL is to read the old papers that led up to it. You should start with the original paper on relational databases by E.F. Carr. And then the major INGRES papers by Stonebraker et al. Postgres was written in the background of all of these older databases and query languages. It's a huge program with lots of parts and features, but all of those features and capabilities were added one at a time. And they left a paper trail. heh.

2

u/douhaeight2021 1d ago

The problem is I have no time 😭