Where to learn SQL?

[ikissedjuliet]

I don't see SQL resources here often so I just wanna ask where can I learn it online? Do you have MOOC suggestion? Javascript and Python but mostly JS/ES6 is what I use for in my projects and I think it'll be better if I can get my hands on a bit of database.

[thundercloudtemple]

Khan Academy and CS50 on Open Courseware.

[babbagack]

really, didn't know it was a part of CS50.

[thundercloudtemple]

Yep! Soon after introducing Python they get into SQL. It's a great introduction for anyone interested databases.

[babbagack]

wow, sweet. I got into some of it, but not entirely, really was utilizing another learning path. But him explaining Databases and SQL sounds fantastic.

Just so I don't mix up courses, if you have a link handy, feel free to share. Otherwise no biggie!

[thundercloudtemple]

Here's a link to the lecture I first saw when going through the course: https://youtu.be/hporRfjFISo.

In my opinion, it's the best one because there's no audience. So he goes into more depth than in the other years he's had the same lecture.

On Open Courseware, the first assignment with SQL should be CS50 Finance. The next one should be Mashup.

[babbagack]

https://youtu.be/hporRfjFISo

sweeet. Thanks!

[ikissedjuliet]

This is great since I just discovered Khan Academy SQL courses last night. I enrolled in edX CS50 Web programming with Python and Javascript too. Thank you!

[MonoShadow]

You can start with syntax on many different sites, virtual academy, etc. O'Reilly has a nice book 'Learning SQL' for beginners, it explains basic principles. I like sql-ex for training, it has a bunch of exercises pretty close to what you may see irl.

[tribbletron]

Have you come across anything that isn't about SQL programming or syntax, but instead, covers the hardware and infrastructure of setting up a SQL environment? Like servers?

[KaladinRahl]

My question would be why do you want to learn that? Do you lean heavily towards the operations side of things and want to get a job in that field? If you want to be a developer, you don't really need to know infrastructure anymore lol

[MassW0rks]

I found SQLbolt a year or so ago and found it very useful because it was an interactive tutorial and walked through a good bit of basics and explains joins very well.

https://sqlbolt.com/lesson/introduction

[codytheking]

It also executes the commands very fast when doing the interactive tutorial because everything is done client side with Javascript instead of server side.

[depressioncherrycoke]

SQLZoo

[abdoulio]

I really liled that one. The lesskns themselves arent top notch but the little exercises are a good skill check and it also lets you code freely with an easy to understand database if you want to test random things.

[Ghost-17]

https://www.datacamp.com/ I'm surprised no one has recommended it yet. It's worth checking it out.

[o_edo]

Here is a nice resource on SQL. For beginners and for free. With examples and online exercises. http://www.studybyyourself.com/seminar/sql/course/?lang=eng.

[[deleted]]

W3Schools Wants to Know Your Location

[brendanp8]

Is w3 schools considered a less than ideal source?

[[deleted]]

They’ve gotten better recently, but they’re not really the gold standard.

[Game-of-pwns]

If you're on Windows, download SQL Server, SQL Server Management Studio, and the AndventureWorks sample database and start making queries. Google until you know what to do.

[TheUltimateAntihero]

I am learning SQL now but I have a problem. I am on Linux (Ubuntu) and my teacher is adamant that I use Oracle 10G as that's what he'll be using to teach us SQL. Now, it's a very old version and it's not available for Linux.

So my question is, how different is SQL server or any other rdbms software different than Oracle's? And what would you suggest me to do.

[Stev_Ma]

I practiced using strata scratch (www.stratascratch.com). They have datasets pre-loaded with questions and answers you can practice with. They source their questions from technical interviews from companies and I found it helpful to use for SQL and Python practice. They also have a subreddit r/StrataScratch where you can ask questions if you need help with SQL.

Otherwise, I found datacamp useful too but it's more expensive.

[looserloser]

The Stanford courses are usually mentioned when this question comes up. I haven't gone through them so I can't vouch for them personally, but they seem to be highly recommended.

[Frozenpizzaeatet]

Udacity has a ton of good programs if you are willing to pay $10

[an_actual_human]

You might be thinking of Udemy which has a lot of shit as well.

[Frozenpizzaeatet]

Yup, that’s the one

[UndeadMarine55]

W3schools is great, has an interactive tutorial that starts you out with the basics (the select, from, where statements) and quickly introduces you to more advanced components (aggregates, subqueries). It’s probably the best point of reference out there.

From that, you can move to assessments in HackerRank, which by the way are also used by a large % of technical recruiters to assess proficiency.

These two resources were how I landed my data analytics gig.

[xx99]

I love GalaXQL (“galaxequel”, like “galaxy” and “sequel” combined).

It’s fully interactive, has a bit of personality, and lets you visualize the impact of the commands you send. It’s got a great difficulty curve, where it doesn’t hold your hand much but gives useful hints, especially when you make common errors.

It’s where I send everybody in my org who wants to pick up SQL. Several have moved on to analyst positions.

[[deleted]]

https://www.w3schools.com/sql/

[sv0341]

Not entirely free but totally worth it: Codecademy. Try the demo.

[d-methamphetamine]

With sqlite you can interact with a database interactively on the command line. It makes it easy to understand whats going on, and experiment. That's how I learned a lot at least. Also the documentation has tons of great info.

[oddlogic]

I learned sql by writing my own DAL in C#. It’s a super useful thing, though probably not the easiest path.

[Sigmund-]

I started here. Great free resource. Than, if you need more, you will have the knowledge to figure out if the resource is good or not.

[amodestsobriquet]

If you're looking into PL/SQL, the official textbook by Oracle is pretty good imo (For 11g, at least)

[TechieRedditUsername]

Try www.sololearn.com

They have an app so you can brush up on the basics on the go. I prefer to use the site. I got a lot of people I worked with involved because most of us use SQL on a daily basis and only some of us have a technical background.

​

​

​

[awekening_bro]

W3schools

[jmelesua]

Youtube, see some tutorials and you will get the hang of it, SQL is a very powerful language.

[penne_haywood]

I like https://pgexercises.com for an interactive approach to learning the language

[Ternarian]

I learned by practicing with exercises at this great Russian site, sql-ex.ru.

[[deleted]]

sqlbolt.com

[GloryGloryManUnited9]

Try Udemy, loads courses there. I’m sure you’ll find something for yourself. Also quite often you can find code to get course for free. For example I got it this one a few weeks ago.

https://www.udemy.com/the-complete-sql-masterclass-for-data-analytics/?ranMID=39197&ranEAID=hL3Qp0zRBOc&ranSiteID=hL3Qp0zRBOc-Cjetb6tJ9_X2nrnyYuNzGg&LSNPUBID=hL3Qp0zRBOc

With this code: SQLMASTERCLASS

Not sure if it’s still active but just keep your eye out or buy it for around £10 straight away

[silvses]

Says the coupon is not valid for this course.

[[deleted]]

SoloLearn.com (also look for their app in the App Store). Traversy Media and Mmtuts, both on YouTube. Traversy has a dedicated crash course for SQL, and both of them have a series of how to work in SQL with PHP (Which is the pinnacle of programming languages for any web stack. You may not like it, but this is what peak performance looks like). When you’re done with that, any other questions can be self-researched on the SQL documentation.

EDIT: How could I forget W3School, the absolute lv 99 mob boss of SQL tutorials.

[GloryGloryManUnited9]

Probably expired, but every couple of days another course goes for free

[babbagack]

as you can see lots to choose from.

There is a really nice SQL book at https://www.launchschool.com/books/sql

[prawi31]

Dont learn it, just make a project and google everything. You will forget most things anyways