Learn SQL in 6 days | John A. | Skillshare
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
47 Lessons (3h 29m)
    • 1. Introduction

      0:59
    • 2. Database

      3:44
    • 3. Data Types

      3:11
    • 4. Set of Tables

      3:20
    • 5. Schema

      8:01
    • 6. Drop Database

      1:53
    • 7. Primary and Foreign Key

      2:10
    • 8. Database Creation

      1:35
    • 9. Create Table

      4:23
    • 10. Create Foreign Key

      2:53
    • 11. Alter Table

      2:14
    • 12. Data Types

      3:15
    • 13. Tables

      1:15
    • 14. Show Database

      0:40
    • 15. Describe Table

      1:34
    • 16. Delete Table

      1:35
    • 17. Create Primary Key

      0:53
    • 18. Add Data to table

      10:50
    • 19. Setting up Database and Tables

      6:30
    • 20. WHERE Clause examples

      1:21
    • 21. WHERE Clause

      1:49
    • 22. Arithmetic Operators and Expressions

      2:08
    • 23. Comparison Operators and Simple Condition

      1:24
    • 24. Delete Table Data

      4:39
    • 25. Update Table Data

      8:17
    • 26. Logical Operators and Operator Precedence

      1:22
    • 27. Simple Select

      2:41
    • 28. Change Column Header

      2:21
    • 29. Select Specific Columns

      1:19
    • 30. Select Distinct Columns

      3:09
    • 31. Sorting the Data

      3:38
    • 32. Retrieve Data from Multiple Tables

      5:06
    • 33. String Functions

      22:54
    • 34. Mathematical Functions

      13:02
    • 35. Date Function

      8:01
    • 36. More Logical Operator

      7:09
    • 37. NULL Data

      2:07
    • 38. GROUP BY clause

      4:11
    • 39. GROUP Functions

      8:47
    • 40. HAVING clause

      4:35
    • 41. Sub-Queries in SELECT

      11:09
    • 42. Sub-Queries in WHERE

      10:06
    • 43. Sub-Queries in WHERE - ANY Operator

      4:31
    • 44. Sub-Queries in WHERE - ALL Operator

      4:53
    • 45. Sub-Queries using EXISTS Operator

      4:42
    • 46. Sub-Queries in INSERT

      1:59
    • 47. Conclusion

      0:37
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

6 of 8 students recommend this class
This class is great, especially if you're completely new to SQL, like I was. The instructor goes through codes, one at a time, explaining what they do. Then, best of all, he shows the codes as they'd be typed in SQL, revealing the final output. Couldn't recommend it enough!
Very well explained with examples in every video.