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.
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!
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?
@@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
@@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
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.
(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
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?
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.
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 🙏🏾
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.
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
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.
Some of this UA-camrs 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.
@@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
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!
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!
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.
@@cibelless510 Thanks for the encouragement. Successfully completed the SQL tutorial. Finally understood how the join syntax can be written and how it works. -Cheers
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:2453: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;
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!
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
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.
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!
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
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!
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.
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. 🙏🍾🎉
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!
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 !
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 🙏
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*
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.
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.
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
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 UA-cam 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!
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?
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.
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.
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.
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.
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!
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);
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.
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.
Of course, a lot of comments have heaped praised upon this video and it completely deserves it. It has condensed the database course I took in university into a 4 hour course that is really easy to follow along. Mike makes it quite engaging with his style of delivery. As a couple of others have also pointed out, Mike used the data from the Office to populate the different tables in the database, which was a nice touch. Thanks a lot for this course, I'm glad I found it and could use it to refresh my knowledge of the concepts.
@@mukhammed_kaldybai the of course at the start of the first sentence was likely misleading, thanks for pointing it out. But it also seems as though you've gotten used to reading negative comments on UA-cam. I know where you're coming from 😂
i had my teacher teaching dbms for 6 months and i gained nothing out of it however i do wanted to learn about Sql and i landed to this video.......this is one of the best video it teaches you from basic to intermediate it is sufficient enough to clear an interview thank you mike :))
@@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.
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!
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.
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
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
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 ?
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.
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
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.
@@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.
Thank you so much. 4 hours is worth spending on this video for anyone planning to learn SQL. This is one of the best videos on UA-cam for SQL learners. Again, thank you so much Mike for all your easy-to-understand explanation and great design of course.
Just finished this video today 20/11/24 and i feel so informed. Im going to get a certification and definately adding this skill in my CV.. thanks Mike♥
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.
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!
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.
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!
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
Wonderful tutorial covering all the basic concepts of SQL. Completed it in 2.5 days.. If you are more focused, probably u can complete it much quicker. He exactly knows where students may get confused with certain topics and he repeats it twice/thrice. Thats the good part. 😊👍👍👍
@@perseusgaming7397 The keyword "describe" only shows the different attribute of the columns of your table such as if a specific column have a default value or not, its data type, unique or not, not null or not, etc. Whereas "select" provide a variety of function, mainly used in showing the "rows" of your table.
I was going through youtube vides/playlist, udemy course and articles on learning SQL and I landed up on this wonderful video covering concepts in great length. Excellent video and superb effort!
I've graduated with a degree in MIS which they taught us SQL but this man is showing me how 4 hours = 2 semesters worth of bs learning. I am watching this video to prep for an application consultant interview Thursday. Great refresher and way better at simplifying information.
@@AsansChannel I’m teaching myself SQL rn. I don’t have any experience in programming tho. But thank you brother, I will look into these languages too. 👍
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.
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!
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.
I totally love it! I have had no programming classes or any other close-to-SQL-excersices and I was able to understand everything. Thanks for this material!
I randomly landed on this video was just searching what is sql in general and now its been 1hr to the video and i am too hooked ❤ mad respect for this guy, btw i am into HR 😅great video for someone who knows nothing like me🥰
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);
Click the "JOIN" button below the video to support freeCodeCamp.org!
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.
himanshu keshtwal depends how you’d like to use the column for , it’s just pure logic
is there a 2020 one for this???
@@kethankoz6910 yes
@@himanshukeshtwal4658 where there are more than 1 primary keys clubed together it is k/a:composite key.
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!
how long did it took you to become database developer after accountant? THankyou
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?
@@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
@@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
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
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?????
Welcome to the World Wide Web, my friend.
The want pdf + exercises AND tutoring *FOR FREE* 😂 -- i know the type (lazy/ungrateful)
Brother,... God just simply didn't make HELL.. He knew - there is one in every household that manages to ruins the special occasions...
May be they are of different UA-cam channel guy's
Colleges and university WORKERS
my man sat down for 4 hours and 20 minutes and just talked about databases the whole time, god level
Yeah ik but 4 20 tho
He's great with explaining things
hemorhoids are developing 🤣
@Vishal Sharma Yeah but tshirt, beard and hair all look exactly the same all the way through, I reckon he recorded it all in one go!
@@Justfun-xx6xe lmao
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.
Mam,how did you manage finishing it in straight 4 hours one day/didn't you have to pause and practice yourself?I
@@bt78646because she's lying
I need a recording memory like you, it's almost a week and still not finished 😂😂😂
how long did your kid sleep?
(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
Thanks for helping mobile users
Brilliant mate , thank you.
❤🤛🇧🇩
😂🇧🇷👌
Thanks mate
This was the only lesson of SQL I have ever taken and I managed to get a job as a Junior Data analyst! Thanks
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?
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
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.
4hrs get u a job. I don't believe
@@tarunrana716 for sql he studied only this, but you also need other skills
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.
Are u a bot or real human
@@asurachampion2881 why would he be a bot??
@@Alex_frost1994 that comment is a template
@@afiffadillah3862 oh okay i didn't know
@@Alex_frost1994 I'm not a bot 😅
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.
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 🙏🏾
That is very, thank you !
❤️❤️🙏🙏
Amen!
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.
Thank you, same for you:)
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.
Should i study this video or watch more recently posted tutorials?
@@suprheasingh what's the problem that you are facing ?
Hi bot
Congrats 👏 so you got job in database field?
@@vivekkoul4428 yes.
This man is going to heaven on a first-class seat.
Phle maar de ya tu
:D dude
xD
He will live forever.
uuuuuh, anyone else getting 9/11 vibes?
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
What is another resource if I finished this video?
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.
Conctact me 😢
Thanks! Awesome instructor & format! I’m very impressed young man. Keep us the good work.
Some of this UA-camrs 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.
yeah really !!!
Im doing this weeks before my in house bootcamp bc i know it'll be 10× better in 10x less time
This is why college degrees are obsolete regarding creating a useful and skilled professional.
@@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
@@thomasjones9559 I'm sure efficiency can be learned without spending 30k
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!
how did your interview go ?
hey did this video help clearing the interview?
print('Congratulations brother")
Well done, congrats on the new job!
Congrats! I’m doing the same thing for my interview tomorrow.
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!
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.
Kudos to you for learning even during 64
@@justanotherslaveofallah1622 Thank you Sir.
You are the master...and 64 is nothing ..just a number..remember that..success for you
@@cibelless510 Thanks for the encouragement. Successfully completed the SQL tutorial. Finally understood how the join syntax can be written and how it works. -Cheers
Keep learning sir , even you are a big inspiration for we youngsters 🙏
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;
arigato senpai!
bdsm>
?
how is desribe student different from select *from student ?
@@perseusgaming7397 describe returns the info of the table(data types, null values) while select * from student returns the content of the table.
@@michaelcrowell9091 Same to you all too :)
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!
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
Hi , how can I get to python class ?? I need the video please
@@reemabdullah1417 ua-cam.com/video/rfscVS0vtbw/v-deo.html
Agree
Pearls and Swine die
Thanks for the SQL class! It's super helpful to me! ☺
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.
Could you share your notes?
please share your notes.
I have a interview tomorrow
Hey will you please share your notes
If you could share your notes that'd be a great help for everyone
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!
Right???😩
hahahahahah I was looking for a comment that mentioned this, lol!
yessss
Ikr
I was just gonna comment this but you already did it
I like how this guy sits, leans and relaxes like a king
Defaq
Because he is 😎
Haha 😀
lol
And still explaining to us really well 😂💕
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!
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
Hello brother can you help me in sql
And where should I continue my study from here?
@@timothynaini8404
The documentation
@@vijayyadav8806 what kind of help you require ?
@@timothynaini8404 You can pick the topics and start practicing from w3school or Install any RDBMS in your local machine
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!
same here
oh i can't download popsql :((( may someone help me ?
@@longthanhvu8415 what happen ?
definitely
Nyways to delve deeper?
May be a part 2 or advanced sql????
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
thanks🙏
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.
hey just curious, was this video really helpful like even for attending interviews??
@@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.
Realized after watching that this stuff isn't actually hard... it was just never explained well! Thank you Mike!
Not explained in human language
You can say that about most 'difficult' things
Yeah i'm thinking the same
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. 🙏🍾🎉
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 :(((
@@myJourney.20s just google iy
@@myJourney.20s she's a girl not a guy 😅
4h20m without ads! Humanity still exists.
420 blaze it
and he explained much better than my teachers, it's like this lad is sent by God to help with the exams
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
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.
HuddyD UA-cam will collapse with this video
it took me 2 days just to finish this amazing tutorial guys and it's way too helpful, keep it up, you can do it!! ❤
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
Have a like, sir
Thank you so much for this
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
thanks boss
Thank you
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!
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 :)
@@mukhammadmuratov5715 thought the same..lol
Even I didn't notice that untill he started inserting data..and all of sudden I noticed familiar names Micahel, Jim, Kelly ..lol
I liked the part where he played it cool by saying "maybe the work with paper products." Lol
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
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 !
Seriously is that a separate subject for one whole semester??I am from non CS background so just wondering!!!
@@makeitbig36 yup for me I whole sem is for sql and database
Pls help me that did i need lap top for learning this course or mobile is enough
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 🙏
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.
How long did it take you
hey is there any way to download the pdf of the lesson?
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*
Hey! Are you currently working as developer?
@@jonlima9897 no, I'm not in tech, just learning stuff for my pleasure and career prospects
@@digitalsmartguide5672I'm male #2. I'm going to fight you now.
cant find him in linkedin. can you provide his linkedin id please.
Please send me your PopSql file, I could not download it
Excellent course. I am teaching myself SQL and I couldn't find a better course. Thank you so much
Do you have an opinion on the Khan Academy course?
How is Cameroon tonight Mr. Ebwele?
Just want to show my appreciation to the creator of this course. Best 4 hours of my learning slot. Keep up the good work!
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.
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.
Could u help me to develop skill
This guy is insane, he knows every language
i learned c from him
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
Maciej Błędkowski once we understand algorithms, we can pick any language and do quite well with google (mainly Stack Overflow)
Yas😰💥🔥
Does he know Chinese 😂
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 UA-cam 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!
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?
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.
yessir
@@SurajAmbre-vz4vg i would suggest taking screenshot
@@DimitrisKoutrakis 15M*
16*
this video helped me crack a job interview at TATA consultancy services. thank you so much
Congratulations my dear friend and Work hard, you have a great future ahead.
Congratulations bro
Congrats Rashid....
Bhai me to de nhi paya 60% k wjah se
hii rashid khan, can you please help me, I'm also preparing for interview of TCS
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.
Great course for beginners. Did it in 1 day. Sat down at 1pm and finished at 9:30pm.
Does it cover everything from SQL?
Till the intermediate level atleast?
@@aayushitrivedi3481 after 2 hours u will have all the basics
⭐️ 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
Thanks for saving my time.
Thanks a lot for your excellent work. Really amazing.
The contents are already in the description btw...
We appreciate these clickable timestamps.
Man, i was about to wait 52 minutes for the Windows install. Thanks.
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.
@harshitha keshav I have zero knowledge of SQL so should I follow this one as I want to learn SQL for my campus placements.
Will he covered all the concepts in Sql ? anything will be there to study other than this?
Where should I go from here,can you help me mate???
#eazzylearninglab fallow us
Is he teaching SQL or MySQL??
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.
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!
But I have a problem in here, where is Dwight Schrute???
I was looking for this comment. Thank you
@@furkanyakkan1529 he was executed on multiple counts of identity theft.
@@furkanyakkan1529 I guess he was busy irritating Jim Halpert with his antics.
Happy to see a fellow fan of the show 😀
This dude really just explained the lore of the Office using tables, what a legend
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);
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!
yeah I wish university teachers were half as good as this. they overcomplicate simple concepts.
Bucky. This guy was my first online tutor during my undergrad days. I'm definitely sure I'm gonna love this video
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.
Agreed!
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.
ua-cam.com/video/SiXbDxHdWcU/v-deo.html
Did u get job
how did your interview go.
Hey .....did you get the job??
Of course, a lot of comments have heaped praised upon this video and it completely deserves it. It has condensed the database course I took in university into a 4 hour course that is really easy to follow along. Mike makes it quite engaging with his style of delivery. As a couple of others have also pointed out, Mike used the data from the Office to populate the different tables in the database, which was a nice touch. Thanks a lot for this course, I'm glad I found it and could use it to refresh my knowledge of the concepts.
You started your comm as if you were to say something bad...
@@mukhammed_kaldybai the of course at the start of the first sentence was likely misleading, thanks for pointing it out. But it also seems as though you've gotten used to reading negative comments on UA-cam. I know where you're coming from 😂
i had my teacher teaching dbms for 6 months and i gained nothing out of it however i do wanted to learn about Sql and i landed to this video.......this is one of the best video it teaches you from basic to intermediate it is sufficient enough to clear an interview thank you mike :))
He is just explaining perfectly , literally not getting bored
He wasted no time and very concise that's why it's not boring
man this guy looks so chill and he knows almost every programming language 😱
Not a big deal
Almost all software Engineer at top MNC know most. Of the languages
@@Varuns36 but this guy is so young
Hello，how can I understand ‘he looks chill’.I am Chinese
@@sandersnolan6895 chill means relaxed
not really
This helped me land a junior level job in swe don’t ask how I didn’t learn sql throughout a whole cs degree
I didnt either xd
same
@@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.
@@rickeyjones729 i was referring what he has written in Last I'm currently watching mosh hamdanis MySQL course
@@rickeyjones729 do you know any programming language?
I can't believed someone managed to wrap SQL and ERD in 4 hours long video, you're a king! Thank you very much!
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!
Great course. Love the idea of having Michael Scott and Co in the examples. You deserve a Dundie Award.
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.
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
The way you demystify things is truly amazing. You're a great teacher
Dude seriously your tutorials are GOLD!Especially for people who are just lost thinking where to start or learn programming from!!THANK YOU!!
best lecture on dbms. This guy has whole computer database hidden in him.Lots of love❤❤
I cannot regret spending my precious time watching and practicing with the tutor. I now describe myself as a data analyst. Thank you.
👍
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
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 ?
@@rojjst differ a little
1:11:05 - How to log into MySQL (mysql -u root -p)
1:11:26 - Hot to create a database (create database ;)
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.
@@nonam2692 yeah it worth it. Then you can also check out Alex The Analyst
@@nonam2692 go for it
My greatest appreciation for the teacher in the vid and all of the people behind the scene who helped create this masterpiece!
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
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.
@@Turco949 You could watch it in small segments by yourself tho
@@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.
I am a beginner can anyone tell me ! Do this video covers all topics ?
@@vengalrao5772 almost all
Perfect course for SQL beginners, thank you for the hard work, Mike!
Thank you so much. 4 hours is worth spending on this video for anyone planning to learn SQL. This is one of the best videos on UA-cam for SQL learners. Again, thank you so much Mike for all your easy-to-understand explanation and great design of course.
Just finished this video today 20/11/24 and i feel so informed. Im going to get a certification and definately adding this skill in my CV.. thanks Mike♥
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.
and how are your job!?
You have taught me more programming than my college ever did in those 4 yrs !!
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!
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.
thanks
Please Pin this comment😁
Good job for pointing it out, thank you
maybe that's the reason why i'm getting this "permission denied for schema public" error.. will update mine.. followed his version..
Thanks!
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!
Using data from "The Office" made the course waaaaaay more fun, thank you :p
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
Thank you!
Thank you so much 💯💯
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?
Wonderful tutorial covering all the basic concepts of SQL. Completed it in 2.5 days.. If you are more focused, probably u can complete it much quicker. He exactly knows where students may get confused with certain topics and he repeats it twice/thrice. Thats the good part. 😊👍👍👍
completed in 1 day with 1.25x speed 🤓 now my head is on fire 🙈🙈
Completed it in 4 hrs and 20 mins. I just watched it hahahaha
how is desribe student different from select *from student ?
@@perseusgaming7397 The keyword "describe" only shows the different attribute of the columns of your table such as if a specific column have a default value or not, its data type, unique or not, not null or not, etc. Whereas "select" provide a variety of function, mainly used in showing the "rows" of your table.
I was going through youtube vides/playlist, udemy course and articles on learning SQL and I landed up on this wonderful video covering concepts in great length. Excellent video and superb effort!
I've graduated with a degree in MIS which they taught us SQL but this man is showing me how 4 hours = 2 semesters worth of bs learning. I am watching this video to prep for an application consultant interview Thursday. Great refresher and way better at simplifying information.
Were you able to build something on your own(like a project)from this lesson?
What other languages and skills did you learn during your MIS degree. I am starting mine next year.
@@toxicmaniax5719 c# JavaScript html css
@@toxicmaniax5719 and SQL which I watched UA-cam for cuz the professor sucked
@@AsansChannel I’m teaching myself SQL rn. I don’t have any experience in programming tho. But thank you brother, I will look into these languages too. 👍
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.
Using the "The Office" scene as an example is pure genius.. it is just perfect for this tutorial!
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!
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.
Wish you better luck
Best course of this type. Mike talks in English, no 'uhs' or 'ums', even pace.Very good teacher!
Hello, I downloaded MySQL Workbench and I'm lost? It doesn't mesh with the steps he's saying.
@@s.daniel2259 google it lol
I´m Spanish and you´re helping me to practise English as well as learning about SQL, because of your good pronunciation. Thank you.
A friend my mine recommended this tutorial. I'd surely be recommending it onwards to anyone who wants to learn SQL.
I am getting training on SQL for my job. This guy is a lifesaver
Basic hardware requirement for MySQL in windows ? How much ram is needed ?
You're more informative and effective than any of my college professors who taught this. Thanks for the free knowledge
I totally love it! I have had no programming classes or any other close-to-SQL-excersices and I was able to understand everything. Thanks for this material!
I randomly landed on this video was just searching what is sql in general and now its been 1hr to the video and i am too hooked ❤ mad respect for this guy, btw i am into HR 😅great video for someone who knows nothing like me🥰
He's such an amazing instructor. I learned Ruby in two days with 4hrs course.
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);
Basic hardware requirement for MySQL in windows ? How much ram is needed ?
hjjjjjjjjjjjjj