├── 01 Introduction
│ ├── 001 Introduction.mp4
│ ├── 002 What is SQL .mp4
│ ├── 003 What is MySQL How does it Differ from SQL .mp4
│ ├── 004 Installation in Mac , Windows and Linux Machines.mp4
│ ├── 005 Possible XAMPP Installation Problem.mp4
│ ├── 006 What is DB and Table .mp4
│ └── 007 How to create DB and Tables .mp4
├── 02 Inserts , Selects and Updates
│ ├── 001 add Data with INSERT.mp4
│ ├── 002 See Data with SELECT.mp4
│ ├── 003 LIMIT.mp4
│ ├── 004 conditions with WHERE clause.mp4
│ ├── 005 modify Data with Update.mp4
│ ├── 006 Table structure change with ALTER.mp4
│ ├── 007 AND as well as OR Clause.mp4
│ ├── 008 Sort result using ORDER BY Clause.mp4
│ ├── 009 IN Clause.mp4
│ ├── 010 Find Patterns in Data with LIKE Clause.mp4
│ ├── 011 Selecting specific Fields Columns.mp4
│ ├── 012 DISTINCT.mp4
│ └── 013 ALIAS.mp4
├── 03 MySQL Datatypes and Constraints
│ ├── 001 Datatypes.mp4
│ └── 002 Constraints.mp4
├── 04 JOINS and UNIONS
│ ├── 001 Creating base for Future Lectures.mp4
│ ├── 002 Relational Databases .mp4
│ ├── 003 What is a FOREIGN KEY Constraint .mp4
│ ├── 004 What are JOINS .mp4
│ ├── 005 LEFT JOIN.mp4
│ ├── 006 RIGHT JOIN.mp4
│ ├── 007 INNER JOIN.mp4
│ ├── 008 UNION.mp4
│ └── 009 Subquery .... Query inside another Query.mp4
├── 05 GROUPS and MySQL Functions
│ ├── 001 MySQL Functions.mp4
│ ├── 002 GROUP BY Clause.mp4
│ └── 003 HAVING Clause.mp4
├── 06 VIEWS
│ ├── 001 What are VIEWS and how to Create Them .mp4
│ └── 002 ALTER and DROP VIEWS.mp4
└── 07 DELETEs , DROPs and TRUNCATEs
├── 001 DELETE data from tables.mp4
├── 002 TRUNCATE Tables , DROP Tables and Database.mp4
└── 003 25 Sample Queries.pdf