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 – https://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: http://popsql.com/freecodecamp
🔗Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/
⭐️ 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 YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw
🐦Follow Mike on Twitter: http://twitter.com/mike_dane
🔗The Giraffe Academy website: http://www.giraffeacademy.com/
—
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://medium.freecodecamp.org
source
Click the "JOIN" button below the video to support freeCodeCamp.org!
Thanks a ton, In just 2 days I did half the course. God bless you for making this course!
Is this tutorial better for a complete beginner than the other SQL tutorial; link here: (https://www.youtube.com/watch?v=ER8oKX5myE0&t=236s) ?
Triggers are much complex to understand…….
akka hi akka
Popsql changed, and as of now, I can't see how to connect it to my own database
the video is ok, but when you make mistakes dont cut them and instead resolve them in the video because debugging is also a cool way to learn sql and how things connect with eachother
Like at 2:59:14 you kinda fucked up but you cut the video badly and I personally dont know what was wrong there…the code was same so what went wrong ?
Is this also applicable for windows? I see that you are using Linux
Anybody Using Vscode on a mac to connect SQL DB that can help me
I cannot express how much I've learnt in 30mins alone. Thank you so much 💓
43min
great! and a shorter version SQL in an hour https://www.youtube.com/watch?v=gwp3dJUsy5g&t=2745s
where I can download mySQL for MacBook Air 2013 .it shows on windows but I can't find it for iOS
I will be grateful for your help
Which laptop is enough to learn sql, python, power bi, R, Tableau?
Budget? 🤔 😒😞
1:19:55
1:19
can anyone help me, like i m not getting same popsql as shown in the videos. and its not showing to connect database at the begining. ????
Love how you've set Kevin's Salary to $69000. He would be happy if he followed this tutorial lol
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 🙏🏾
getting this error , what does it mean : Error: permission denied for schema public LINE 1: …e297ab0-0f3e-11ed-977c-7bf63262527d*/ CREATE TABLE student (
1:28:50
oorrr…. the whole download & log in fiasco is all set up by the company 😀 no?
that category on gender didn't age well
Putting characters of The Office is a creative way to make us pay attention 😂
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. 🙏🍾🎉
Python interview questions with explanations https://youtu.be/AXiP-dYb7SU?sub_confirmation=1
I missed my database class in university and when my teacher gave project with a very short deadline I was at a loss. I started watching the video with a hope and it was like a blessing. I created a beautiful database and got one of the highest scores in my class. Thanks sir for teaching this concept beautifully for free.
This video saved my grade
thank you so much!!
The only thing I didn't liked about this course was : He didn't included Dwight Schrute anywhere 🙁
david deserved the highest salary
POPSQL shows me an error regarding about "permission denied for schema public line 1 " does anyone knows how to solve it?
1:35:42
This guy is damn good. My instructor’s tuition wasn’t clear and this guy just took me to a level way higher in the positive direction. He’s a genius.
finished!
(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 this tutorial. Very well explained!