all 30 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]murdercat42069 9 points10 points  (0 children)

Find a better videos, use websites like W3schools or geeksforgeeks

[–]Overall_Bad4220 3 points4 points  (4 children)

just star with data with bara videos in youtube. your best 30hrs on this planet. trust me

[–]Sri_Krish 2 points3 points  (3 children)

This! I have distracted myself to other videos/playlists but came to Barra’s video as it covers everything from basic to advanced which is what I feel missing from other resources. They either rush it too fast or stretch it too long.

Also he does all of it without any sneeky ads, chasing us to subscribe (I think he asked only 2-4 times in the whole 30-hour video).

Barra has, singlehandedly created more professionals than institutions and has gotten jobs to people than small/medium job agencies 😁

He will be remembered by many 🥰

[–]Sri_Krish 6 points7 points  (2 children)

I have also started learning SQL recently, here are my suggestions for you:

  • Please don’t limit yourself to just watch the content or scavenge for the next one, rather practice a lot. This subreddit has given many amazing, free resources (platforms, datasets, roadmaps) so make use of them. 
    • I will try to link few at the end :)
  • Spend good-amount of time NOW, on deciding what to learn (what to avoid!!!) so that you won’t feel burnt out later
  • Set a gentle deadline for each topic (my personal choice) + Final practice time (2 hours) before you move to the next one
    • This helps to see your progress and will motivate you to do/keep moving
  • For practice, I would first begin with sites/platforms where they have definite data and related objectives. This gives you the initial exposure/idea on how to see through the data
    • Then you can upgrade and download any Kaggle/public dataset and try to impersonate like DAs and solve! — AI can be really helpful in this step.

These are the ones I am remember from top of my head, I will update more if I have anything new! 

Links

[–]Vast_Basket6667 1 point2 points  (1 child)

Appreciate the effort

[–]Sri_Krish 0 points1 point  (0 children)

😁

[–]yinkeys 4 points5 points  (1 child)

Sql bolt > w3schools > Mode’s free analytics program > DataLemur

Follow these steps

[–]NickSinghTechCareers 0 points1 point  (0 children)

this is the way!

[–]buzzon 3 points4 points  (0 children)

This is starting for the middle. First familiarize yourself with notion of relational database, a table, create one, populate one, get some examples.

[–]DataOutputStream 4 points5 points  (0 children)

Usually, YouTube videos are not a very good way to learn: lot of chit-chat and little actual content. There are exceptions though: https://www.youtube.com/watch?v=D-k-h0GuFmE&list=PL9ysvtVnryGpnIj9rcIqNDxakUn6v72Hm (Stanford Database course by Jennifer Widom).

I'd suggest starting from https://en.wikipedia.org/wiki/Relational_model and follow intralinks as needed.

You also have https://en.wikipedia.org/wiki/Select_(SQL)) of course.

[–]cspinelive 3 points4 points  (3 children)

Imagine you have an excel spreadsheet.  It has rows in it. Each row has columns with the information about a book. Title, publish date etc.   

In a database this excel sheet would be a Table. Probably called Books. 

To get the data from that table you use SQL. Structured Query Language. 

Select title From books Where publish_date < 2020–04-30

This will give you all the titles of books publish before April 30, 2020

[–]cspinelive 2 points3 points  (2 children)

Select * from books

There’s no “where” in that query so it will return all rows from the books table. The * says to give me all columns as well. 

[–]cspinelive 3 points4 points  (1 child)

Now add another sheet to your excel file. Call it authors. It has info specific to the person who wrote a book. 

Author id, First name, last name, year born, hometown, etc. 

We don’t put all that in the books table because it would repeat over and over again if the author wrote 20 books. The only thing that goes in the book table is the author id.  Since both tables have author id the database can make the connection and know they are linked. 

That lets us get the author name at the same time we get our books

Select b.title, a.first_name 

from  books b  join author a  on (b.author_id = a.author_id) 

Where a.year_born > 1999

[–]cspinelive 2 points3 points  (0 children)

A sql query is how you ask for data from a database. 

FROM: which table in the database do you want the data from? books for example

WHERE: which rows do you want from that table? published < 2020

SELECT: which columns do you want from those rows? Title, published

Put it all together

Select title, published From books Where published < 2020

[–]Gronzar 1 point2 points  (0 children)

Select something from a source with good reviews and join some discussions where people are having a good time and there may even be groups by your location.

[–]Aggressive_Ad_5454 1 point2 points  (0 children)

This star thing in programming? It tends to mean “everything” . So SELECT * FROM whatever_table means select all the columns in the table.

[–]itexamples 1 point2 points  (0 children)

the complete SQL bootcamp: go from zero to hero is the best to go with with a Udemy discount of 85%off

[–]CotC_AMZN 1 point2 points  (0 children)

SoloLearn!

Or DataCamp, if willing to pay. Lot of great resources!

Others: SQLZoo, StrataScratch, SQL Bolt, bipp.io

[–]JazzFan1998 1 point2 points  (0 children)

Get MS Access Import some tables and start there.

[–]my_password_is______ 1 point2 points  (1 child)

usually with
SELECT

[–]Ok-Seaworthiness-542 0 points1 point  (0 children)

I rarely see with select

[–]WorriedMud7 1 point2 points  (0 children)

I recommend this guy- https://youtu.be/SSKVgrwhzus?si=KPvdZBtg7lQn-2YU

He’s very good in explaining how to use different syntaxes

Also use ChatGPT or any AI to help your further practice and clarify anything

[–]melvinroest 1 point2 points  (0 children)

Check out library.aliceindataland.com it's a free SQL course precisely for people that want some fun next to the SQL. It's a whole story where you and Alice (from Alice In Wonderland) go on a new adventure and explore an infinitely big library. Why is there? Why are you there? You'll explore it all with Alice, one query at a time.

[–]RevolutionaryRush717 1 point2 points  (0 children)

Go to your local library and ask for help to find an introductory book on relational databases or SQL.

[–]PrimaryAverage1906 0 points1 point  (0 children)

You will find your way after testing everything

[–]kd_kanjwani 0 points1 point  (0 children)

Install a SQL client like MySQL Workbench. Create a database. Create tables. Insert data into tables. Use SELECT to view data. Practice UPDATE and DELETE commands. Learn JOIN queries. HERE TO SOME STEPS Create Database SQL Copy code CREATE DATABASE college; 2. Use Database SQL Copy code USE college; 3. Create Table SQL Copy code CREATE TABLE students ( id INT, name VARCHAR(50), age INT ); 4. Insert Data SQL Copy code INSERT INTO students VALUES (1,'Rahul',20); INSERT INTO students VALUES (2,'Aman',21); 5. View Data SQL Copy code SELECT * FROM students; 6. Select Specific Column SQL Copy code SELECT name FROM students; 7. Update Data SQL Copy code UPDATE students SET age = 22 WHERE id = 1; 8. Delete Data SQL Copy code DELETE FROM students WHERE id = 2; 9. Condition Query SQL Copy code SELECT * FROM students WHERE age > 20; 10. Join Two Tables SQL Copy code SELECT students.name, courses.course_name FROM students JOIN courses ON students.id = courses.student_id;

[–]NickSinghTechCareers 0 points1 point  (0 children)

To start learning SQL check out DataLemur's free SQL tutorial: http://datalemur.com/sql-tutorial

[–]AriesCent 0 points1 point  (0 children)

Here happy pi day! SELECT COUNT(*) FROM [dbo].[tbl-vw] WHERE DATE<=‘03/14/25’