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:07:00 |
Assignment |
|
Assignment – SQL Training |
|
6 days, 19 hours |