Course Curriculum
Unit 01: Introduction | |||
Module 01-Introduction | 00:09:00 | ||
Module 02-Xampp (PHPmyadmin) installation | 00:05:00 | ||
Unit 02: Getting Started With Databases | |||
Module 01: Creating a database | 00:02:00 | ||
Module 02: Creating tables | 00:03:00 | ||
Module 03: More about tables | 00:01:00 | ||
Module 04: Inserting into tables | 00:03:00 | ||
Module 05: Updating and deleting | 00:04:00 | ||
Module 06: Data types | 00:03:00 | ||
Module 07: Conditional and comparison operators | 00:04:00 | ||
Unit 03: Constraints | |||
Module 01: Primary keys | 00:05:00 | ||
Module 02: Foreign keys | 00:07:00 | ||
Module 03: Indexes | 00:03:00 | ||
Module 04: Unique indexes | 00:03:00 | ||
Unit 04: SQL Functions | |||
Module 01: Functions part one | 00:02:00 | ||
Module 02: Functions part two | 00:03:00 | ||
Unit 05: SQL Clauses | |||
Module 01: Basic queries and where claueses | 00:04:00 | ||
Module 02: Order by | 00:03:00 | ||
Module 03: Distinct | 00:05:00 | ||
Module 04: In | 00:04:00 | ||
Module 05: Group by | 00:07:00 | ||
Unit 06: Alters | |||
Module 01: Alters part one | 00:03:00 | ||
Module 02: Alters part two | 00:05:00 | ||
Module 03: Alters part three | 00:05:00 | ||
Unit 07: All about Joins and SQL Relations | |||
Module 01: Aliases | 00:04:00 | ||
Module 02: Inner joins | 00:07:00 | ||
Module 03: Left and right joins | 00:06:00 | ||
Module 04: Unions | 00:06:00 | ||
Unit 08: Wild Cards | |||
Module 01: Wild cards part one | 00:07:00 | ||
Module 02: Wild cards part two | 00:05:00 | ||
Unit 09: More Advanced Areas of SQL | |||
Module 01: Views | 00:09:00 | ||
Module 02: Creating functions | 00:07:00 | ||
Module 03: Triggers | 00:09:00 |
Review
COURSE REVIEWS
Course Reviews
No Reviews found for this course.