You are currently viewing SQL Tutorial – Full Database Course for Beginners

SQL Tutorial – Full Database Course for Beginners



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

This Post Has 44 Comments

  1. Devarati Roy

    You are a brilliant teacher for beginners without any basic know how of the concept.

  2. karan chalke

    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.

  3. irshad waheed

    i am a total newbie to SQL; will this tutorial help me to get started in SQL? Please answer anyone.

  4. Anusha C

    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.

  5. Arvind Raju

    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!!!!!!!!

  6. TheIhplodur

    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.

  7. Kashif Afridi

    Hi i'm a beginner and i want to know if we can make any colmn a primary key after a table is created?

  8. 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.

  9. Ariel

    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 🙁

  10. Akshat Rajput

    Do we need a prior knowledge of DBMS or anything else before learning SQL from this course?

  11. Marg M

    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!

  12. Well done, young man, this is a clearly presented, well-designed course that simply explained several complex concepts. Excellent stuff!

  13. SHAMEEM Fatma

    Why cant i connect my data base ? I did what you did and my first table run failed ? Why ?

  14. if you set speed to 1.25 making the course still digestible and 3 hours 15 minutes, roughly. Thanks dude!

  15. Anusha C

    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 ( ^

  16. ВВ 54

    "ALTER TABLE student ADD gpa DECIMAL(3, 2)" is not working for me in 2022. Smn pls help to solve the problem

  17. Uche Nwodo

    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(^

  18. Completing this video in 2 days.
    Got an interview in 6 days.
    I'll be back with the results.

  19. M K

    Thank you for sharing !

  20. Iza Pawlukowska

    I'm just like a kid, seeing database from the Office actually encouraged me to learn, good choice

  21. I haven't done that! Really? My log says otherwise… Pretty soon there's a lady walking a cute doggie at your house.

  22. Hank Rimb

    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… ^ "

  23. Apple Pie

    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.

  24. Sergio Celis

    In one word: Extraordinary, awesome. Thank you very much.

Leave a Reply