1:22 - PART ONE: CREATE, SELECT, INSERT 25:10 - PART TWO: UPDATE, DELETE, ALTER 34:29 - PART THREE: Constraints 46:10 - PART FOUR: Advanced SQL Queries 58:03 - PART FIVE: Joins & Relationships 1:22:46 - PART SIX: UNION, INTERSECT, EXCEPT

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

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

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

Thanks for this, good timing hehe 😀

love it bro. came at the perfect time

Right in time for my databases exam🤩

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

Good work. Keep it up💯

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

@ashraf_isb

3 ай бұрын

All the best btw

@BakaNeko15

3 ай бұрын

@@ashraf_isb:p thanks

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)

Awesome!

yo ! good teaching

Nice one

NoSQL also please

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

❤❤❤❤ 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

People are still using this? I am relieved. My skills are not all outdated. 😅 I have to find an exam to use it though.

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?