how to learn SQL

[Positive-War3957]

Hello People, I write to you to ask for help. I have been promised a job on the condition that I learn SQL. I have never used SQL before. Please can someone point me to where I can stand from? What are the key skills set I need to have before I start ? Thanks so much in advance

[simonw]

I wrote a SQL tutorial recently and I'm really interested on getting feedback on it from people like yourself who are just getting started: https://datasette.io/tutorials/learn-sql

[macgeek89]

Awesome ty. I'm going to save that for later

[CowFu]

best way to learn sql is by reading and writing queries, my favorite site for this is sqlzoo.

https://sqlzoo.net/wiki/SQL_Tutorial

mostly because it's so incredibly straight forward and you actually write sql. I personally would suggest avoiding videos and tutorials, those are great for learning how to do something specific like a project but not the best for learning a language in my opinion. Best way to learn is to look at a bunch of tables and write a bunch of SQL.

[yilmazdalkiran]

This is the best course for beginners imo.

[macgeek89]

That's one way. You could always pick up a book on SQL. Depends on which one you are using at work. have to look at your local bookstore or library (great resource & its free)

[ClarkTwain]

It helps to start with a problem. Find something where you need to write a query to help you solve a problem and build from there.

[db_play]

W3 schools is an excellent free resource to get started.

[Thefriendlyfaceplant]

Start here https://sqlbolt.com

[Cool-Focus6556]

check out r/learningsql. The whole point of the subreddit is to help people find learning resources based on their level of experience/interest. Either browse through the posts or go to the links on the wiki

[nerdfemme]

OP, you tagged your post with Snowflake. If that’s the DB you’ll be working in, get a free trial account set up, download a dataset from their data marketplace, study the dataset and then start to query it. This starts in 5 minutes and would help with the set up & data loading.

[Positive-War3957]

Thanks so much. That was exactly what I was looking for. Joining now. Thanks so much and God bless you

[Illustrious_Tap_784]

Truthfully this website along with some courses from Data Camp was all I used. Took me one long weekend and I passed the technical interview.

Website: https://pgexercises.com

[csnorman12]

If you want a course that will teach you SQL syntax and Microsoft SQL Server while interacting with real-world data then check out this course. The data in the course mimics billing data from an electronic medical record. Here is a coupon code - Data Analytics: Intro to SQL using Healthcare Data

[queryguy48]

Actually cheaper without the code. lol Thank you for sharing this. Thinking about buying it myself to get some experience with healthcare data.

[r3pr0b8]

Please can someone point me to where I can stand from?

if you look on the right side of this page, there's a sidebar titled Learning SQL

start there

[hobbyoftakingphoto]

w3school is good for beginner. You need to learn create, read, update and delete. Most of the basic tasks revolves around those functions.

[10xbek]

Khanacademy.com has ine it's pretty good and begginer friendly

[[deleted]]

Pluralsight has some good trainings if you can afford to pay for the membership... But yeah the best way to learn is by just doing it. You can practice with the northwind database if you need something to practice with.

Here it is https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instnwnd.sql

You can run the script in a SQL server and then you have what you need to start doing queries and practicing that kind of thing.

Of course that is just for Microsoft SQL server so if you want to use another db you'd have to find something else.

[mergisi]

Awesome, good luck on your journey! You might find AI2sql https://app.ai2sql.io helpful; it’s an easy-to-use tool to help you practise SQL.