Internet forum aims to build trust
Hey everyone! Thanks for watching my course
Follow me on twitter at https://twitter.com/mike_dane
Hello everybody. Congratulations on this awesome course! Where can I find the pdf with the schema ? Thanks.
1.25 speed gang
I'm Italian and I was searching for some tutorials about SQL language.None of them could teach better than you 😉
Hey mike, thanks doing this. this is one of the best tutorial I have ever watched on YouTude.Thanks a lot and all the best with the career.
How do I obtain data from a company’s data base
Me after watching whole video at once: I know SQLMorpheus: show me
I've never seen such a good & simple explanation for subquieries before, awesome, big thanks !
Reference to Office made it lot easier 😆 That's what she said!Really cool 👍
Thanks man.!! Your tutorial helped me to brush up my complete SQL.
Am I the only one struggling to run mysql database server on the macbook pro??? Need help please 🙁
Thank you for this bro. It's the best SQL tutorial I've come across so far… Bless
Why do some column mentions require ( ) and some do not?
Thanks for not having any ads.That is very frustrating and distracting.Salute sir
Man this is awesome! I mean… like with this video I just l learned in 4 hours what I'm learning in a semester (BTW I'm latin american, my classes are in spanish. This video is so clear that I just understood more in 4 hours than what I had to learn in a whole semester). So nice video!
Is that c program important in now a days?Or Any software course is enough for getting a job?
You are just AMAZING. Thank you for share all of this with us!
Will there be another video for CTEs and Window Functions in SQL?
Neat explanation along with the office characters/references makes it more interesting!
Could anyone recommend a good free tutorial on python, perhaps by Mike D, and if not someone else you recommend?
Tried to download MySQL but it wouldn't download. What should I try?
at some point i got a ER_TABLE_EXISTS_ERROR and now that's all that comes up no matter what I do…
Fantastic SQL course! Organized and clear delivery. Really appreciate the table of contents. Can't thank you enough.
SUM stands for sum lol 🙂
** POPSQL IS PREMIUM NOW BUT DO NOT WORRY**You can still download for free and use one of the SCRATCHPAD for free.
speed x2 🙂
Can't get any of the constraints to work e.g NOT NULL or UNIQUE, It was going so well 😔
Can it be used for learning SQL for embedded SQL in AS400?
Question: why does some of the functions that appear colored as red on your PopSQL (like SUM or AVG) often appear to me with the other color of every other SQL text?
Hi, please teach normalization rules.
who needs sql when you have hashmaps lol
Hi Mike Giraffe, huge thanks for your excellent delivery of many useful videos! The best not only for newbies but also the complete reviews
The 2:39:27 date should have been 1970-12-31 or use >=. Just sayin'.
I'm beginning to suspect that this guy is a bot. I mean, how do you master everything?
Hi I cant connect to PopSQL . its showing in red status
You have done an excellent work mate !! well done !! very helpful and in great details, many thumbs-ups many thanks
Very detailed tutorial on SQL. Thanks so much!
Thanks for such an amazing course.
So… A non-relational database is… A database that is not relational? Did I get that right?
Drink every time he says "relational database(s)". Pro tip: Take small zips…
2:39:28 birth_date is reffered to as birth_day in the copied code
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
got this as a problem.any solutions?
I want to learn SQL from this course so what is the difference between My SQL and SQL? Please help me and guide me to the right way.
hey mike bro..i'm from india… your tutorials are so good…you are expressing it in a single video…i hope that this course made me to learn new skills and help me to crack interviews,. hats off to you
Wow! Great course. Many thanks Mike. Comprehensive and excellent presentation for one and all to understand (and enjoy!). Much appreciated!
The UPDATE query around 1:50:04 isnt running properly on PopSQL anymore, I get the message '0 rows affected'. Has the command changed since this video?
you are a really good instructor.. i will be checking out more. After i get thru this 4 hrs. Thanks for sharing.
You're quick to assume I have 5 friends I can list.
Now I have seen a real-time Superman. If I ever meet, I will take a selfie with you.
you are god thank u
That was helpful. How about Dwight tho?
Using data from "The Office" made the course waaaaaay more fun, thank you :p
Is it adequate practice in companies to use programs like popsequel? Are there any cons to it?
Damn, thank you, this guy really helped me, even without ads for 4 hours
Just finished the phyton course. This man is godly
hiwhenever i try to install mysql, I'm getting an error while adding root password. It shows cant connect to MySQL using this password. i tried all kind of passwords. nothing is working 🙁
great course my man!
I love the way this guy teaches! It is very very clear and every time he says Michael Scott( by brain says “ that is what she said”
vim pelo tinoco
Great. I am a career changer to IT and this tutorial is fantastic. Provides real good basic understanding on SQL
Best Database tutorial find on youtube.very helpful for beginners.
so useful thanks!
My database is not getting connected to the popsql… It shows error…Wat do I do..? Please help…
one of the finest tutorial videos I have ever seen. Done a great job!
This guy must've been a tutor
someone screwed up the English captions, they're completely blank
Just a friendly reminder to sanitize your inputs! 😀
Can you give me answer of following question
1.Write a PL/SQL block to find the maximum number between the three numbers using %type.
2.Write a PL/SQL block to check whether the given number is palindrome or not using %row type.
I'm getting error while writing code in popsql
Hey great tutorial. I just found a little inconsistency (no big deal) in the video and in the code.Should be select COUNT(emp_id) from employee where sex = 'F' and birth_day > '1970-01-01';not birth_date.
When I tried to add values to table works_with i keep getting the following error message "ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`giraffe`.`works_with`, CONSTRAINT `works_with_ibfk_1` FOREIGN KEY (`emp_id`) REFERENCES `employee` (`emp_id`) ON DELETE CASCADE)", does anyone know how to fix it?Thank you
how do u add the column in your desired postion. I added another column as u showed but it wasnt where i wanted it to be
Hi, thanks for lecture its good, do you have any excises for database so that we can do hands on?
1:41:45 is the Table student basically consisting a composite key right there? 😀
I just finished the course 10 minutes ago and it took about about 2 weeks to complete it all.
I have to say, I feel extremely grateful. The moment I left my pen finishing my notes as Mike closed the tutorial, felt amazing. I believe I built very strong foundation to take the next leap ahead. The course was great, it covered lots of details and if I still had a question, it was so small that a simple Google search or just experimenting was enough to solve it.
Now as Mike already said, it is a beginners course, which is fine. I feel more than ready to tackle more advanced stuff and I cannot wait to do so in the next few weeks. I feel ready to apply my new SQL knowledge in my favourite languages and take my game a step further.
I also saw that Mike has lots of other tutorials as well. Something tells me that I will learn more from him soon.Thank you so much for creating this course for free and for actually investing your valuable time to teach us.
31:32 Michael Scott school of Business SQL
did i put my degree in your hand ?yes
Thanks for making this video. 🙂
i just want to let you know that you are doing an awesome job , please keep doing it .thank you. 🙂
You haven't taught inner join and outer join 🙁 and i got failed in exam
where should i go from here ? any advices ?
All of my friends: Stop watching the Office all the time! It will never be useful in your lifeMe: understanding this tutorial
the syntax for mysql server 8.0 is differenet. I am not able to create a table.
ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5
2:52:14 for the month you can also use this (a month is always MM a year is always AAAA- and a day is always -DD ) to distinct the months from th days or the years
⭐️ 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
**Copied from video description
what alternative for popsql can I use, since it is not freeware now?
Hi,guys i have one question, i need to find last_names which contains 3 A which is best form to write this query?
I strongly suggest everyone to follow this tutorial .awesome tutorial..
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.