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
And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
source
Click the "JOIN" button below the video to support freeCodeCamp.org!
https://www.youtube.com/channel/UCxb40bbdTHi1G-Y4lXnKHlA subscribe to this channel for leetcode sql questions
If you are just watching this recently, this is a video showing you how to connect popsql to mysql…..do it now…it will save you a lot of time
https://youtu.be/2vJ8kmNqq38 🙂
You are a brilliant teacher for beginners without any basic know how of the concept.
Thank you so much for teaching me my favourite topic with my favourite sitcom characters. Glued 4 hrs to the screen, just amazing my friend.
i am a total newbie to SQL; will this tutorial help me to get started in SQL? Please answer anyone.
Hi
In the employee table – branch id and super id will become composite key? Because both the colum together is unique and super id doesn't link to another table.
Great course. Thanks you.
Thanks!
To all those people who are getting the "permission denied for public schema error"
Go to "add new connection in POPSQL" and click on the "MySQL option"
The "connection name" and "database" should have the same name. The default connection name is mysql.
Hostname is "localhost" and port is "3306"
Give the username as "root" and enter the password that you have set earlier.
Then make sure that you have turned on the connect directly from my computer option.
and dont forget to save
HOPE THIS HELPS & ALL THE BEST!!!!!!!!
Oh for some people shopping lists have more information than you think. You can assume what the owner will eat, if the person is preparing for a fieldtrip.
Hi i'm a beginner and i want to know if we can make any colmn a primary key after a table is created?
On my end it says that the column doesn't match. Someone knows why the problem is? I've following him step by step and it gives me that error.
Good afternoon.
May someone please tell me the versions to use today for this course? The ones mentioned by Mike are not longer showing. PLEASE HELP 🙁
What can I install intead popsql? My notebook doesn't work with it.
Thanks!
Do we need a prior knowledge of DBMS or anything else before learning SQL from this course?
I've been watching this on the bus on my way to school for the past couple days- the ride takes well over half an hour.
Today was the last day I was required to attend high school.
I'm pursuing a cybersecurity degree in college. This video made me pull out my programming class notebook from 2019 and start writing down notes on SQL where the pandemic cut off my education in Java. Cheers!
Well done, young man, this is a clearly presented, well-designed course that simply explained several complex concepts. Excellent stuff!
Gracias , me fue muy util
Why cant i connect my data base ? I did what you did and my first table run failed ? Why ?
if you set speed to 1.25 making the course still digestible and 3 hours 15 minutes, roughly. Thanks dude!
thank you
i am getting an error message in POPsql , while writing a program – creating table. error message : permission denied for schema public LINE 1: …b4ee270-db41-11ec-863f-21bc15f3e1c9*/ CREATE TABLE student ( ^
21:45
"ALTER TABLE student ADD gpa DECIMAL(3, 2)" is not working for me in 2022. Smn pls help to solve the problem
Awesome explanation. Thank you very much.
Hi guys, i am trying to create the student table example used in this tutorial but I am running into an error " Permission denied for schema public Line 1:…741cad0-df27-11ec-aa6a-438d31ea0271*/create table student(^
Does this work for Data Science?
Completing this video in 2 days.
Got an interview in 6 days.
I'll be back with the results.
Thank you for sharing !
I refused to use a text editor to look like a hacker
I'm just like a kid, seeing database from the Office actually encouraged me to learn, good choice
I haven't done that! Really? My log says otherwise… Pretty soon there's a lady walking a cute doggie at your house.
I have a problem while running table student. The error message says "permission denied for schema public LINE 1: …1327370-dfb3-11ec-acee-5d05043944e7*/ CREATE TABLE student ( ^"
The other issue is about DESCRIBE. In this case the message is "syntax error at or near "DESCRIBE" LINE 1: …278,run_id:815dacb0-dfb4-11ec-acee-5d05043944e7*/ DESCRIBE s… ^ "
If you got stuck connecting your mySQL database in PopSQL, check your Connection Type is switched to connect directly from my computer, and your username is root, and your password is the same one you used to sign into mysql.
Very Useful course
In one word: Extraordinary, awesome. Thank you very much.
57:33
does anyone have notes
This is an Awesome Course
Pretty cool condensed course for beginners
how to save my table on POPSQL?
awesome how you explained it! Thanks a lot!