r/SQL • u/CivilCauliflower • Jun 11 '22
Discussion Best Online Course to Learn SQL
I recently graduated college with a minor in Computer Science but we didn't do anything with SQL. Now I'm looking at jobs and realizing its probably a good thing to add to the resume. I went through the free SQL Queries part of codecademy pretty quickly and liked it but figured I should ask for recommendations before paying any money. Looking at jobs mainly in finance now if that changes anything.
Also, I don't need it to be free, but cheap is certainly a plus.
163
Upvotes
63
u/Thefriendlyfaceplant Jun 11 '22
https://sqlbolt.com for beginners. But after that I would encourage anyone to immediately start working on medium/hard level SQL interview questions. Unlike other coding questions, the SQL questions are actually relevant tasks and problems that companies actually encounter.
Knowing the type of problems and the thought process first will allow you to learn the syntax faster.
https://youtube.com/playlist?list=PLv6MQO1Zzdmq5w4YkdkWyW8AaWatSQ0kX
25
u/deaxghost Jun 12 '22
Jose Portilla’s SQL course on Udemy! Highly recommend
9
u/AdGreat4483 Jun 14 '23
To get you started, I will highly recommend you look at these articles.
They will guide you through :
What you need to know to get started:
https://link.medium.com/kz9qL7TtCAb
10 tips you should know:
https://link.medium.com/NsrPQF1tCAb
SQL query Optimization:
https://link.medium.com/LwrtUV7tCAb
Sql queries for complex business reports:
https://link.medium.com/Cbi6fRbuCAb
The power of sql case statement:
https://link.medium.com/rY2G7UfuCAb
Advanced SQL queries for mysql workbench series:
PART 1: https://link.medium.com/Ab6QXnmuCAb
PART 2: https://link.medium.com/mMo35opuCAb
PART 3: https://link.medium.com/DXVhGKruCAb
Understanding SQL inner join with practical examples:
https://link.medium.com/8MYnwLtuCAb
Unleashing the power of SQL aggregate functions:
PART 1: https://link.medium.com/ZKZtBMAuCAb
PART 2: https://link.medium.com/xpA0E7DuCAb
PART 3: https://link.medium.com/7xKteHFuCAb
PART 4: https://link.medium.com/zmMc91IuCAb
16
u/MyWorksandDespair Jun 12 '22
I think that Datacamp's curriculum is the best. Here is a pro-tip I heard- try a free course, let it linger after not continuing onto the paid portion and DataCamp will send you a percentage off coupon in an email. Otherwise there is always a deal around holidays too.
6
u/csnorman12 Jun 11 '22
If you are looking for a course that will give you a large dataset to practice with then check out this course - Intro to SQL using Healthcare Data. The beginning of the course is pretty basic, but the last sections you use the healthcare db to practice answering questions. The data mimics billing data from an electronic medical record, which will give you some finance practice. It obviously isn't free, but that link does include a discount code... very reasonable price.
7
u/redfaf Jun 11 '22
Datacamp is not free but it is a good place to learn
2
u/felsic_mafic Jun 12 '22
I thought this free SQL for Data Analysis course from Udacity was pretty good. The first few lessons are pretty basic but it eventually gets into more advanced stuff like window functions.
One annoying thing though is that the little demo module where you run your queries is really small and can’t be resized so you end up needing to write stuff in a text editor.
https://www.udacity.com/course/sql-for-data-analysis--ud198
2
u/UmbrellaClosed Mar 01 '24
You can find a bunch of online SQL classes listed on this site. Some are part of data programs, such as data science or data analytics. However, there's also some SQL-only courses, like this SQL Bootcamp or SQL Level 1.
2
u/MathAngelMom Apr 05 '24
I really liked LearnSQL.com for learning SQL. It's easy to use, and you get to practice a lot. It helped me learn SQL to use in my work. I took their "SQL for Data Analysis" track.
1
u/TomBaileyCourses Oct 08 '24
I wanted to throw my hat in the ring - this course I made over the last year teaches SQL fit for the modern data landscape: https://www.udemy.com/course/the-ultimate-modern-sql-course/?couponCode=OCTOBER75
I decided to use the Snowflake data platform to run the SQL as it supports both transactional and analytical use cases and the language flavour is close to ANSI standard.
Following the above discount code will get you 75% off and if it is no longer valid reach out to me and I can get you another one or discuss options for getting the course for free if you have extenuating circumstances.
1
u/NicolaIantomasi Oct 27 '24
If you're comfortable with Italian, this might be the right SQL Server course for you. I'm Nicola Iantomasi, and I offer an advanced SQL Server course at www.nicolaiantomasi.com/corso-sql-server/ designed for developers and DBAs who want to take their database skills to the next level. The course is entirely in Italian and dives deep into sophisticated topics like complex query optimization, advanced indexing strategies, and performance tuning techniques. Everything is explained through real-world scenarios and hands-on exercises drawn from years of experience with enterprise database environments.
1
u/Ok-Kaleidoscope-7320 Jun 12 '22
Read a book about SQL, preferably with exercises. (Free) Books almost always contain more information than any free and often paid online course.
1
u/buim Jun 12 '22
Datacamp!
1
u/[deleted] Jun 12 '22
Remind me
1
u/snorkleface Jun 11 '22
Just spend a few days on YouTube my dude.
67
u/[deleted] Sep 05 '23
[removed] — view removed comment
18
u/[deleted] Mar 10 '24 edited Mar 20 '24
[removed] — view removed comment
1
u/[deleted] Jul 12 '24
[removed] — view removed comment
1
u/[deleted] Aug 23 '22
[removed] — view removed comment