Full SQL Crash Course - Learn SQL in 90 Minutes

Full SQL Crash Course - Learn SQL in 90 Minutes

NeuralNine

1 год назад

27,776 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@gustavojuantorena
@gustavojuantorena - 31.03.2024 21:27

Awesome!

Ответить
@BakaNeko15
@BakaNeko15 - 31.03.2024 22:04

😭i have CS exam in school tomorrow, and SQL is part of the syllabus, what a coincident

Ответить
@dipeshsamrawat7957
@dipeshsamrawat7957 - 31.03.2024 22:52

Good work. Keep it up💯

Ответить
@mdbayazid6837
@mdbayazid6837 - 01.04.2024 02:19

NoSQL also please

Ответить
@ebere3061
@ebere3061 - 01.04.2024 04:35

Right in time for my databases exam🤩

Ответить
@ashraf_isb
@ashraf_isb - 01.04.2024 04:44

Thanks for this, good timing hehe 😀

Ответить
@hellobro1461
@hellobro1461 - 01.04.2024 05:50

❤❤❤❤ brother please make a voice ordering food app NLP with sqlite Or other database.

Auto add data to database with notes.

I which we separate items, number, note.

Than all calculations. ❤❤❤❤❤❤❤

Please give me some idea

Ответить
@MarcusAlexander-vk7mw
@MarcusAlexander-vk7mw - 01.04.2024 09:51

love it bro. came at the perfect time

Ответить
@wildniscamper7276
@wildniscamper7276 - 02.04.2024 04:30

awesome. spot on. the way you explain even complex stuff in a easy way, shows that you undersand it exactly. loce it!

Ответить
@mugomuiruri2313
@mugomuiruri2313 - 02.04.2024 08:59

yo ! good teaching

Ответить
@panchtatra
@panchtatra - 02.04.2024 11:07

People are still using this?
I am relieved.

My skills are not all outdated. 😅
I have to find an exam to use it though.

Ответить
@ajaxmaxxer
@ajaxmaxxer - 02.04.2024 21:31

Bro this came perfectly in time for my exams ! Thank you.

Ответить
@HelmutQ
@HelmutQ - 17.05.2024 14:39

Defintly to0 fast for starting one's first program after having watched it. But definitely something which gives you an idea what you can do with SQL and convince you to spend a lot more than 90 minutes to study it. One of the most underrated languages. Enjoyed the show (off)

Ответить
@seijumimurasakibara5516
@seijumimurasakibara5516 - 21.05.2024 17:26

thank you very much for this! helps me refresh my memory for interviews. Bookmarked and subscribed!

Ответить
@mozammelhossain1419
@mozammelhossain1419 - 24.05.2024 14:25

Just awesome bro. So compact, and so clear explanations, and so understandable.

Ответить
@felixliles9389
@felixliles9389 - 08.06.2024 06:11

Nice one

Ответить
@nabinpokhrel6129
@nabinpokhrel6129 - 18.06.2024 08:11

Chat gpt prompt to generate sample data:
Create table people
(p_id integer primary key auto_increment,
p_name Varchar(255),
p_age Integer,
p_height FLOAT,
p_gender ENUM ('male','female')
);
Create table things(
t_id int Primary Key auto_increment,
t_name varchar (255) Not Null,
t_desc Varchar (255),
foreign key (t_owner) references people (p_id)
);
create table ownership (
o_owner int,
o_thing Int,
Primary Key (o_owner, o_thing),
FOREIGN KEY (O_OWNER) references PEOPLE (P_ID),
FOREIGN KEY (O_THING) references THINGS (T_ID)
);
can you give me some sample data to insert into the above table?
Please also give me person who owns multiple things as well as person who does not own anything.Can you also give me things that are not owned by anyone?

Ответить
@ChristopherBruns-o7o
@ChristopherBruns-o7o - 29.06.2024 19:27

I would have broke it up into two parts one being read focus and the second for write

Ответить
@PawelCzerwinski123
@PawelCzerwinski123 - 30.09.2024 22:51

Note that i have very little experience with SQL so please correct me if I'm wrong

The last example with UNION and UNION ALL. Isn't it that UNION ALL is way faster than UNION (for large datasets extraction of duplicates should be very expensive)?

If so shouldn't we write this query as:

SELECT p_name, t_name FROM people LEFT JOIN things ON p_id = t_owner
UNION ALL
SELECT null, t_name FROM things WHERE t_owner = null;
?

Ответить
@crashmaster26
@crashmaster26 - 07.10.2024 14:44

THE ONLY CORRECT WAY TO PRONOUNCE IT IS SEEQUIL ... if you say the individual letters, it makes you sound like a noob. People will litterally refuse to listen to your video if you say S Q L instead of SEEQUIL.

Ответить
@sandeepkulkarni3508
@sandeepkulkarni3508 - 17.01.2025 15:19

I haven't used SQL in last 15 years. I have an interview next week for a management position. This is a complete refresher course for a beginner or a person like me who wants to brush up on his SQL knowledge bits. Excellent. Thank you.

Ответить
@FelipeFigueiredo-d7p
@FelipeFigueiredo-d7p - 17.03.2025 00:00

Thank you a lot :)

Ответить
@kirtanbhavsar889
@kirtanbhavsar889 - 31.03.2025 22:44

Thank you buddy, helped a lot to get the basics clear for the further implementation : ).

Ответить
@Kegan__
@Kegan__ - 01.05.2025 17:37

I came here through your FastAPI → SQLAlchemy → SQL(this video) videos, lol.

Ответить
@diamondsandlipgloss
@diamondsandlipgloss - 05.05.2025 18:32

I prefer compiled videos so thank you sir😊

Ответить