59 Replies to “SQL Tutorial – Full course for beginners

  1. Thanks, Mile for this awesome video. I am a non-technical person as a QA manager and want to learn the concept of the database to upgrade my skill to test SQL. This video helps me a lot. One request can you please make the video for advance SQL queries.

  2. I'm going to take Database as a module for my second year at Uni and this video has been extreme helpful preparing for that so… thank you ever so much!

    I will be back at the end of the year to share how I do!

  3. If i go through this 4hour course will i be able to work with SQL in no time? or do i need to learn more and how long will it take to be Pro on this?

  4. at 2:52:40 ,
    select *
    from employee
    where birth_date like '__-02%';

    you can use '%02%'; to find the same information as '__-02%';

  5. ⭐️ 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

  6. Did anyone else notice during the nested queries section that the un-nested query for employees who sold more than $30,000 returned 4 emp_ids, but the nested query returned only 2 employees which doesnt accurately reflect the database info? Any ideas as to why that happened?

    Edit: My apologies, the un-nested query returned 2 emp_ids but one of those employess sold more than $30,000 to 3 different clients which put them as a result 3 times.

  7. When downloading the POPSQL APP , when connecting to the Database I get an Error at the end "UNKNOWN database 'giraffe'… anyone know why and how to fix this?

  8. Hi. Thank you for the course. Can you please share the PDF or A photo copy version of COMPANY DATABASE. It will be easy to understand by that way as that particular sheet isn’t clear on the screen while you teach. Thank you.

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

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

Leave a Reply

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