WP Tutorials

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

source

Comments (49)

  1. Click the "JOIN" button below the video to support freeCodeCamp.org!

  2. Thanks. ✌🏻

  3. God bless you, Giraffe man😭🫶

  4. 3:11:00 welp, looks like using postgresql for this wasn't a bad idea after all lol.

  5. the best tutorial for SQL on whole youtube!!!

  6. Guys so where can I find a PDF with the database schema?

  7. Giraffe Man, you're a legend!

  8. I forgot to add "ON DELETE SET NULL". i dont know how to change the foreign key to have that. cant delete the table as well due to error "because it is referenced by a foreign key"

  9. I am having trouble with popsql, everytime I open it and click sign in with Google, it does nothing and I can't use it

  10. I couldnt connect popSQL to SQL server. cause the host name cannot be localhost. It says that I need a direct connection instead of cloud connection. However, I don't know how to make it work. Help please!

  11. Thank you Sir

  12. The best SQL for absolute beginners course on the internet THE BEST. I didn't even know what SQL was until this course.

  13. This course couldn't be any better structured and easiest way to get started for SQL. Thank you sir for your time and efforts.

  14. https://www.youtube.com/watch?v=HGLHHRIliOQ&t=51s

    For anyone getting error in establishing connection in POPSQL
    For Mac user click POPSQL in upper Pane > Settings > Connection and so on

  15. refer to this code mentor for SQL queries or wanted to learn from basics. https://chatgpt.com/g/g-2HUzVVQMb-code-mentor

  16. i really love everthing about u man no ads no boring stuff just sql the office agh love u

  17. using MySQL 8.4 , how does one load the ‘mysql_native_password’ plugin ? when trying to connect POPsql to MySQL my icon has a red dot indicating a failed connection with the comment above stating "Uh oh 🙁 Plugin 'mysql_native_password' is not loaded" , kindly requesting your guaidance on this hinderance i have encountered

  18. 00:00 SQL is a language used to interact with databases.
    06:03 Computers are great at storing large amounts of information.
    19:38 Relational databases use SQL, non-relational databases have their own query languages.
    25:57 Primary keys are used to uniquely identify rows in a table.
    38:32 Tables in a relational database can be simple or complex, with primary keys, foreign keys, and composite keys used to define relationships
    44:53 SQL is a powerful language used to communicate with relational database management systems.
    56:29 Install and set up MySQL database with password authentication
    1:01:16 Set up MySQL and a text editor
    1:11:48 Create a database named giraffe and connect it with PopSQL
    1:17:00 Different data types in SQL
    1:27:46 You can create, delete, modify and describe tables in a database.
    1:32:58 Learn how to insert data into a database table using SQL commands
    1:43:40 Control data stored on a table using primary keys and constraints
    1:49:06 Updating and deleting rows in a database table
    2:00:12 You can use the ORDER BY clause to sort the results in ascending or descending order based on different columns.
    2:05:26 You can use comparison operators and the IN keyword to filter and select specific information from a database.
    2:17:14 Create a complex database schema in SQL
    2:22:19 Foreign keys are added to the Employee, Client, Works With, and Branch Supplier tables to establish relationships
    2:32:48 Order data by name and sex
    2:38:00 Performing various aggregation functions on the employee database
    2:49:14 Using wildcards in SQL queries
    2:54:44 Combine employee names and branch names using UNION operator
    3:06:27 JOINs in SQL
    3:12:16 Nested queries can be used to retrieve specific information by combining data from multiple tables.
    3:24:25 ON DELETE SET NULL and ON DELETE CASCADE are useful in defining foreign key relationships between tables
    3:30:53 Create triggers in MySQL to automate actions
    3:41:44 ER diagrams are used to design database schemas and map out relationships between entities and attributes.
    3:47:12 Entity-relationship diagrams can be used to represent relationships, attributes, and cardinalities in a database schema
    3:58:58 Convert the given document into a database schema
    4:05:05 Entities and relationships
    4:17:25 Designing an ER diagram is a useful way to convert requirements into a database schema.

  19. Very useful video. Many thanks.

  20. Super easy to understand! Thank you! How can I get the powerpoint presentation?

  21. I watched this and I got a job

  22. Employee number is unlikely to be a true surrogate key. It's a sequential number assignment, and therefore it carries meaning about the seniority of the employee.

  23. thanks 🙌

  24. Absolutely clear and valuable course than I never find out there.

  25. Thank you so much

  26. WHAT'S WITH POPSQL….?!!!! 😩😩😩😩😩😩😩💀☠️

  27. Why MySQL was installed twice?

  28. Did SQL create Skynet?

  29. 3:30:44 / 4:20:38

    START TRIGGERS ON JUNE 11

  30. So crazy that Mike passed away 😖

  31. What is the purpose of the trigger test? Is that absolutely necessary for every database?

  32. great course!

  33. 39:10 So what if we have multiple entries with the same branch_id and supplier_name? That it suddenly wouldnt be a composite key anymore. Why wouldnt you just use something like a supplier_ID?

  34. At what point can I put SQL on my CV? How much experience/knowledge do recruiters and hiring managers expect? Let's say I do 20 hours of tutorial on youtube, can I already say that I know SQL?

  35. When you get an error in your queries, i think it would good to tell us what was the error or why you got that error, instead of cutting the video like nothing happened.

  36. Awesome video. Concentrated knowledge without any water.

  37. how to drop a column in a table

  38. 29:54 Wait a second are you telling me that Angela earns less than Andy? come on I mean she's the head of accounting.

  39. HOw to save and show img in database python tk

  40. Good video but I want to know why you didn't recommend something like MSQLworkbench for people who might have a problem connecting to the internet to use POPSql? I found the tutorial by Bro Code very helpful too. I could go through his tutorial without an internet connection once I downloaded his video. I couldn't do that with yours

  41. watched this video a couple years ago and it flew right over my head, this is Scranton branch hahahahaha

  42. Hahaha. An office reference

  43. thanks bro

  44. I keep getting a Failed response every time I try inputting data into the employee and branch tables. I'm putting in the exact same code but it keeps failing. Starting to get frustrated.

  45. did anyone notice the cut off parts where he gets errors ? xdddd

  46. I'm not able install MySQL on
    mac.. please help

Leave your thought here

Your email address will not be published. Required fields are marked *

Enable Notifications OK No thanks