SQL Tutorial - Full Database Course for Beginners
Рет қаралды 18,021,757
Күн бұрынIn this course, we'll be looking at database management basics and SQL using the MySQL RDBMS.
Want more from Mike? He's starting a coding RPG/Bootcamp - simulator.dev/
The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.
Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.
You can get PopSQL to follow along here: popsql.com/freecodecamp
🔗Company Database Code: www.giraffeacademy.com/databa...
⭐️ 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
Course developed by Mike Dane. Check out his KZfaq channel for more great programming courses: / @giraffeacademy
🐦Follow Mike on Twitter: / mike_dane
🔗The Giraffe Academy website: www.giraffeacademy.com/
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: medium.freecodecamp.org
@freecodecamp 4 жыл бұрын
Click the "JOIN" button below the video to support freeCodeCamp.org!
@himanshukeshtwal4658 4 жыл бұрын
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.
@Elemy921 4 жыл бұрын
himanshu keshtwal depends how you’d like to use the column for , it’s just pure logic
@kethankoz6910 4 жыл бұрын
is there a 2020 one for this???
@himanshukeshtwal4658 4 жыл бұрын
@@kethankoz6910 yes
@HarshitSingh-it7kp 4 жыл бұрын
@@himanshukeshtwal4658 where there are more than 1 primary keys clubed together it is k/a:composite key.
@afrozalam256 9 ай бұрын
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 9 ай бұрын
how long did it took you to become database developer after accountant? THankyou
@quadir6076 9 ай бұрын
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 9 ай бұрын
@@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 9 ай бұрын
@@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 8 ай бұрын
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
@amalpb1811 4 жыл бұрын
(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
@ajopasoij9d00 4 жыл бұрын
Thanks for helping mobile users
@markwilde5683 4 жыл бұрын
Brilliant mate , thank you.
@aggasht104 4 жыл бұрын
❤🤛🇧🇩
@wes6568 4 жыл бұрын
😂🇧🇷👌
@hitblank2320 4 жыл бұрын
Thanks mate
@katbarako 4 ай бұрын
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.
@bt78646 3 ай бұрын
Mam,how did you manage finishing it in straight 4 hours one day/didn't you have to pause and practice yourself?I
@Omer698 3 ай бұрын
@@bt78646because she's lying
@GigglesandChuckles777 2 ай бұрын
I need a recording memory like you, it's almost a week and still not finished 😂😂😂
@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.
@elitemartial1652 5 ай бұрын
How long did it take you
@meatbucket9626 5 жыл бұрын
my man sat down for 4 hours and 20 minutes and just talked about databases the whole time, god level
@Hustler_00 5 жыл бұрын
You know there are more then 100 cuts! Right? lol
@meatbucket9626 5 жыл бұрын
Yeah ik but 4 20 tho
@anakinskywalkerrr 5 жыл бұрын
He's great with explaining things
@Justfun-xx6xe 5 жыл бұрын
hemorhoids are developing 🤣
@lucienhughes8628 5 жыл бұрын
@@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!
@angiemakhubela Жыл бұрын
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 🙏🏾
@TeeJville10 Жыл бұрын
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:)
@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.
@allenc6609 11 ай бұрын
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!
@sahilpawarr 3 жыл бұрын
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?????
@tallitvak5325 3 жыл бұрын
Welcome to the World Wide Web, my friend.
@eddytheengineer 3 жыл бұрын
The want pdf + exercises AND tutoring *FOR FREE* 😂 -- i know the type (lazy/ungrateful)
@sulaimankhan8033 3 жыл бұрын
Brother,... God just simply didn't make HELL.. He knew - there is one in every household that manages to ruins the special occasions...
@mdsaddamkhan8400 3 жыл бұрын
May be they are of different KZfaq channel guy's
@nasirs5567 3 жыл бұрын
Colleges and university WORKERS
@lilnasd9193 2 жыл бұрын
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.
@asurachampion2881 2 жыл бұрын
Are u a bot or real human
@saansardar1215 2 жыл бұрын
@@asurachampion2881 why would he be a bot??
@afiffadillah3862 2 жыл бұрын
@@saansardar1215 that comment is a template
@saansardar1215 2 жыл бұрын
@@afiffadillah3862 oh okay i didn't know
@lilnasd9193 2 жыл бұрын
@@saansardar1215 I'm not a bot 😅
@jane_emilith 11 ай бұрын
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 11 ай бұрын
Hey! Are you currently working as developer?
@jane_emilith 11 ай бұрын
@@jonlima9897 no, I'm not in tech, just learning stuff for my pleasure and career prospects
@digitalsmartguide5672 10 ай бұрын
@@jane_emilithcan you marry me please, i got love at first sight with you seeing your profile ❤❤❤
@oldpain7625 10 ай бұрын
@@digitalsmartguide5672I'm male #2. I'm going to fight you now.
@kzisaeed93 9 ай бұрын
cant find him in linkedin. can you provide his linkedin id please.
@ZoldarMusic 2 жыл бұрын
This was the only lesson of SQL I have ever taken and I managed to get a job as a Junior Data analyst! Thanks
@fawadzia2909 2 жыл бұрын
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?
@im2879 2 жыл бұрын
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
@divyabksunar1986 2 жыл бұрын
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.
@tarunrana716 2 жыл бұрын
4hrs get u a job. I don't believe
@buggy_bug 2 жыл бұрын
@@tarunrana716 for sql he studied only this, but you also need other skills
@haiphan9181 3 жыл бұрын
This man is going to heaven on a first-class seat.
@shortscenes8961 3 жыл бұрын
Phle maar de ya tu
@ihsansabriyesilyurtstudent6099 3 жыл бұрын
:D dude
@shahriyarplayz8005 3 жыл бұрын
xD
@nandanraj3636 2 жыл бұрын
He will live forever.
@EJ-jh1vf 2 жыл бұрын
uuuuuh, anyone else getting 9/11 vibes?
@KaTe-bb2er Жыл бұрын
Thanks! Awesome instructor & format! I’m very impressed young man. Keep us the good work.
@light6230 10 ай бұрын
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!
@aniketbiswas9885 Жыл бұрын
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.
@audaciousintrovert69uwu37 Жыл бұрын
Should i study this video or watch more recently posted tutorials?
@rishabhsinghal3238 Жыл бұрын
@@suprheasingh what's the problem that you are facing ?
@poppyflorist Жыл бұрын
Hi bot
@vivekkoul4428 Жыл бұрын
Congrats 👏 so you got job in database field?
@aniketbiswas9885 Жыл бұрын
@@vivekkoul4428 yes.
@terrabyte-techy 4 жыл бұрын
Some of this KZfaqrs 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.
@aniketpatil2632 4 жыл бұрын
yeah really !!!
@thomasjones9559 4 жыл бұрын
Im doing this weeks before my in house bootcamp bc i know it'll be 10× better in 10x less time
@mustache2295 4 жыл бұрын
This is why college degrees are obsolete regarding creating a useful and skilled professional.
@thomasjones9559 4 жыл бұрын
@@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
@mustache2295 4 жыл бұрын
@@thomasjones9559 I'm sure efficiency can be learned without spending 30k
@bjmckenney54 11 ай бұрын
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
@mikoletz759 7 ай бұрын
Just want to show my appreciation to the creator of this course. Best 4 hours of my learning slot. Keep up the good work!
@rs6392 4 жыл бұрын
4h20m without ads! Humanity still exists.
@Kanal7Indonesia 4 жыл бұрын
420 blaze it
@xc6013 4 жыл бұрын
and he explained much better than my teachers, it's like this lad is sent by God to help with the exams
@bellamycat9800 4 жыл бұрын
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
@spartan2906 4 жыл бұрын
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.
@bellamycat9800 4 жыл бұрын
HuddyD KZfaq will collapse with this video
@aylinonay4123 3 жыл бұрын
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!
@rishabh2885 3 жыл бұрын
Right???😩
@ParthGoel201 2 жыл бұрын
hahahahahah I was looking for a comment that mentioned this, lol!
@ty-is5xv 2 жыл бұрын
yessss
@akshaysankar2318 2 жыл бұрын
Ikr
@mohdkaif864 2 жыл бұрын
I was just gonna comment this but you already did it
@astherieIIemercadejas 11 ай бұрын
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
@gautamphadnis7629 5 ай бұрын
thanks🙏
@prajwaltawade528 2 ай бұрын
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
@m00s3knuckl3 8 ай бұрын
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!
@wazka1234 5 жыл бұрын
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!
@bazzmx 5 жыл бұрын
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
@reemabdullah1417 5 жыл бұрын
Hi , how can I get to python class ?? I need the video please
@thyran 5 жыл бұрын
@@reemabdullah1417 kzfaq.info/get/bejne/qMyjlrmEldzYkqs.html
@carlosvaldez9281 4 жыл бұрын
Agree
@kayne3619 4 жыл бұрын
Pearls and Swine die
@kesavae9552 3 жыл бұрын
One day we all are gonna come back and tell this is where it all started ♥️
@MogalMauli 3 жыл бұрын
same here
@diabolus9466 3 жыл бұрын
Me right now.
@mauamadoudrammeh8083 3 жыл бұрын
for sure man
@syedsalahuddinquadri6149 3 жыл бұрын
Might be in future
@strangetoucane 3 жыл бұрын
Me 3
@liamevens6868 Жыл бұрын
Writing a final ISM exam next week and (same with python last year) this is my most recommended video! Thank you
@abdalrahmanalrefai8973 9 ай бұрын
I can't believed someone managed to wrap SQL and ERD in 4 hours long video, you're a king! Thank you very much!
@iben1195 2 жыл бұрын
I like how this guy sits, leans and relaxes like a king
@Atlas92936 2 жыл бұрын
Defaq
@csanadtemesvari9251 2 жыл бұрын
Because he is 😎
@MrDELL-cx3ck 2 жыл бұрын
Haha 😀
@sary6256 2 жыл бұрын
lol
@mayadaabuagla7924 2 жыл бұрын
And still explaining to us really well 😂💕
@Official-tk3nc 3 жыл бұрын
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
@heitornz 3 жыл бұрын
Have a like, sir
@ifedayoakintomiwa2302 3 жыл бұрын
Thank you so much for this
@lanasaifulaqil 3 жыл бұрын
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
@shreenidhhi8633 3 жыл бұрын
thanks boss
@natynt227 3 жыл бұрын
Thank you
@linhke3405 8 ай бұрын
My greatest appreciation for the teacher in the vid and all of the people behind the scene who helped create this masterpiece!
@sbarneaionut Жыл бұрын
Love the references to The Office. Just started the learning path as an Azure Data Cloud Engineer. I am 40 mins into this and already looks like the thing that can finally clarify some stuff for me in regards to SQL. I can only say, a massive well done :)
@MonikaSingh-ee6yv 8 ай бұрын
hi can you share the roadmap for azure data cloud
@anenzelapetrinite2998 4 ай бұрын
Was looking for this comment
@tonyarteaga5834 4 жыл бұрын
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!
@ayushpriyadarshi4049 4 жыл бұрын
how did your interview go ?
@sannidhirao1281 4 жыл бұрын
hey did this video help clearing the interview?
@NishantSingh-px3jm 4 жыл бұрын
print('Congratulations brother")
@cormano64 4 жыл бұрын
Well done, congrats on the new job!
@EliseoRocha 4 жыл бұрын
Congrats! I’m doing the same thing for my interview tomorrow.
@zerosandones701 4 жыл бұрын
Realized after watching that this stuff isn't actually hard... it was just never explained well! Thank you Mike!
@thomasjones9559 4 жыл бұрын
Not explained in human language
@mjxtacreaixe 4 жыл бұрын
You can say that about most 'difficult' things
@spbs-wb9wt 4 жыл бұрын
Yeah i'm thinking the same
@rodrigolomar6270 11 ай бұрын
Amazing course!! English is not my main language, and I was able to understand everything easily! The content is great, and even the order you chose to explain things was perfect. Really good! Thank you for this! 🙏
@realbenedictik 10 ай бұрын
Bucky. This guy was my first online tutor during my undergrad days. I'm definitely sure I'm gonna love this video
@lifeviz28568 2 жыл бұрын
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!
@sirazulhaqabdulmajid4903 2 жыл бұрын
same here
@longthanhvu8415 2 жыл бұрын
oh i can't download popsql :((( may someone help me ?
@nonameprivate4689 2 жыл бұрын
@@longthanhvu8415 what happen ?
@omer_sz 2 жыл бұрын
definitely
@bondnikunj 2 жыл бұрын
Nyways to delve deeper? May be a part 2 or advanced sql????
@jonsantos6056 2 жыл бұрын
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;
@nishanths1740 2 жыл бұрын
arigato senpai!
@valefarx Жыл бұрын
bdsm> ?
@perseusgaming7397 Жыл бұрын
how is desribe student different from select *from student ?
@rkpragyajitsingh3074 Жыл бұрын
@@perseusgaming7397 describe returns the info of the table(data types, null values) while select * from student returns the content of the table.
@jonsantos6056 Жыл бұрын
@@michaelcrowell9091 Same to you all too :)
@anastasisk Жыл бұрын
This guy's amazing! With him I learned C# and now SQL. He has contagion and great talent!!!
@kinsleynjikinsley2584 2 ай бұрын
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.
@freecodecamp 5 жыл бұрын
Want to know what to learn next? Check out this Database Design course: kzfaq.info/get/bejne/sNp4otN2mr3SoJc.html
@lephenix1387 5 жыл бұрын
please add automatic subtitle
@SirReginaldBumquistIII 3 ай бұрын
@@lephenix1387lmao cause that's a 5 minute job 🤤
@pirvuadriana-elena1915 Жыл бұрын
This guy is hands down the best professor of all time. Even a 5-year-old can understand this thing. :)
@ianoleson126 11 ай бұрын
Great video. Had no experience with SQL before watching, and I found this to be super informative and well-structured. Thanks!
@vijayswamy2564 4 жыл бұрын
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.
@justanotherslaveofallah1622 4 жыл бұрын
Kudos to you for learning even during 64
@vijayswamy2564 4 жыл бұрын
@@justanotherslaveofallah1622 Thank you Sir.
@cibelless510 4 жыл бұрын
You are the master...and 64 is nothing ..just a number..remember that..success for you
@vijayswamy2564 4 жыл бұрын
@@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_m5545 4 жыл бұрын
Keep learning sir , even you are a big inspiration for we youngsters 🙏
@PatientEbwele 5 жыл бұрын
Excellent course. I am teaching myself SQL and I couldn't find a better course. Thank you so much
@wm6549 5 жыл бұрын
Do you have an opinion on the Khan Academy course?
@Matthew-hh6ex 5 жыл бұрын
How is Cameroon tonight Mr. Ebwele?
@trishnashrestha5649 4 ай бұрын
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 :))
@Ajoi14 11 ай бұрын
I just wanna say thank you very much for this great introduction. I feel more confident going into Databases now and having a more understanding of it! Thanks a bunch Mike!
@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!
@Suhasmicheal 2 жыл бұрын
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.
@barebears289 2 жыл бұрын
Could you share your notes?
@mehediazad1780 2 жыл бұрын
please share your notes.
@bhuvanamuthyala2106 2 жыл бұрын
I have a interview tomorrow
@khushraouiux 2 жыл бұрын
Hey will you please share your notes
@thilinaavishka5084 2 жыл бұрын
If you could share your notes that'd be a great help for everyone
@shauryabhansali3731 Жыл бұрын
Thanks Mike for designing this course and helping all learn SQL!😊
@kiruthiaddressvb.natulmmau7010 Жыл бұрын
Such a broad minded person helping and giving knowledge of SQL ...hats off
@tharinda97 2 жыл бұрын
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!
@EngrLethA Жыл бұрын
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 😅
@LauritaBernardo-gf9di Жыл бұрын
Thank you!! Thank you for bringing this course to a beginner level and helping me build understanding. You're amazing!
@IkShenG Жыл бұрын
Thanks Mike! This was absolutely well put together and helpful. Good luck to those learning as well
@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?
@xrafter 4 ай бұрын
@@timothynaini8404 The documentation
@prajwaltawade528 2 ай бұрын
@@vijayyadav8806 what kind of help you require ?
@prajwaltawade528 2 ай бұрын
@@timothynaini8404 You can pick the topics and start practicing from w3school or Install any RDBMS in your local machine
@felixcsao4184 4 жыл бұрын
This dude really just explained the lore of the Office using tables, what a legend
@brandonbishop2670 3 жыл бұрын
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);
@aakash6651 9 ай бұрын
This is soo much beginner friendly. I have learnt a lot from this course . Mike has explained stuff in a great manner.
@goodluckythomas1093 9 ай бұрын
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 🙏
@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.
@shravanibalakrishnan5066 3 ай бұрын
Could u help me to develop skill
@user-qv5to1tl8b 4 жыл бұрын
This guy is insane, he knows every language
@tikitoka9026 4 жыл бұрын
i learned c from him
@mble 4 жыл бұрын
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
@rezhaadriantanuharja3389 4 жыл бұрын
Maciej Błędkowski once we understand algorithms, we can pick any language and do quite well with google (mainly Stack Overflow)
@vishnunetha8706 3 жыл бұрын
Yas😰💥🔥
@okaiee6911 3 жыл бұрын
Does he know Chinese 😂
@vrajeshbadgujar Жыл бұрын
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.
@purplesss_s 11 ай бұрын
Thank you! This comment saved me a lot of time
@jeancarlosinisterra9725 10 ай бұрын
this Man is fenomenal in his teaching methodologies. I took one day to watch this video and practice alongside him to grasp more about SQL and it really hit the nail with the information
@AngelaSMak 4 жыл бұрын
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 !
@akhilgupta1671 4 жыл бұрын
Seriously is that a separate subject for one whole semester??I am from non CS background so just wondering!!!
@aryaatanpure5380 3 жыл бұрын
@@akhilgupta1671 yup for me I whole sem is for sql and database
@girishsathuluri7950 3 жыл бұрын
Pls help me that did i need lap top for learning this course or mobile is enough
@agatakicia 4 жыл бұрын
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!
@davitpheikrishvili95 Жыл бұрын
Just finished. It took me a whole day and it was worth it. I know c# basics, pyhon basics and js basics. Now i understand how databases work too. I will probably learn ms-sql now and improve my c# skills to hopefully land a job in 3-4-5 months. Il keep yall updated. ps. even tho the video is old, it was totaly worth it. it was probably the best tutorial i have ever seen, and I have seen a lot. Good luck
@dylden4401 9 ай бұрын
So what happened now? Do you already have a job?
@nock5th Ай бұрын
Watched this video while getting my cs masters. Watched it again when starting my first SQL job. This has helped me so much
@jindammadhav2189 4 жыл бұрын
best lecture on dbms. This guy has whole computer database hidden in him.Lots of love❤❤
@vikramamin2853 Жыл бұрын
Just wanted to mention that you are doing a fabulous service to budding data analysts. The simplicity with which you explained all the concepts , queries is commendable. This video means a lot to me. Thanks and wish you the best!!!
@muhammadkaleemullah2389 3 ай бұрын
A friend my mine recommended this tutorial. I'd surely be recommending it onwards to anyone who wants to learn SQL.
@icermli 5 жыл бұрын
⭐️ 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_ymir 5 жыл бұрын
Thanks for saving my time.
@Imrankhan-xw4me 5 жыл бұрын
Thanks a lot for your excellent work. Really amazing.
@teckkers9295 5 жыл бұрын
The contents are already in the description btw...
@floodland80s 5 жыл бұрын
We appreciate these clickable timestamps.
@Gevito236 5 жыл бұрын
Man, i was about to wait 52 minutes for the Windows install. Thanks.
@harshithakeshav1199 2 жыл бұрын
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.
@kdslife69 2 жыл бұрын
@harshitha keshav I have zero knowledge of SQL so should I follow this one as I want to learn SQL for my campus placements.
@navyasrinivasan6689 2 жыл бұрын
Will he covered all the concepts in Sql ? anything will be there to study other than this?
@kingofkings6302 2 жыл бұрын
Where should I go from here,can you help me mate???
@aanaybhure7079 2 жыл бұрын
#eazzylearninglab fallow us
@kabita1536 2 жыл бұрын
Is he teaching SQL or MySQL??
@hugog.cintra2573 2 ай бұрын
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.
@abhishekm789 Жыл бұрын
I was fearful learning SQL but it seems easy with Mike.Great tutorial :)
@toughchic6377 5 жыл бұрын
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.
@aaditkamat4995 Жыл бұрын
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 9 ай бұрын
You started your comm as if you were to say something bad...
@aaditkamat4995 9 ай бұрын
@@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 KZfaq. I know where you're coming from 😂
@vishg.1533 11 ай бұрын
thank u so much for this entire session. amazing experience we got. far better than college lectures, it helps for internship, jobs and studies , I don't have any words to describe ur work man. thank u so much. appreciate ur work.
@usersll226 4 ай бұрын
This is a great video. Very clear, very structured. No commercials. Well done.
@TrungNguyen-jz5tj 2 жыл бұрын
Perfect course for SQL beginners, thank you for the hard work, Mike!
@wolfgangiii4719 5 жыл бұрын
this dude didn't even sweat typing 'po' in the browser
@smyasir0 5 жыл бұрын
haha
@thebailey__ 5 жыл бұрын
He uses incognito
@terimaaki1998 5 жыл бұрын
Must be PU MO.
@nikhilsethia2370 5 жыл бұрын
Don't you think the guy is Smart is enough to clear Browser History of Porn Searches before making this Tutorial..
@carolellamuch9571 5 жыл бұрын
NIKHIL SETHIA he doesn't watch porn
@karthikeyanradhakrishnan3219 3 ай бұрын
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!
@momain5483 11 ай бұрын
I was learning from a Udemy course but found it to not be as complete or beginner friendly as I wanted which left me discouraged and a little lost. This course is both of those things, I am learning so much better than I was with just Udemy alone, thank you so much for this video!!!
@iamrashidpathan 5 жыл бұрын
this video helped me crack a job interview at TATA consultancy services. thank you so much
@ayushpandey7 5 жыл бұрын
Congratulations my dear friend and Work hard, you have a great future ahead.
@techfortruth586 5 жыл бұрын
Congratulations bro
@abhinav9469 5 жыл бұрын
Congrats Rashid....
@raaghavsharma378 5 жыл бұрын
Bhai me to de nhi paya 60% k wjah se
@vikaskumarsingh3608 5 жыл бұрын
hii rashid khan, can you please help me, I'm also preparing for interview of TCS
@bnnm23 Жыл бұрын
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 KZfaq for SQL learners. Again, thank you so much Mike for all your easy-to-understand explanation and great design of course.
@henlyforbesly2176 4 ай бұрын
Thank you for 4 hours lessons on SQL. I know have more confidence in using SQL in my work! Especially the last part on how to create an ER Diagram and convert it into a database schema. I believe I will use that a lot one day! Thank you, The Girrafe Academy and FreeCodeCamp! ❤
@extropiantranshuman Жыл бұрын
I could imagine this person being able to crunch supercomputer-level databases to start their day. On fire - how easy these courses are for him to teach. I eat it all up - with these - I'm a pro in no time!
@bobbongx8785 Жыл бұрын
These videos have made me progress so much. I wanna give a big thanks to the whole community, course holders, as well as commentators. Through the comments my mind have opened to new ways to look upon things, and new way to abstract learning on. So again, big shout out to everybody for being educational awesome❤️
@wolei_sway 3 жыл бұрын
The way you demystify things is truly amazing. You're a great teacher
@tanishkshrivastava6822 Жыл бұрын
such a great tutorial loved it straight to the point no bs everything explained clearly
@amaljoy03 11 ай бұрын
For anyone using MySQL Workbench, Delimiter works in the Workbench itself, no need to use the command line. Really appreciate your effort man, thanks and love from India❤
@loganhepfner798 Жыл бұрын
Taking a class in university for my computer science degree and this is exactly everything’s we have covered so far, excluding some smaller topics. This is great material for anyone wanting to learn about this or prep for university/college
@user-km5lt9kg7p 3 жыл бұрын
man this guy looks so chill and he knows almost every programming language 😱
@varswe 3 жыл бұрын
Not a big deal Almost all software Engineer at top MNC know most. Of the languages
@carlosrg365 2 жыл бұрын
@@varswe but this guy is so young
@sandersnolan6895 2 жыл бұрын
Hello，how can I understand ‘he looks chill’.I am Chinese
@lukeberryarchive 2 жыл бұрын
@@sandersnolan6895 chill means relaxed
@beflames2479 2 жыл бұрын
not really
@user-li9vi1hw9d 6 ай бұрын
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!
@user-li9vi1hw9d 6 ай бұрын
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.
@shivakrishnan9206 6 ай бұрын
Wish you better luck
@syedmuhammadrafay228 11 ай бұрын
This guy is a gem. May Almighty Allah reward you for this.
@adityakiranhere 2 жыл бұрын
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. 😊👍👍👍
@cindy85 2 жыл бұрын
completed in 1 day with 1.25x speed 🤓 now my head is on fire 🙈🙈
@marcmarc1637 Жыл бұрын
Completed it in 4 hrs and 20 mins. I just watched it hahahaha
@perseusgaming7397 Жыл бұрын
how is desribe student different from select *from student ?
@ralphdanielhonra5966 Жыл бұрын
@@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.
@srikarreddy8252 4 жыл бұрын
Dude seriously your tutorials are GOLD!Especially for people who are just lost thinking where to start or learn programming from!!THANK YOU!!
@kennedymusyoki751 16 күн бұрын
I cannot regret spending my precious time watching and practicing with the tutor. I now describe myself as a data analyst. Thank you.
@sanazaheerzafar823 8 күн бұрын
👍
@lobster6899 Жыл бұрын
My guy you are the best teacher. You answer all of my questions and you do all the extra explanations and reminders
@roman_mf Жыл бұрын
I like Mike's pace, it's just right. You can tell the guy knows really his stuff. Great intro into databases. Works as good with PostgreSQL, except a couple of tiny differences. Thank you Mike for making it fun!
The Kiran Academy - Java By Kiran
Рет қаралды 540 М.
QAZSPORT TV / ҚАЗСПОРТ TV
Рет қаралды 193 М.
Oddly Satisfying
Рет қаралды 23 МЛН
QAZSPORT TV / ҚАЗСПОРТ TV
Рет қаралды 193 М.