Section 1 : Introduction

lecture 1 Introduction to MySQL Server and Databases
lecture 2 Download and Install MySQL ServerandMySQLWorkbench

Section 2 : ManipulatingTablesandDataCRUD Operations

lecture 3 Connect and Create a Database 12:50
lecture 4 Drop or Remove Database 3:40
lecture 5 Create an SQL Database Table 22:59
lecture 6 Insert Data into the Table with SQL Script 8:50
lecture 7 Insert Data into the Table with Workbench 9:4
lecture 8 Select Datafrom the Table withSQLScript 8:9
lecture 9 Select Data with Filters 19:53
lecture 10 Update Data in the Table 8:33
lecture 11 Delete Data from the Table 10:20
lecture 12 Reverse EngineerDatabaseintoModel 6:54
lecture 13 Forward Engineer Data Model into Database 10:49

Section 3 : Relationships and Foreign Keys

lecture 15 Create Relationships with DataModelling 15:29
lecture 16 CreateRelationshipswithWorkbenchTableDesign Too 20:24
lecture 17 Insert Records in Related Tables 8:55
lecture 18 Run Queries on Related Tables (Inner Joins) 15:22
lecture 19 Left, Right and Cross Joins 7:8

Section 4 : Aggregate Functions

lecture 20 Grouping Data using SQL GROUP BY Clause 9:52
lecture 21 SQL AVG Aggregate Function 9:0
lecture 22 SQL COUNT Aggregate Function
lecture 23 SQL MIN & MAX Aggregate Functions
lecture 24 SQL SUM Aggregate Function
lecture 25 Splitting Groups using HAVING Clause 4:33