Learn SQL In 60 Minutes

cool

hi, what editor did you use in this tutorial?

I like your explanation, please make some tutorial on Javascript, I struggled a lot in learning Javascript

Attending a course to get a certificate for MS SQL but I wanted to be prepared beforehand and this video was great! Thank you!

Best video about sql I've ever watched ❤

It would be great if you share with users, learners how to practice it, and install sql etc.

Watched this video three years ago and returning now as I have to reminisce. Great teaching and perfectly simple. I tried to re-visit the DSC book which in all fairness contains alot of great information but is extremely heavy and the material is made overly complex. So thanks alot for this. This is high quality.

Thank you for this. I'm refreshed with this tutorial!

SQL is god of data querying. Even when you have no-sql or non-relational databases, sooner or later you can be sure there will be SQL interface for that :D

Great

The Ocean <3

hello ji

OK another shout out thank you for explaining the JOIN, not one instructor I've had explained it as well, not even JOIN and INNER JOIN are doing the same thing. 🙌

Well explained and so happy your English is good LOL. I wouldn't say it's simple learning this but you're helping! Thanks

Top tier band choices

hello

you have huge ears. thanks for the guide gr8 for begginer

good day kyle, i was wondering if you could a video of using node to connect to an sql database. you know the schema and stuff

thank you...

good project

I just love this tutorial, thanks a lot!!!

kindly post a video about "How to Fine tune Chat GPT for our specific needs" tutorial from scratch.

amazing, thanks.

I think that in case of aggregates like count, you can select only on count and count all occurrences without grouping.

Please add video about. indexing and views too
thanks

very awesome. thank you

Still up at 2023 thank you

Nice explanation! Thank you.

Thank you! We need one for Python please.

well done great explaination

How do you when to underline a word? And what is the meaning of the underline sign? Thanks.

Thank you for the SQL video! It was incredibly informative. 😊🙏🎥💻

I like you so much. you are so handsome and smart! Aftering knowing you, my programming skill improves tremendously!

I found this incredibly useful to refresh what I had learnt earlier. Would recommend to anyone

Made this for myself but may help some of you.

CREATE – Make something new;

DROP – Delete something (risky);

ALTER – Change something that has already been created;

ADD – Add something to something;

USE – Specify what Database you are using;

NOT – Something should not be a specific value / Only select things that don’t have this value;

AUTO_INCREMENT – Automatically increases a specific value making it different in each column;

PRIMARY KEY – Lets you uniquely identify each row in a table, used with AUTO INCREMENT;

FOREIGN KEY – Allows us to add a foreign key;

REFERENCES – Allows us to reference something;

INSERT INTO – Allows us to insert something into a table (Adding something new not modifying it);

VALUES – Thing to be inserted (INSERT INTO table_name (columns) VALUES (‘Your value’) );

SELECT – Lets you select something (* selects everything);

FROM – Lets you specify from where you want to select it (FROM table);

LIMIT – Lets us limit how much something should be (With select for example);

UPDATE – Lets us update something that has already been created;

SET – Lets us change something that has already been set;

AS – Lets us change column names (SELECT column_name FROM table_name AS ‘new name’);

ORDER BY – Lets you specify by what order things should be displayed by.

ASC – The default order of things (Ascending);

DESC – Used with order by. Makes them order by descending order;

DISTINCT – Only selects unique values (SELECT DISTINCT name FROM table);

WHERE – Add a condition to your statement (SELECT * FROM table WHERE column = 22);

LIKE – If contains something (SELECT * FROM table WHERE column_name LIKE ‘%dea%’)

% Means as many characters as possible before and or after it. LIKE ‘%dea%’ would be true for death;

AND – Basically just && (SELECT * FROM table WHERE column > 22 AND column2 < 33);

BETWEEN – (SELECT * FROM table WHERE column BETWEEN 666 AND 999);

IS NULL – You can’t say = NULL (SELECT * FROM table WHERE release_year IS NULL);

DELETE – Allows you to delete something (DELETE * FROM table WHERE id = 22) (deletes a row);

JOIN ON – (SELECT * FROM table1 JOIN table2 ON table1.column1 = table2.column2);

Select everything where (compare table 1 and table 2 with this condition: ….) THE () ARE RUN FIRST

this helped me pass my exam, so thank you my guy .

I know this has nothing to do with the video, but sir, your eyebrows are incredible

Thought of covering SQL concepts for a very long time, but couldn't able to complete any course. But this is a good booster. Thank you so much for all the efforts you put into to make all these.

kyle you are amazing, thank you so much

ampogi mo nakakadistract bhii

I'm getting this error after I try to add in the Primary Key (ID) portion Error Code 1050 Table bands already exists

This is really good. I just feel like this would be a lot better if you added the code in a document for our reference. I get error messages and have nothing to compare my code to, to find the problem. I have to depend on what i can physically see in the video. It's still pretty good, but i'm stuck right now for that reason. I can't get past the 'populating tables' part, because i keep getting a messages saying there's something wrong with the foreign key - band_id. I had to resolve to just watch the video and not follow along.

Thank you for this content. It was really helpful!🙂

thank you, mate

Thanks, dear, for making such an informative and helpful video. It briefly covers the SQL basics, which can be used as a refresher. Well done!!!!