Introduction to the course
  • Introduction to the course
Introduction to SQL and Databases
  • What are databases and why do we need them
  • Introduction To SQL
Installing required softwares to get us started
  • Installation steps for Windows users
  • Installation steps for Mac users
  • Installation steps for MAC
  • Installation steps for Linux
Database Creation & The Select Statement.
  • Creating a new database
  • Creating a table in database
  • Inserting Data Into Table
  • Using the SELECT clause
  • Using the SELECT DISTINCT clause
  • Using the WHERE clause
  • True condition
  • False condition
  • Quiz 1: Introduction To SQL
  • Coding Challenge Part -1
  • Coding Challenge Part-1 Solution
  • Summary & Notes For Section 3
SQL Operators
  • SQL AND Operator
  • SQL OR Operator
  • SQL LIKE Operator
  • SQL Between Operator
  • SQL CONCAT Operator
  • SQL Numeric Operator
  • SQL Comparision Operator
  • Quiz 2: Test What you have learned in this section
  • Coding Challenge Part-3
  • Coding Challenge Part-3 Solution
  • Summary & Notes For Section 4
Insert, Update And Delete
  • Inserting data using the Insert
  • Insert into select statement
  • Updating data using Update
  • Deleting data using delete
  • Quiz 3
  • Coding Challenge Part-4
  • Coding Challenge Part-4 Solution
  • Summary & Notes For Section 5
SQL Joins
  • Introduction to Joins
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Cross Join
  • Quiz 4
  • Coding Challenge Part-5
  • Coding Challenge Part-5 Solution
  • Summary & Notes For Section 6
Built In SQL Functions
  • SQL AVG() Function
  • SQL Count() Function
  • SQL Min() Function
  • SQL Max() Function
  • SQL Sum() Function
  • SQL Ucase() Function
  • SQL Lcase() Function
  • SQL Mid() Function
  • SQL LEN() Function
  • Quiz 5
  • Coding Challenge Part-6
  • Coding Challenge Part-6 Solution
  • Summary & Notes For Section 7
Constrains In SQL
  • Constrains In SQL
  • Not Null Constrain In SQL
  • Unique Constrain In SQL
  • Primary Key Constrain In SQL
  • Foreign Key Constrain In SQL
  • Foreign Key Example
  • Default Constrain In SQL
  • Auto Increment Constrain In SQL
  • Quiz 6
  • Summary & Notes For Section 8
Practice Examples
  • Practice Example Part 1
  • Practice Example Part 1 Solution
  • Practice Example Part 2
  • Practice Example Part 2 Solution
  • Practice Example Part 3
  • Practice Example Part 3 Solution
  • Practice Example Part 4
  • Practice Example Part 4 Solution
  • Practice Example Part 5
  • Practice Example Part 5 Solution
Conclusion
  • Conclusion Lecture