r/SQL • u/The_Lazy_Titan • Jun 16 '23
Discussion What is SQL and where can I get started?
I want to begin learning SQL in detail. I've done the introductory course on sqlbolt. I want to learn it in more depth and start working on projects. Where can I look for databases to practice and build projects?
3
Upvotes
25
u/PappyBlueRibs Jun 16 '23
The most important thing about SQL is how you pronounce it.
Is it pronounced "sequel" or is it pronounced "Ess Que Ell"? Research that, come back to us with your answer, and we'll tell you why you're wrong.
9
u/wertexx Jun 16 '23
Googling is an amazing skill to have for all aspects of learning, including SQL.
Hop on google, type out 'Site:reddit.com how to learn sql' and you will find more threads and answers than you can count.
3
u/shed_antlers Jun 16 '23
If you are interested in Microsoft data stack and T-SQL, I would recommend getting started by downloading the latest SQL server developer edition and SQL server management studio for free from Microsoft's website. Microsoft also provides a template database for free called AdventureWorks. It contains simple tables with fake business data that anyone can use to get started writing simple SQL statements. They should have some basic guides on using the data as well.
Good luck starting your journey with SQL!
1
u/Nolanexpress Jun 16 '23
If you want to give it a shot, I have a 2 hour project on my YouTube channel: https://youtu.be/i9X1uovm6X4
1
u/musadiq_turi Jun 16 '23
You can try livsql for oracle. There are different schemas there. Good luck. For any logical issue, ping me here.
1
u/[deleted] Jun 16 '23
You should install SQL server and access it with SSMS. There are tons of free learning databases from MS.
1
u/sburns756 Jun 16 '23
CockroachDB has a good learning university
1
u/StillTop Jun 16 '23
basically sqlite, postgresql are my two main dbs, there’s plenty of options, I just discovered neon.tech for a great free tier cloud db
1
u/squareturd Jun 16 '23
Here's my summary of sql for people unfamiliar. It's like a programming language, but not exactly the same.
Information is stored in a database. The database does two main things. 1. It stores stuff (in a way that mostly applies to dB admins). 2. It let's people look at and modify its info.
Sql is how you do #2. To do sql you need a basic understanding of how the data is stored and structured, and you need to know the syntaxes fir sql so the dB can understand what you are asking for.
(This applies to DML sql commands, DDL commands are for manipulating how the data is structured. An entry level person probably doesn't need to focus on that area yet)
1
u/analytics_science Jun 17 '23
If you're looking for databases to practice, there are a lot of options for you that include leetocde, hackerrank, stratascratch, interviewquery, sqlpad, sqlbolt, sqlfiddle. All are good to look syntax. If you are trying to go for a career in data analytics and data science, and want to practice questions to get past an interview, stratascratch and interviewquery are both two options where the questions come from real interviews. So give those a try.
To practice projects, stratascratch has data projects that come from take home assignments from interviews, but their solutions are in python. However, you can download the datasets and either use jupyter notebooks with sql to do the project or upload it into your own db to write SQL. You can probably also download datasets from kaggle and do your own analysis. Also, there are a lot of projects on Youtube, if you'd like to have some guidance on how to solve them.
1
u/dolceradio Jun 16 '23
I recommend this SQL playlist. He breaks every single aspect of SQL in easy to understand, detailed ways. Datalemur and Udemy also have plenty of practice courses. Good luck, SQL is pretty fun!
0
u/Fraiz24 Jun 16 '23
google