SQL Course For Beginners: Learn SQL Using MySQL Database

Course Curriculum

Chapter 1: Introduction to the course

Lecture 1: Introduction to the course

Chapter 2: Introduction to SQL and Databases

Lecture 1: What are databases and why do we need them

Lecture 2: Introduction To SQL

Chapter 3: Installing required softwares to get us started

Lecture 1: Installation steps for Windows users

Lecture 2: Installation steps for Mac users

Lecture 3: Installation steps for MAC

Lecture 4: Installation steps for Linux

Chapter 4: Database Creation & The Select Statement.

Lecture 1: Creating a new database

Lecture 2: Creating a table in database

Lecture 3: Inserting Data Into Table

Lecture 4: Using the SELECT clause

Lecture 5: Using the SELECT DISTINCT clause

Lecture 6: Using the WHERE clause

Lecture 7: True condition

Lecture 8: False condition

Lecture 9: Coding Challenge Part -1

Lecture 10: Coding Challenge Part-1 Solution

Lecture 11: Summary & Notes For Section 3

Chapter 5: SQL Operators

Lecture 1: SQL AND Operator

Lecture 2: SQL OR Operator

Lecture 3: SQL LIKE Operator

Lecture 4: SQL Between Operator

Lecture 5: SQL CONCAT Operator

Lecture 6: SQL Numeric Operator

Lecture 7: SQL Comparision Operator

Lecture 8: Coding Challenge Part-3

Lecture 9: Coding Challenge Part-3 Solution

Lecture 10: Summary & Notes For Section 4

Chapter 6: Insert, Update And Delete

Lecture 1: Inserting data using the Insert

Lecture 2: Insert into select statement

Lecture 3: Updating data using Update

Lecture 4: Deleting data using delete

Lecture 5: Coding Challenge Part-4

Lecture 6: Coding Challenge Part-4 Solution

Lecture 7: Summary & Notes For Section 5

Chapter 7: SQL Joins

Lecture 1: Introduction to Joins

Lecture 2: Inner Join

Lecture 3: Left Outer Join

Lecture 4: Right Outer Join

Lecture 5: Full Outer Join

Lecture 6: Cross Join

Lecture 7: Coding Challenge Part-5

Lecture 8: Coding Challenge Part-5 Solution

Lecture 9: Summary & Notes For Section 6

Chapter 8: Built In SQL Functions

Lecture 1: SQL AVG() Function

Lecture 2: SQL Count() Function

Lecture 3: SQL Min() Function

Lecture 4: SQL Max() Function

Lecture 5: SQL Sum() Function

Lecture 6: SQL Ucase() Function

Lecture 7: SQL Lcase() Function

Lecture 8: SQL Mid() Function

Lecture 9: SQL LEN() Function

Lecture 10: Coding Challenge Part-6

Lecture 11: Coding Challenge Part-6 Solution

Lecture 12: Summary & Notes For Section 7

Chapter 9: Constrains In SQL

Lecture 1: Constrains In SQL

Lecture 2: Not Null Constrain In SQL

Lecture 3: Unique Constrain In SQL

Lecture 4: Primary Key Constrain In SQL

Lecture 5: Foreign Key Constrain In SQL

Lecture 6: Foreign Key Example

Lecture 7: Default Constrain In SQL

Lecture 8: Auto Increment Constrain In SQL

Lecture 9: Summary & Notes For Section 8

Chapter 10: Practice Examples

Lecture 1: Practice Example Part 1

Lecture 2: Practice Example Part 1 Solution

Lecture 3: Practice Example Part 2

Lecture 4: Practice Example Part 2 Solution

Lecture 5: Practice Example Part 3

Lecture 6: Practice Example Part 3 Solution

Lecture 7: Practice Example Part 4

Lecture 8: Practice Example Part 4 Solution

Lecture 9: Practice Example Part 5

Lecture 10: Practice Example Part 5 Solution

Chapter 11: Conclusion

Lecture 1: Conclusion Lecture