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