~Get Your Files Here !

  1. Introduction and Installation

   1. Introduction to course.mp4

   2. The course goals.mp4

   3. The course requirements.mp4

   4. Who is this course for.mp4

   5. SQL quick intro.mp4

   6. Installing the working environment DB Manager.mp4

  2. The Basics of SQL Programming

   1. SQL syntax theory.mp4

   10. Insert data theory.mp4

   11. Insert data hands-on.mp4

   12. NULL OP Theory.mp4

   13. NULL and Not OP hands-on.mp4

   14. Updating data records theory.mp4

   15. Updating data records hands-on.mp4

   16. Deleting data theory.mp4

   17. Deleting data hands-on.mp4

   2. SELECT Statement theory.mp4

   3. SELECT Statement hands-on.mp4

   4. SELECT DISTINCT Theory.mp4

   5. SELECT DISTINCT hands-on.mp4

   6. WHERE Statement theory.mp4

   7. WHERE Statement hands-on.mp4

   8. Count rows theory.mp4

   9. Count rows hands-on.mp4

  3. SQL Operations and Data

   1. Operators IN - NOT IN theory.mp4

   2. Operators - IN and Not IN.mp4

   3. SQL Logical Operators theory.mp4

   4. Operators- Logical op hands-on.mp4

   5. Operators - Arithmetic op hands-on.mp4

   6. Operators - Comparisons hands-on.mp4

   7. Operators- SQL BETWEEN and NOT hands-on.mp4

   8. SQL Data Types.mp4

  4. Ordering and Limitations

   1. Ordering theory.mp4

   2. Ordering and sorting hands-on.mp4

   3. LIMIT with condition hands-on.mp4

  5. Powerful Functions and Aggregation

   1. Smallest and Largest Values hands-on.mp4

   2. Counting records with different ways hands-on.mp4

   3. Average of numeric columns hands-on.mp4

   4. Total sum for numerics hands-on.mp4

  6. Playing with DB tables and constraints

   1. Create DB and Tables hands-on.mp4

   2. Deleting newOrders hands-on.mp4

   3. ALTER ADD OR DELETE fields hands-on.mp4

   4. Renaming tables hands-on.mp4

   5. Constraints theory.mp4

   6. Constraints hands-on.mp4

  7. Working with and combining multiple tables

   1. Joining tables hands-on.mp4

   2. Combining result-sets hands-on.mp4

  8. Temporary names and conditions

   1. Power of Aliases hands-on.mp4

   2. Set conditions hands-on.mp4

  9. Exercise Apply the SQL Concepts

   1. About the exercise.mp4

   2. Exercise solution.mp4

   Exercise files

    Orders.csv

    Seller.db

    Sellers.csv

   Exercise-files.zip

  Bonus Resources.txt