Click the "JOIN" button below the video to support freeCodeCamp.org!
@himanshukeshtwal46584 жыл бұрын
how can we decide to select no of column in a table as a primary key? as i saw in few table we select 2 primary key and in other we select only 1 column as a primary key.
@Elemy9214 жыл бұрын
himanshu keshtwal depends how you’d like to use the column for , it’s just pure logic
@kethankoz69104 жыл бұрын
is there a 2020 one for this???
@himanshukeshtwal46584 жыл бұрын
@@kethankoz6910 yes
@HarshitSingh-it7kp4 жыл бұрын
@@himanshukeshtwal4658 where there are more than 1 primary keys clubed together it is k/a:composite key.
@afrozalam256 Жыл бұрын
For me It all started from this 4 hour video. This youtube video changed my life. I had no clue what SQL or what database was. I used to be an accountant and today I work as a database developer. Thank you so much. To all those people who are trying to change their careers, you can do it!
@robertachternaam4493 Жыл бұрын
how long did it took you to become database developer after accountant? THankyou
@quadir6076 Жыл бұрын
I have a question about the Mac installation /login, i feel like this might be a little outdated and especially w most people like me having the newer M1/M2 MacBooks so when I installed it , it didn’t give me any temp password or user and it was already active when I clicked on it so idk if now it just doesn’t need one to start but I’m confused on that part, anyone have same issue?
@mukhammed_kaldybai Жыл бұрын
@@quadir6076I didn't understand where you have issues in registration on terminal or what? I have a MacBook and it works on m1 and op sistem is MacOs it works perfectly if you do it just like in the video Idk
@quadir6076 Жыл бұрын
@@mukhammed_kaldybai I got it , i followed the instructions exactly step by step from the vid but it’s a little outdated and the whole download process was a little different, like for example it didn’t give me a temp password I had to go into the settings and make one then go back to the terminal and follow the code steps from the vid
@najim8157 Жыл бұрын
But isn't there something missing from the course ? Such as : Procedures and Functions not the already defined ones like creating a one of your own
@amalpb18115 жыл бұрын
(0:00) Introduction (2:36) What is a Database? (23:10) Tables & Keys (43:31) SQL Basics (52:26) MySQL Windows Installation (1:01:59) MySQL Mac Installation (1:15:49) Creating Tables (1:31:05) Inserting Data (1:38:17) Constraints (1:48:11) Update & Delete (1:56:11) Basic Queries (2:08:37) Company Database Intro (2:14:05) Creating Company Database (2:30:27 ) More Basic Queries (2:26:24) Functions (2:45:13) Wildcards (2:53:53) Union (3:01:36) Joins (3:11:49) Nested Queries (3:21:52) On Delete (3:30:05) Triggers (3:42 12) FR Diagrams Intro (3:55:53) Designing an ER Diagram (4:08:34) Converting ER Diagrams to Schemas
@ajopasoij9d005 жыл бұрын
Thanks for helping mobile users
@markwilde56835 жыл бұрын
Brilliant mate , thank you.
@aggasht1045 жыл бұрын
❤🤛🇧🇩
@wes65685 жыл бұрын
😂🇧🇷👌
@hitblank23205 жыл бұрын
Thanks mate
@meatbucket96265 жыл бұрын
my man sat down for 4 hours and 20 minutes and just talked about databases the whole time, god level
@Hustler_005 жыл бұрын
You know there are more then 100 cuts! Right? lol
@meatbucket96265 жыл бұрын
Yeah ik but 4 20 tho
@anakinskywalkerrr5 жыл бұрын
He's great with explaining things
@Justfun-xx6xe5 жыл бұрын
hemorhoids are developing 🤣
@lucienhughes86285 жыл бұрын
@@Hustler_00 Yeah but tshirt, beard and hair all look exactly the same all the way through, I reckon he recorded it all in one go!
@katbarako8 ай бұрын
When my kid went down for her nap today I had no idea what SQL was. By the time she woke up, I knew how to write queries and turn ER diagrams into to database schemas. Thanks, Giraffe man.
@bt786468 ай бұрын
Mam,how did you manage finishing it in straight 4 hours one day/didn't you have to pause and practice yourself?I
@Omer6987 ай бұрын
@@bt78646because she's lying
@GigglesandChuckles7776 ай бұрын
I need a recording memory like you, it's almost a week and still not finished 😂😂😂
@angiemakhubela2 жыл бұрын
To everyone who does not have the means to go to University or College and are self teaching, keep on going! your efforts will definitely be recognised 🙏🏾
@TeeJville102 жыл бұрын
That is very, thank you !
@anurag1588 Жыл бұрын
❤️❤️🙏🙏
@kelvingamer1776 Жыл бұрын
Amen!
@FireJach Жыл бұрын
I was there. i have got master's of economics and they didn't teach me this. I know excel, powerpoint, word but not this.
@prajjwal1010 Жыл бұрын
Thank you, same for you:)
@sahilpawarr4 жыл бұрын
who are these 1k people who disliked this video. The guy is teaching an entire language in 4hrs for free what the heck do you want?????
@tallitvak53254 жыл бұрын
Welcome to the World Wide Web, my friend.
@eddytheengineer4 жыл бұрын
The want pdf + exercises AND tutoring *FOR FREE* 😂 -- i know the type (lazy/ungrateful)
@sulaimankhan80334 жыл бұрын
Brother,... God just simply didn't make HELL.. He knew - there is one in every household that manages to ruins the special occasions...
@mdsaddamkhan84004 жыл бұрын
May be they are of different KZbin channel guy's
@nasirs55674 жыл бұрын
Colleges and university WORKERS
@lilnasd91932 жыл бұрын
Two weeks ago I started doing this course thinking that it would be useful for my placements and today I'm here to let you know that because of your teaching I actually learnt DBMS and got placed in an MNC .The recruiter asked me about DBMS functions and in particular he asked me about group by function which I otherwise wouldn't have answered . I'm really grateful for you and thank you very much Sir for taking your time to explain DBMS to us.
@asurachampion28812 жыл бұрын
Are u a bot or real human
@saansardar12152 жыл бұрын
@@asurachampion2881 why would he be a bot??
@afiffadillah38622 жыл бұрын
@@saansardar1215 that comment is a template
@saansardar12152 жыл бұрын
@@afiffadillah3862 oh okay i didn't know
@lilnasd91932 жыл бұрын
@@saansardar1215 I'm not a bot 😅
@prajwaltawade5287 ай бұрын
Trust me, if you want to start with basics, this is the best tutorial available on the internet, which clears your concepts without wasting much of your time. -- Five years experienced Data Analyst
@asmaa22633 ай бұрын
What is another resource if I finished this video?
@miss_pearl3 ай бұрын
Thank you. I knew nothing at all about databases or SQL. This video was the best. This guy is very good at introducing a new concept. The best SQL introduction on the internet.
@aniketbiswas98852 жыл бұрын
I will never forget how I ended up here and finally secured a job for myself and this course has had immesurable contribution towards my success. It helped me get started with SOMETHING when my brain was cluttered and I was living in despair with all the wrong decisions in life. I'm very very thankful to Mike and whoever put this course in this format.
@audaciousintrovert69uwu372 жыл бұрын
Should i study this video or watch more recently posted tutorials?
@rishabhsinghal32382 жыл бұрын
@@suprheasingh what's the problem that you are facing ?
@poppyflorist2 жыл бұрын
Hi bot
@vivekkoul4428 Жыл бұрын
Congrats 👏 so you got job in database field?
@aniketbiswas9885 Жыл бұрын
@@vivekkoul4428 yes.
@ZoldarMusic2 жыл бұрын
This was the only lesson of SQL I have ever taken and I managed to get a job as a Junior Data analyst! Thanks
@fawadzia29092 жыл бұрын
Amazing. Congratulations. I am also learning SQL to work as Data Analyst. Could to please guide how to prepare for an interview and have you learned Tableau also?
@im28792 жыл бұрын
What other resources did you use and how long did it take I'm interested in doing the same this summer. It would be of much help, Thank you
@divyabksunar19862 жыл бұрын
do you also have bachelor degree in related field or did you get the job without it and also where are you base? Thanks in advance.
@tarunrana7162 жыл бұрын
4hrs get u a job. I don't believe
@buggy_bug2 жыл бұрын
@@tarunrana716 for sql he studied only this, but you also need other skills
@terrabyte-techy5 жыл бұрын
Some of this KZbinrs really know how to prepare and convey tech materials way better than some lecturers in high-end institutions. Thank you so much for this upload.
@aniketpatil26325 жыл бұрын
yeah really !!!
@thomasjones95594 жыл бұрын
Im doing this weeks before my in house bootcamp bc i know it'll be 10× better in 10x less time
@mustache22954 жыл бұрын
This is why college degrees are obsolete regarding creating a useful and skilled professional.
@thomasjones95594 жыл бұрын
@@mustache2295 technical skills yes definitely obsolete but I do think my economics classes will help in the process for organizing queries in an efficient manner
@mustache22954 жыл бұрын
@@thomasjones9559 I'm sure efficiency can be learned without spending 30k
@kinsleynjikinsley25846 ай бұрын
The fact that you ended with ER diagrams that was exactly the tables created during the tutorial is legendary. Best SQL course I have followed.
@Official-tk3nc4 жыл бұрын
Contents ⭐ ⌨️ (0:00) Introduction ⌨️ (2:36) What is a Database? ⌨️ (23:10) Tables & Keys ⌨️ (43:31) SQL Basics ⌨️ (52:26) MySQL Windows Installation ⌨️ (1:01:59) MySQL Mac Installation ⌨️ (1:15:49) Creating Tables ⌨️ (1:31:05) Inserting Data ⌨️ (1:38:17) Constraints ⌨️ (1:48:11) Update & Delete ⌨️ (1:56:11) Basic Queries ⌨️ (2:08:37) Company Database Intro ⌨️ (2:14:05) Creating Company Database ⌨️ (2:30:27 ) More Basic Queries ⌨️ (2:26:24) Functions ⌨️ (2:45:13) Wildcards ⌨️ (2:53:53) Union ⌨️ (3:01:36) Joins ⌨️ (3:11:49) Nested Queries ⌨️ (3:21:52) On Delete ⌨️ (3:30:05) Triggers ⌨️ (3:42:12) ER Diagrams Intro ⌨️ (3:55:53) Designing an ER Diagram ⌨️ (4:08:34) Converting ER Diagrams to Schema
@heitornz4 жыл бұрын
Have a like, sir
@ifedayoakintomiwa23024 жыл бұрын
Thank you so much for this
@lanasaifulaqil4 жыл бұрын
Contents ⭐ ⌨️ (0:00) Introduction ⌨️ (2:36) What is a Database? ⌨️ (23:10) Tables & Keys ⌨️ (43:31) SQL Basics ⌨️ (52:26) MySQL Windows Installation ⌨️ (1:01:59) MySQL Mac Installation ⌨️ (1:15:49) Creating Tables ⌨️ (1:31:05) Inserting Data ⌨️ (1:38:17) Constraints ⌨️ (1:48:11) Update & Delete ⌨️ (1:56:11) Basic Queries ⌨️ (2:08:37) Company Database Intro ⌨️ (2:14:05) Creating Company Database ⌨️ (2:30:27 ) More Basic Queries ⌨️ (2:26:24) Functions ⌨️ (2:45:13) Wildcards ⌨️ (2:53:53) Union ⌨️ (3:01:36) Joins ⌨️ (3:11:49) Nested Queries ⌨️ (3:21:52) On Delete ⌨️ (3:30:05) Triggers ⌨️ (3:42:12) ER Diagrams Intro ⌨️ (3:55:53) Designing an ER Diagram ⌨️ (4:08:34) Converting ER Diagrams to Schema
@shreenidhhi86334 жыл бұрын
thanks boss
@natynt2274 жыл бұрын
Thank you
@jonsantos60562 жыл бұрын
9:45 DBMS; 12:20 C.R.U.D. wrt databases; 13:14 Two types of databases: SQL (tables) vs noSQL (json, graphs, etc); 16:19 RDBMS (e.g., mySQL, Oracle, etc) SQL is the language used to interact with RDBMS; 18:20 non-relational databases (e.g., mongoDB) noSQL; 20:04 Queries; 21:45 Summary thus far; 24:15 example scenario which shows how to use pri/foreign/composite keys; 25:05 primary key; 30:08 two types of primary keys: surrogate keys (no mapping to real world) vs natural keys (has mapping to real world); 30:31 foreign key (links to another database table); 36:45 composite key (a primary key that has two attributes); 40:25 an example that shows typical scenario and useful oraganizing such as the 'works with' table. 47:50 Intro to SQL (SQL comprises 4 types of languages e.g., DQL DDL DCL DML); 50:00 Intro to Queries; 52:24 53:45 *mySQL (Community Server) Installation for Windows*; 59:34 popSQL download (optional) 57:35 mySQL Command Line to create a database; 1:00:17 popSQL configuration for created database 1:15:50 Start of SQL coding: Tables; 1:18:54 Basic Data Types: Decimals & Varchar; 1:19:45 BLOB 1:21:07 Creation of Tables SQL Code (good to type SQL code in capitals and everything else in small case); 1:31:07 inserting data;
@nishanths17402 жыл бұрын
arigato senpai!
@valefarx2 жыл бұрын
bdsm> ?
@perseusgaming73972 жыл бұрын
how is desribe student different from select *from student ?
@rkpragyajitsingh30742 жыл бұрын
@@perseusgaming7397 describe returns the info of the table(data types, null values) while select * from student returns the content of the table.
@jonsantos60562 жыл бұрын
@@michaelcrowell9091 Same to you all too :)
@wazka12345 жыл бұрын
I don't agree that you're too wordy, I think the conversational level makes it easy to learn. I have been an educator for decades and for me, your style is perfect, don't listen to that criticism. By the way, thank you for this one and the Python class, good stuff!
@bazzmx5 жыл бұрын
I'm on the same boat and, because english is my second language, I appreciate that he reinforces what he's saying because it helps me to better understand the concepts
@reemabdullah14175 жыл бұрын
Hi , how can I get to python class ?? I need the video please
Man, you have to love it, he literally even starts with explaining what computers are for, no detail spared, a caveman could learn from this. It's great teaching. God bless!
@haiphan91813 жыл бұрын
This man is going to heaven on a first-class seat.
@shortscenes89613 жыл бұрын
Phle maar de ya tu
@ihsansabriyesilyurtstudent60993 жыл бұрын
:D dude
@shahriyarplayz80053 жыл бұрын
xD
@nandanraj36363 жыл бұрын
He will live forever.
@EJ-jh1vf3 жыл бұрын
uuuuuh, anyone else getting 9/11 vibes?
@aylinonay41233 жыл бұрын
I can't emphasize enough how much I absolutely love that all the data was from The Office. Literally made this tutorial even better. Thanks!
@rishabh28853 жыл бұрын
Right???😩
@ParthGoel2013 жыл бұрын
hahahahahah I was looking for a comment that mentioned this, lol!
@dinona2473 жыл бұрын
yessss
@akshaysankar23183 жыл бұрын
Ikr
@mohdkaif8643 жыл бұрын
I was just gonna comment this but you already did it
@kesavae95524 жыл бұрын
One day we all are gonna come back and tell this is where it all started ♥️
@MogalMauli3 жыл бұрын
same here
@diabolus94663 жыл бұрын
Me right now.
@mauamadoudrammeh80833 жыл бұрын
for sure man
@syedsalahuddinquadri61493 жыл бұрын
Might be in future
@strangetoucane3 жыл бұрын
Me 3
@MFslQureshiАй бұрын
It took me 4 days to complete this video, at start i knew nothing about SQL beside its name🤣🤣 and now, I know a lot about SQL, data base, how to write codes, how to use different queries etc. This course puts you on track. a great effort.
@you_know_who173626 күн бұрын
hey just curious, was this video really helpful like even for attending interviews??
@MFslQureshi26 күн бұрын
@@you_know_who1736 dear it gives you basic knowledge of SQL, you understand the whole concept. But there is alot to learn. Its great for starting.
@iben11952 жыл бұрын
I like how this guy sits, leans and relaxes like a king
@Atlas929362 жыл бұрын
Defaq
@csanadtemesvari92512 жыл бұрын
Because he is 😎
@MrDELL-cx3ck2 жыл бұрын
Haha 😀
@sary62562 жыл бұрын
lol
@mayadaabuagla79242 жыл бұрын
And still explaining to us really well 😂💕
@astherieIIemercadejas Жыл бұрын
9:35 DBMS 12:20 CRUD (4 main operations of database) 13:15 2 types of databases 16:37 SQL 20:10 queries 26:37 primary key 29:18 surrogate key 30:11 surrogate key vs natural key 30:33 foreign key 36:49 composite key
@gautamphadnis76299 ай бұрын
thanks🙏
@icermli6 жыл бұрын
⭐️ Contents ⭐ ⌨️ (0:00) Introduction ⌨️ (2:36) What is a Database? ⌨️ (23:10) Tables & Keys ⌨️ (43:31) SQL Basics ⌨️ (52:26) MySQL Windows Installation ⌨️ (1:01:59) MySQL Mac Installation ⌨️ (1:15:49) Creating Tables ⌨️ (1:31:05) Inserting Data ⌨️ (1:38:17) Constraints ⌨️ (1:48:11) Update & Delete ⌨️ (1:56:11) Basic Queries ⌨️ (2:08:37) Company Database Intro ⌨️ (2:14:05) Creating Company Database ⌨️ (2:30:27 ) More Basic Queries ⌨️ (2:26:24) Functions ⌨️ (2:45:13) Wildcards ⌨️ (2:53:53) Union ⌨️ (3:01:36) Joins ⌨️ (3:11:49) Nested Queries ⌨️ (3:21:52) On Delete ⌨️ (3:30:05) Triggers ⌨️ (3:42:12) ER Diagrams Intro ⌨️ (3:55:53) Designing an ER Diagram ⌨️ (4:08:34) Converting ER Diagrams to Schemas
@subject_of_ymir6 жыл бұрын
Thanks for saving my time.
@Imrankhan-xw4me6 жыл бұрын
Thanks a lot for your excellent work. Really amazing.
@teckkers92956 жыл бұрын
The contents are already in the description btw...
@floodland80s6 жыл бұрын
We appreciate these clickable timestamps.
@Gevito2366 жыл бұрын
Man, i was about to wait 52 minutes for the Windows install. Thanks.
@m00s3knuckl3 Жыл бұрын
Anyone here coming from an Excel background? I've been using Excel for years in the ways SQL is intended to be used with databases. This video has singlehandedly convinced me to pursue more technical roles!
@vijayswamy25644 жыл бұрын
Hi Mike. I Stumbled upon your Python tutorial doing a general search. I started the tutorial. I am 64 and I see that you are young. Hats off to you for being young and able to teach people like me in a manner and language that I understand easily. I am also simultaneously studying your SQL tutorial. Kudos to you for repeating concepts to underline and drill them in. After so many attempts, I have finally understood the foreign key concept. With you learning is fun and progress can be measured.Keep up the good work. I cannot thank you enough for making learning a pleasant task.
@justanotherslaveofallah16224 жыл бұрын
Kudos to you for learning even during 64
@vijayswamy25644 жыл бұрын
@@justanotherslaveofallah1622 Thank you Sir.
@cibelless5104 жыл бұрын
You are the master...and 64 is nothing ..just a number..remember that..success for you
@vijayswamy25644 жыл бұрын
@@cibelless510 Thanks for the encouragement. Successfully completed the SQL tutorial. Finally understood how the join syntax can be written and how it works. -Cheers
@r_m55454 жыл бұрын
Keep learning sir , even you are a big inspiration for we youngsters 🙏
@zerosandones7015 жыл бұрын
Realized after watching that this stuff isn't actually hard... it was just never explained well! Thank you Mike!
@thomasjones95594 жыл бұрын
Not explained in human language
@mjxtacreaixe4 жыл бұрын
You can say that about most 'difficult' things
@spbs-wb9wt4 жыл бұрын
Yeah i'm thinking the same
@tonyarteaga58345 жыл бұрын
I'm having an interview tomorrow and I'm watching this tutorial to refresh my memory about SQL, wish me luck!! Python developer here :) PS. Thanks for this vid man, great course. Edit: I qualified! I was waiting the call, I start wednesday, thanks for asking!
@ayushpriyadarshi40495 жыл бұрын
how did your interview go ?
@sannidhirao12815 жыл бұрын
hey did this video help clearing the interview?
@NishantSingh-px3jm5 жыл бұрын
print('Congratulations brother")
@cormano645 жыл бұрын
Well done, congrats on the new job!
@EliseoRocha5 жыл бұрын
Congrats! I’m doing the same thing for my interview tomorrow.
@AbhijeetKumar-pk8tg Жыл бұрын
⌨ (0:00) Introduction ⌨ (2:36) What is a Database? ⌨ (23:10) Tables & Keys ⌨ (43:31) SQL Basics ⌨ (52:26) MySQL Windows Installation ⌨ (1:01:59) MySQL Mac Installation 1:13:10 popsql installation ⌨ (1:15:49) Creating Tables ⌨ (1:31:05) Inserting Data ⌨ (1:38:17) Constraints ⌨ (1:48:11) Update & Delete ⌨ (1:56:11) Basic Queries ⌨ (2:08:37) Company Database Intro ⌨ (2:14:05) Creating Company Database ⌨ (2:30:27 ) More Basic Queries ⌨ (2:26:24) Functions ⌨ (2:45:13) Wildcards ⌨ (2:53:53) Union ⌨ (3:01:36) Joins ⌨ (3:11:49) Nested Queries ⌨ (3:21:52) On Delete ⌨ (3:30:05) Triggers ⌨ (3:42:12) ER Diagrams Intro ⌨ (3:55:53) Designing an ER Diagram ⌨ (4:08:34) Converting ER Diagrams to Schema personal use kzbin.infogaming/emoji/7ff574f2/emoji_u2328.png
@syedafatima8979 Жыл бұрын
it ain't much if im learning it ALL
@Suhasmicheal3 жыл бұрын
after watching this for more than 2 weeks and preparing notes of 95 pages, I'm finally done... there are ppl who finished it in a couple days, don't compare yourself with others, take your time and just make sure you get what your doing.
@barebears2893 жыл бұрын
Could you share your notes?
@mehediazad17803 жыл бұрын
please share your notes.
@bhuvanamuthyala21063 жыл бұрын
I have a interview tomorrow
@khushraouiux3 жыл бұрын
Hey will you please share your notes
@thilinaavishka50843 жыл бұрын
If you could share your notes that'd be a great help for everyone
@rs63924 жыл бұрын
4h20m without ads! Humanity still exists.
@Kanal7Indonesia4 жыл бұрын
420 blaze it
@xc60134 жыл бұрын
and he explained much better than my teachers, it's like this lad is sent by God to help with the exams
@bellamycat98004 жыл бұрын
What’s wrong with the ads can’t you see them they will at least give some money to them. He randomly didn’t put it
@spartan29064 жыл бұрын
I honestly don't think by putting Ads he will be hurting anyone. He can put ads in the end . He put little effort here , so he deserve little.
@bellamycat98004 жыл бұрын
HuddyD KZbin will collapse with this video
@lifeviz285683 жыл бұрын
you teach the entire databases course in 4 hours, that is way better and more efficient than my prof who rambles on and i don't get much out of his course for the entire 16 weeks. thanks dude! you're our lifesaver and a silent unsung hero!
@sirazulhaqabdulmajid49033 жыл бұрын
same here
@longthanhvu84152 жыл бұрын
oh i can't download popsql :((( may someone help me ?
@nonameprivate46892 жыл бұрын
@@longthanhvu8415 what happen ?
@omer_sz2 жыл бұрын
definitely
@bondnikunj2 жыл бұрын
Nyways to delve deeper? May be a part 2 or advanced sql????
@allenc6609 Жыл бұрын
Hi Mike, I just want to say thank you for providing such a great beginner's course for SQL and DB. I spent the last three weeks studying thoroughly and it's absolutely eye-opening for me. Thanks lot!
@prajwaltawade528 Жыл бұрын
I am working as a sql developer And let me tell you when I was fresher I watch this course and when I look back I think this is one of the best sql course to start with
@vijayyadav8806 Жыл бұрын
Hello brother can you help me in sql
@timothynaini8404 Жыл бұрын
And where should I continue my study from here?
@xrafter8 ай бұрын
@@timothynaini8404 The documentation
@prajwaltawade5287 ай бұрын
@@vijayyadav8806 what kind of help you require ?
@prajwaltawade5287 ай бұрын
@@timothynaini8404 You can pick the topics and start practicing from w3school or Install any RDBMS in your local machine
@noir371 Жыл бұрын
Nearly done learning all the full stack web stuff and I just gotta say...mad respect to this guy. Might not have made it without you.
@elitemartial16529 ай бұрын
How long did it take you
@A.n.u_s.r.e.e2 ай бұрын
hey is there any way to download the pdf of the lesson?
@jane_emilith Жыл бұрын
This course is way better than those I paid for on Udemy. Clear, well-structured and concise. Thank you so much for your hard work, you are a really great teacher! *Followed you on Linkedin*
@jonlima9897 Жыл бұрын
Hey! Are you currently working as developer?
@jane_emilith Жыл бұрын
@@jonlima9897 no, I'm not in tech, just learning stuff for my pleasure and career prospects
@oldpain7625 Жыл бұрын
@@digitalsmartguide5672I'm male #2. I'm going to fight you now.
@kzisaeed93 Жыл бұрын
cant find him in linkedin. can you provide his linkedin id please.
@okaforjoseph8445 Жыл бұрын
Please send me your PopSql file, I could not download it
@Phil-nc5mwАй бұрын
I write this to save somebody time. If your like me and you made a table wrong, try to delete it, but cant because it has a foreign key to another table here the solution. SHOW CREATE TABLE table_name; to get the constraint name for that key. Then use ALTER TABLE table_name DROP CONSTRAINT constraint_name. Hope this helps somone cause I spent a lot of time trying to drop a table.
@EngrLethA2 жыл бұрын
Thanks a bunch. I finished your 4 hour course.. I am 61 and just fascinated with these section of education. Retired engineer of the Armed Forces. I’ll share your video and channel to my son. 🙏🍾🎉
@myJourney.20s Жыл бұрын
Hi guy, do you have any ideas how to import a csv file into popsql?? I've been crazy about this, I want to practice more :(((
@UAwan015 Жыл бұрын
@@myJourney.20s just google iy
@manoharikandasamy799 Жыл бұрын
@@myJourney.20s she's a girl not a guy 😅
@ЛазарЙорданов-й7щ4 жыл бұрын
This guy is insane, he knows every language
@tikitoka90264 жыл бұрын
i learned c from him
@mble4 жыл бұрын
I guess he just know how in general programming languages works and then before he makes a tutorial about specific one, he is reading about its syntax and other stuff
@rezhaadriantanuharja33894 жыл бұрын
Maciej Błędkowski once we understand algorithms, we can pick any language and do quite well with google (mainly Stack Overflow)
@vishnunetha87064 жыл бұрын
Yas😰💥🔥
@okaiee69114 жыл бұрын
Does he know Chinese 😂
@PatientEbwele6 жыл бұрын
Excellent course. I am teaching myself SQL and I couldn't find a better course. Thank you so much
@wm65495 жыл бұрын
Do you have an opinion on the Khan Academy course?
@Matthew-hh6ex5 жыл бұрын
How is Cameroon tonight Mr. Ebwele?
@goodluckythomas1093 Жыл бұрын
Okay so am done with this course after studying it for 4 days. Before giving my review i have to declare interest that am an IT graduate so most of the concepts are not new except for Trigger concept, that was like breaking news to me 😂😂😂😂. This course covers almost every basic concepts of SQL database. What i like from the instructor was his ability to be so consice and approach a topic in a way that won't be taking too much of your time when you come back for revision especially when an interview is around the corner. But if you want to be more skilled and knowledgeable about SQL then you definitely know this is not all as the title suggests. On scale of 1 to 10, i would rate it 9. It has been good experience and i can't wait for more. God bless all of you trying to get your things right 🙏
@sonynguyen49543 жыл бұрын
The best thing about this guy is that he uses The Office's characters as examples. Beside the fact that he does teach and convey those information and knowledge very well. Thank you very much master!
@furkanyakkan15292 жыл бұрын
But I have a problem in here, where is Dwight Schrute???
@enricocirignaco79642 жыл бұрын
I was looking for this comment. Thank you
@casafurix2 жыл бұрын
@@furkanyakkan1529 he was executed on multiple counts of identity theft.
@tusharpardeshi21152 жыл бұрын
@@furkanyakkan1529 I guess he was busy irritating Jim Halpert with his antics.
@idrismustapha95242 жыл бұрын
Happy to see a fellow fan of the show 😀
@iamrashidpathan5 жыл бұрын
this video helped me crack a job interview at TATA consultancy services. thank you so much
@ayushpandey75 жыл бұрын
Congratulations my dear friend and Work hard, you have a great future ahead.
@techfortruth5865 жыл бұрын
Congratulations bro
@abhinav94695 жыл бұрын
Congrats Rashid....
@raaghavsharma3785 жыл бұрын
Bhai me to de nhi paya 60% k wjah se
@vikaskumarsingh36085 жыл бұрын
hii rashid khan, can you please help me, I'm also preparing for interview of TCS
@1cannon35 жыл бұрын
1:11:05 - How to log into MySQL (mysql -u root -p) 1:11:26 - Hot to create a database (create database ;)
@cheesegrillzАй бұрын
I just completed learning SQL and Python in 1 weekend thanks to this guy 4h courses each. Saturday SQL/Sunday Python. Now am doing HackerRank questions. Basically wondering if I can learn 2 languages in 1 week for an upcoming technical coding test.
@Roodyculous4 жыл бұрын
Nobody is gonna comment that he has used The Office characters to explain DBMS. Man! This could not have gone any better. Love the office and loved your Tutorial. Keep making such tutorials!! As a great man once said - " I want people to be afraid of how much they love me." You, my man are on that path!
@mukhammadmuratov57154 жыл бұрын
My mind is all in tech now.. I though that you refer to MS office and characters as in data types))))) Took me a while :)
@rakib178744 жыл бұрын
@@mukhammadmuratov5715 thought the same..lol
@VegaZen1234 жыл бұрын
Even I didn't notice that untill he started inserting data..and all of sudden I noticed familiar names Micahel, Jim, Kelly ..lol
@KellyFenner4 жыл бұрын
I liked the part where he played it cool by saying "maybe the work with paper products." Lol
@thesimulatedcreator61874 жыл бұрын
I did lol but not instantly. I had to listen to him say Michael Scott to realize all the databases are based on the office xD
@roboakes19164 жыл бұрын
I’m in an apprenticeship right now with an IT company who uses SQL and I was assigned an SQL pre-learning material which was useless and didn’t tell me anything. I came to KZbin for help and I’ve gotta say man, you’ve helped me out a bunch. You have made my life a whole lot easier. Thanks a bunch!
@harshhingu30823 жыл бұрын
Hey I wanna know that MySQL and SQL is different so the person in this tutorial why is he installing MySQL I think he should install oracle 11g or 19c SQL for SQL tutorials?
@AngelaSMak4 жыл бұрын
Can’t believe what I learn the whole semester in class and now you show everything in 4 hours here. That is amazing. Thank you very much for your tutorial. You are the best teacher !
@akhilgupta16714 жыл бұрын
Seriously is that a separate subject for one whole semester??I am from non CS background so just wondering!!!
@aryaatanpure53804 жыл бұрын
@@akhilgupta1671 yup for me I whole sem is for sql and database
@girishsathuluri79503 жыл бұрын
Pls help me that did i need lap top for learning this course or mobile is enough
@realbenedictik Жыл бұрын
Bucky. This guy was my first online tutor during my undergrad days. I'm definitely sure I'm gonna love this video
@KaTe-bb2er Жыл бұрын
Thanks! Awesome instructor & format! I’m very impressed young man. Keep us the good work.
@Arthurk346 Жыл бұрын
When I started to learn programming in 2019 the first tutorial I've watched was this guy's C++. Now I'm 2 years into full time software development and I am glad to gain some knowledge from him again.
@shravanibalakrishnan50667 ай бұрын
Could u help me to develop skill
@rishabhgoyal31433 жыл бұрын
When downloading/installing mySQL shell/command line client, always choose the latest one available, not the version used in the video; because you will get errors otherwise. Hope this saves you some time and effort!
@notsoaverageraj79173 жыл бұрын
I was about to go with the server version he used, but then when adding the shell I couldn't find the old versions. thankfully came across this comment before proceeding with the install.
@bazinga76833 жыл бұрын
thanks
@MusicAD3 жыл бұрын
Please Pin this comment😁
@valeraanovsk14683 жыл бұрын
Good job for pointing it out, thank you
@speeddemon9453 жыл бұрын
maybe that's the reason why i'm getting this "permission denied for schema public" error.. will update mine.. followed his version.. Thanks!
@joshgar2 ай бұрын
This guy is a legend at breaking down complex ideas into their simplest forms and understands how to pace the concepts and the importance of repetition and/or redundancy when learning something new; a great teacher
@ruhankoekemoer8815 Жыл бұрын
Dude, I just want to give you a huge thanks. Going into this video a week ago I knew nothing about SQL and after working through this video and following along on your website I am now at a point where I know enough to be able to formulate my google searches to get within 98% of what I want and tweak it from there. I'm by no means an SQL master yet but you have given me a great understanding of the subject to build from.
@felixcsao41844 жыл бұрын
This dude really just explained the lore of the Office using tables, what a legend
@brandonbishop26704 жыл бұрын
Did anyone else copy and paste the code from his website and get this error, "Cannot add or update a child row: a foreign key constraint fail" when you ran this line of code, INSERT INTO employee VALUES(101, 'Jan', 'Levinson', '1961-05-11', 'F', 110000, 100, 1);
@pkavenger9990 Жыл бұрын
I am just 15 minutes into this course and I really love how you explained each and everything in start and going step by step. no wonder it has 13M views.
@ubayyd Жыл бұрын
yessir
@rajatjoshi6200 Жыл бұрын
@@SurajAmbre-vz4vg i would suggest taking screenshot
@jessh4016 Жыл бұрын
@@DimitrisKoutrakis 15M*
@zitounisana4250 Жыл бұрын
16*
@snehashinde56017 ай бұрын
@abdalrahmanalrefai8973 Жыл бұрын
I can't believed someone managed to wrap SQL and ERD in 4 hours long video, you're a king! Thank you very much!
@NabeelButt Жыл бұрын
Just a small correction. The employee table in the picture has column 'birth_date' whereas if you copy the SQL code from the given PDF, the column name is 'birth_day'. So while you are running some of the example queries, you might bump into an error. Just change the column name and the query will work! 👍
@teddyfabriciocordovasaenz3018 Жыл бұрын
thanks for expalin it
@JohnDoe-fe7hr Жыл бұрын
Command to fix it: ALTER TABLE employee RENAME COLUMN birth_day TO birth_date;
@aliyassin9020 Жыл бұрын
Hi nabeel, i have been looking for the SQL code from the given FDF he mentioned at 2:10.27 but cant find it. Plz help send me if you can.
@aarushiraid2542 Жыл бұрын
hello i am having some trouble. My popSQL is not taking in any data types, like INT or VARCHAR, what should I do.
At 2:39:29, the column has been named as birth_day in the schema that is provided for making the employee table. Hence, if we query as birth_date > 'XXXX-XX-XX' the query will return an error.. Please take note for those who are facing an error.
@a_random_personnn Жыл бұрын
Thank you! This comment saved me a lot of time
@user-km5lt9kg7p3 жыл бұрын
man this guy looks so chill and he knows almost every programming language 😱
@indraxios3 жыл бұрын
Not a big deal Almost all software Engineer at top MNC know most. Of the languages
@carlosrg3653 жыл бұрын
@@indraxios but this guy is so young
@sandersnolan68953 жыл бұрын
Hello,how can I understand ‘he looks chill’.I am Chinese
@lukeberryarchive3 жыл бұрын
@@sandersnolan6895 chill means relaxed
@beflames24793 жыл бұрын
not really
@mikoletz759 Жыл бұрын
Just want to show my appreciation to the creator of this course. Best 4 hours of my learning slot. Keep up the good work!
@ahsanasif88193 жыл бұрын
HOW TO CONNECT popsql to mysql updated: 1) Go to file -> preferences 2) Click connections tab 3) Add new connection 4) Fill it in like he did 1:00:44 5) Turn on "connect directly from my computer" slider under advanced options
@tininab3 жыл бұрын
Thank you!
@georgevavolil70053 жыл бұрын
Thank you so much 💯💯
@polygonmap2 жыл бұрын
hey, can you suggest me what could happen if I don't can't install popsql? is it just easier to use popsql for beginner or we can just use MySQL?
@harshithakeshav11993 жыл бұрын
THE BEST SQL tutorial available for beginners. Everything you need to get started with SQL is clearly explained in this video. Awesome job Mike !! Cannot thank you enough for creating such quality tutorial on SQL. Loved the way you have created Company Database with THE OFFICE reference.
@kdslife693 жыл бұрын
@harshitha keshav I have zero knowledge of SQL so should I follow this one as I want to learn SQL for my campus placements.
@navyasrinivasan66893 жыл бұрын
Will he covered all the concepts in Sql ? anything will be there to study other than this?
@kingofkings63023 жыл бұрын
Where should I go from here,can you help me mate???
@aanaybhure70793 жыл бұрын
#eazzylearninglab fallow us
@kabita15362 жыл бұрын
Is he teaching SQL or MySQL??
@RJones-mx2oi3 жыл бұрын
FOR THE REAL BEGINNERS: Two things to you will want to check if you install beyond what is used in the tutorial is to have Python and Microsoft Visual Studio. My circumstance will also require Python and some other things. Make sure that you have the space and power for them. If you need to get an external hard drive to store the programs, there is a hack and work around for running programs from an external hard drive. Secondly, the possible additional software needed will require extra TIME that you will want to factor in for this tutorial. As seen below, this is a quality video. But, I had to pause for a good while to get just these 2 requirements installed before I could complete the MySQL installation. HTH to all the self-taught people pulling themselves up.
@bjmckenney54 Жыл бұрын
I am thoroughly impressed and refreshed with the flow of this tutorial. With years of managing data and creating minor databases (study as I go), I needed to be updated to search for a part-time job after being retired for 2 years. Thank you
@wolei_sway3 жыл бұрын
The way you demystify things is truly amazing. You're a great teacher
@greeshmagreesh92544 жыл бұрын
He is just explaining perfectly , literally not getting bored
@Kanal7Indonesia4 жыл бұрын
He wasted no time and very concise that's why it's not boring
@henafaizuddin19895 жыл бұрын
I went through a few tutorials for beginner SQL and this is by far the best (and last) one I will need to watch. Thank you so much for sharing your knowledge with us...and loved the Office reference too lol
@rosjja5 жыл бұрын
I totally agree with you! But one thing I'm unsure about is that are the "codes" of SQL same for both MySQL and Oracle's ? Or will it be differ at some point ?
@cyborg62945 жыл бұрын
@@rosjja differ a little
@Americo_Kutabiala6 ай бұрын
The error message "You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column" means that you are trying to update a table without specifying a WHERE clause that uses a key column. In your case, the table studant has a primary key column called studant_id. When you update a table with a primary key, you must specify a WHERE clause that uses the primary key column to identify the rows that you want to update. For example, the following query would update the major of the student with the studant_id of 1: UPDATE studant SET major="bio" WHERE studant_id=1;
@daviddunmer38893 жыл бұрын
Few people can claim to have the kind of net positive impact in the world as this guy can. Well done Mike, the world thanks you!
@DoodleDoo3 жыл бұрын
yeah I wish university teachers were half as good as this. they overcomplicate simple concepts.
@bacet92802 жыл бұрын
@@DoodleDoo 🤣🤣🤣🤣🤣🤣🤣 Love your comment
@hexdex48003 жыл бұрын
Great course. Love the idea of having Michael Scott and Co in the examples. You deserve a Dundie Award.
@jamesmount1934 жыл бұрын
This helped me land a junior level job in swe don’t ask how I didn’t learn sql throughout a whole cs degree
@dsk_13373 жыл бұрын
I didnt either xd
@codewithsheikh28053 жыл бұрын
same
@rickeyjones7293 жыл бұрын
@@codewithsheikh2805 I'm learning it right now through this video what other videos u suggest or codes I should learn next for this field I got the table insert all locked this dudes video is so straight to the point.
@codewithsheikh28053 жыл бұрын
@@rickeyjones729 i was referring what he has written in Last I'm currently watching mosh hamdanis MySQL course
@codewithsheikh28053 жыл бұрын
@@rickeyjones729 do you know any programming language?
@syedmuhammadrafay228 Жыл бұрын
This guy is a gem. May Almighty Allah reward you for this.
@aphiwemntungwa57405 жыл бұрын
to all those having a similar problem of popsql not being free anymore, i'd recommend mySQL workbench, it works perfectly. You can even install it when customizing your mySQL
@mihaialic5 жыл бұрын
Same here. Even if you installed mySQL without it, just run installer again and include the workbench.
@droidgeist4 жыл бұрын
MySQL Workbench also lets you do the triggers in the app - no need to move to the Terminal.
@br3ak_4 жыл бұрын
Thanks a lot!
@manutap2 жыл бұрын
from Michał Sieja POPSQL CONNECT ISSUE 1 month ago (edited) 1:00:00 For the people who cannot find how to connect the newest popSQL with your mySQL database. (from popSQL) file > Preferences > Connections > Add new connection > mySQL Than you follow every step Mike presented, but you need to check one additional box described as "Connection Type (Connect directly from my computer). It took me like 3 minutes to figure out so i am posting this and maybe i'll save some of you a few minutes of frustration please re comment every day for new people ALSO MAKE SURE THE DATABASE NAME WHICH IS "GIRRAFE" MATCHES WHEN YOUR CONNECTING, MAKE SURE YOU SPELLED IT SAME IN THE COMMAND LINE AND WHEN YOU ARE CONNECTING IN POPSQL
@duckpilot9622 жыл бұрын
thanks Love u so much
@rayfanndesu Жыл бұрын
Oh my god thank you SO much for this, i was stuck for half an hour on forums trying to sort this out. Thanks again!
@Being_Michelle Жыл бұрын
Thankyou so much I have been stuck for more than an hour
@srikarreddy82525 жыл бұрын
Dude seriously your tutorials are GOLD!Especially for people who are just lost thinking where to start or learn programming from!!THANK YOU!!
@light6230 Жыл бұрын
Thank you so much Mike! You are an excellent teacher! I am going to take a data analysis course in college this upcoming semester and I got put in a half semester class and I was very concerned that the pace of the class would be too fast for me. I decided I would try to start learning the material ahead of time so I could keep up and came across your tutorial. You are helping me so much! Much appreciation!
@MikeThr332 жыл бұрын
1:00:00 For the people who cannot find how to connect the newest popSQL with your mySQL database. (from popSQL) file > Preferences > Connections > Add new connection > mySQL Than you follow every step Mike presented, but you need to check one additional box described as "Connection Type (Connect directly from my computer). It took me like 3 minutes to figure out so i am posting this and maybe i'll save some of you a few minutes of frustration
@urbrt26532 жыл бұрын
THANK YOU FOR THIS. typing localhost gives me an error tho?
@alainamolnar21992 жыл бұрын
Thank you so much!!!!
@manutap2 жыл бұрын
you should be up top
@vinitagivale Жыл бұрын
thank you for this
@tharinda972 жыл бұрын
I've just finished this course. I wanted to revise what I've learned in a previous semester in my campus because I have a module on 'Advanced Data Management' coming up next semester. I learned many SQL codes which I didn't know before and learned how to convert a set of requirements into a database schema step by step. Thanks so much Mike for creating this valuable content!
@-KiranBabuAmbati2 жыл бұрын
Contents ⭐ ⌨ (0:00) Introduction ⌨ (2:36) What is a Database? ⌨ (23:10) Tables & Keys ⌨ (43:31) SQL Basics ⌨ (52:26) MySQL Windows Installation ⌨ (1:01:59) MySQL Mac Installation ⌨ (1:15:49) Creating Tables ⌨ (1:31:05) Inserting Data ⌨ (1:38:17) Constraints ⌨ (1:48:11) Update & Delete ⌨ (1:56:11) Basic Queries ⌨ (2:08:37) Company Database Intro ⌨ (2:14:05) Creating Company Database ⌨ (2:30:27 ) More Basic Queries ⌨ (2:26:24) Functions ⌨ (2:45:13) Wildcards ⌨ (2:53:53) Union ⌨ (3:01:36) Joins ⌨ (3:11:49) Nested Queries ⌨ (3:21:52) On Delete ⌨ (3:30:05) Triggers ⌨ (3:42:12) ER Diagrams Intro ⌨ (3:55:53) Designing an ER Diagram ⌨ (4:08:34) Converting ER Diagrams to Schema
@markpro3452 жыл бұрын
When you copy and paste the description...
@johnbasha54952 жыл бұрын
This a order to learn?
@Piar2004 Жыл бұрын
Hi my query from (wildcards) employee table ”SELECT * FROM employee where birth_date Like’%____ -10%’; did not retrive data from the table although status :Success and bring me empty table😔i have data in employee table.Can someone help me please
@bunnycharley5904 Жыл бұрын
@@Piar2004 LIKE '____-10%' u should be using this , '_' this replaces a character where as % is for any number of characters ,, u used both of them along (’%__ -10%’) .
@hugog.cintra25736 ай бұрын
The amount of knowledge that I've gained from this video is unutterable! I'll be sure to make a substantial as soon as I can. You gave me the power to change my life sir, I cannot express how much you've helped me.
@adedayoogunniran8012 Жыл бұрын
This is one of the best learning videos I've come across so far. I have been watching all the videos on this course on this channel for some weeks. I loved the course all through. I always looked forward to continue watching and practicing. Mike made a complicated language really simple and easy to learn. Only a great and amazing teacher can do that. Thank you so much, Mike.
@KaTe-bb2er Жыл бұрын
Agreed!
@jindammadhav21895 жыл бұрын
best lecture on dbms. This guy has whole computer database hidden in him.Lots of love❤❤
@rishabhgoyal31433 жыл бұрын
Using the "The Office" scene as an example is pure genius.. it is just perfect for this tutorial!
@Myheart196089 күн бұрын
This guy took me through programming in C and now he is saving my ass in SQL..how can i thank him enough??
@maksimtsikhanovich279 Жыл бұрын
Great course for beginners. Did it in 1 day. Sat down at 1pm and finished at 9:30pm.
@aayushitrivedi3481 Жыл бұрын
Does it cover everything from SQL?
@aayushitrivedi3481 Жыл бұрын
Till the intermediate level atleast?
@ahmedyassinzouaoui8257 Жыл бұрын
@@aayushitrivedi3481 after 2 hours u will have all the basics
@maleksoltani16605 жыл бұрын
Using data from "The Office" made the course waaaaaay more fun, thank you :p
@toughchic63775 жыл бұрын
Thank you very much for this. I had to learn SQL in a short time using MySQL and you have saved my life! I searched for something like this for a long time and there is NOTHING out there like you; easy to understand for beginners, clear and proper examples and actual coding instead of adding another program to just click around (which most importantly is what I was required to do for my assignment). Keep up the phenomenal work! I recommended you to other students like me, who were struggling with no proper help from learned lecturers.
@pillfreehope112 Жыл бұрын
I built my own website and am now trying to create a database for the cloned version. I had 3 options for learning; tutoring, class or teach myself via KZbin videos. I am starting with you. I really like how you repeat things to beat it into my head. I really like your style of teaching. I think I’m going to learn a lot from you and I greatly appreciate this video!
@vijaysolanki65933 жыл бұрын
You have taught me more programming than my college ever did in those 4 yrs !!
@eshwar24963 жыл бұрын
Leave a like for this guy (for the video) who sat for 4 hrs teaching everything with patience He is truly great, how unfortunate are those 1.6k dislikers
@Turco9493 жыл бұрын
Those dislikes are probably from "slower" parties who needed more than 4 hours to comprehend all the information. All joking aside, unless the person had a fundamental SQL knowledge already, this 4-hour course is likely to be overwhelming for anyone who lacks a decent level of IQ, like myself! Best to break this course into 20-30 minute segments since that is probably the longest anyone new to the topic can properly focus on while also able to learn. It'd still take 4 hours but broken into small installments instead of a single serving.
@vikasmishra41673 жыл бұрын
@@Turco949 You could watch it in small segments by yourself tho
@Turco9493 жыл бұрын
@@vikasmishra4167 That is exactly what I did and typically do. I don't watch for the sake of watching and think I am actually "getting" it all. Hardly anyone could if they are a new to the subject matter.
@vengalrao57723 жыл бұрын
I am a beginner can anyone tell me ! Do this video covers all topics ?
@eshwar24963 жыл бұрын
@@vengalrao5772 almost all
@kennedymusyoki7514 ай бұрын
I cannot regret spending my precious time watching and practicing with the tutor. I now describe myself as a data analyst. Thank you.
@sanazaheerzafar8234 ай бұрын
👍
@jinhongloke78674 жыл бұрын
Thank Q very much mike, i learned a lot. Tomorrow 09/06/2020 is my interview SQL test . I spend two days watching this video. I dont have any IT knowledge and hope can get the job.
@saint_sirius92654 жыл бұрын
and how are your job!?
@pariahincognito39142 жыл бұрын
This course is good and timeless! You literally discussed a semester's worth of lectures in just 4 hours. I learned a lot here more than in my class. I'm taking this to refresh my knowledge on SQL for a job interview, hope I'll do well.
@learnwithajay_58022 жыл бұрын
kzbin.info/www/bejne/iZq7k3eufcmKmbc
@milosloncaric70792 жыл бұрын
Did u get job
@lavinamakena93992 жыл бұрын
how did your interview go.
@anshul6626 Жыл бұрын
Hey .....did you get the job??
@reztheson2 жыл бұрын
This is my first day of learning SQL and I can confidently say you make it seems easy to me. Still on 40 minutes in and I’m understanding the concept. I’m trying to teach myself. Thank you man.
@reztheson Жыл бұрын
@@nonam2692 yeah it worth it. Then you can also check out Alex The Analyst
@LearnwithChowdhury Жыл бұрын
@@nonam2692 go for it
@ArikCastro11 ай бұрын
I have been struggling in my online college course and I am probably not going to give up but I really wish i found this video sooner it is so awesome with great explanations, I got a final in two days so I'll be staying up all night watching the whole thing on 1.5x. I really enjoy learning about this stuff as it is so practical. Wish me luck!
@ArikCastro11 ай бұрын
ok just watched the whole thing and wow this guy is so talented i watched another video about azure and that one was very helpful as well. very good channel.
@shivakrishnan920610 ай бұрын
Wish you better luck
@MiltonJenkins5 жыл бұрын
Best course of this type. Mike talks in English, no 'uhs' or 'ums', even pace.Very good teacher!
@s.daniel22595 жыл бұрын
Hello, I downloaded MySQL Workbench and I'm lost? It doesn't mesh with the steps he's saying.
@shinx66684 жыл бұрын
@@s.daniel2259 google it lol
@magneat2 жыл бұрын
2:29:30 Instead of running 10 lines 1 by one inserting data and clicking 10 times 'run', just do them all with a single run: INSERT INTO test_1 VALUES(24, 'B', '1990-12-07'), (25, 'C', '1990-12-08');
@saurabhkathole60272 жыл бұрын
I am getting error while executing the code @2:29:07. Can you please help. I am getting duplicate error
@jonwinder18614 жыл бұрын
I am getting training on SQL for my job. This guy is a lifesaver
@mohammedahtesham20214 жыл бұрын
Basic hardware requirement for MySQL in windows ? How much ram is needed ?
@scythepapa8877Ай бұрын
i love how he used the office characters as examples making it easier for me to keep track with whats going on given that its my fave show