Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
58 Lessons (5h 5m)
    • 1. Introduction to The Course

      4:17
    • 2. What is Relational Databases and MySQL

      2:38
    • 3. Install MySQL

      4:37
    • 4. MySQL Workbench

      5:02
    • 5. MySQL Database on Microsoft Azure

      10:04
    • 6. MySQL MySQL Database on AWS

      7:46
    • 7. Create and Drop Databases

      3:30
    • 8. Create Users

      11:36
    • 9. Exercise Create Database and User

      3:15
    • 10. Database Tables

      15:37
    • 11. Data Types

      8:12
    • 12. Primary Keys

      6:37
    • 13. Constraints

      8:04
    • 14. Exercise Create Tables Employees and Jobs

      9:02
    • 15. Foreign Keys

      13:23
    • 16. Exercise Create Tables Previous Experience

      5:27
    • 17. Create table using Table Data Import Wizard

      2:15
    • 18. Import Data Into Database

      5:19
    • 19. Exercise Import Data (Employees and Cities)

      2:39
    • 20. Exercise Primary and Foreign Keys For Status Table

      2:21
    • 21. Export Data out of Database

      1:47
    • 22. Entity Relationship Diagram (ERD)

      4:07
    • 23. Select Statement

      4:58
    • 24. Exercise Select Statement

      1:56
    • 25. Where

      9:12
    • 26. Exercise Where

      1:20
    • 27. Order by

      4:07
    • 28. Exercise Order By

      2:00
    • 29. Exercise And or

      3:00
    • 30. Like and Wildcards

      5:32
    • 31. Exercise Like and Wildcards

      2:01
    • 32. Distinct

      8:27
    • 33. In

      4:09
    • 34. Between

      1:24
    • 35. Exercise Between and In

      1:52
    • 36. Union

      8:27
    • 37. Case Statement

      10:03
    • 38. Exercise CASE Statement

      3:19
    • 39. Exercise Union Operator

      4:18
    • 40. EXISTS

      3:50
    • 41. Subquery

      8:22
    • 42. Exercise Subquery

      2:26
    • 43. Aggregate Functions Min and Max

      6:00
    • 44. Aggregate Functions Count

      6:36
    • 45. Exercise Create Table Budget with Some Queries

      6:14
    • 46. Aggregate Functions Avg and Sum

      3:55
    • 47. Group By

      7:44
    • 48. Having

      3:10
    • 49. Exercise Aggregate Functions

      2:48
    • 50. DML and DDL

      1:30
    • 51. Insert Into Statement

      9:29
    • 52. Exercise Insert Into Statement

      3:55
    • 53. Cloning a Table

      6:26
    • 54. Delete Statement

      5:26
    • 55. Update Statement

      7:39
    • 56. Exercise Update Statement

      1:57
    • 57. Exercise Update Status of Employees

      3:32
    • 58. Final Lecture

      0:36
22 students are watching this class

Project Description

We are going to create a collection of database objects like a real-world scenario: 

  • Database
  • Schema
  • User
  • Assign permission for user
  • Select statements
  • Advanced select statements
  • Build DML and DDL statements

Student Projects