| Module 01: CSS Introduction |
|
Introduction |
|
00:03:00 |
|
How to ask a great questions |
|
00:01:00 |
|
Introduction CSS |
|
00:06:00 |
|
Choosing Code Editor |
|
00:03:00 |
|
Installing Code Editor (Sublime Text) |
|
00:04:00 |
|
CSS Syntax |
|
00:05:00 |
|
Creating a first page with CSS Style |
|
00:13:00 |
| Module 02: CSS Basic |
|
Inline CSS |
|
00:06:00 |
|
Internal CSS |
|
00:05:00 |
|
External CSS |
|
00:10:00 |
|
CSS Classes |
|
00:09:00 |
|
CSS IDs |
|
00:06:00 |
|
Colors |
|
00:08:00 |
|
Backgrounds |
|
00:04:00 |
|
Floating |
|
00:09:00 |
|
Positioning |
|
00:06:00 |
|
Margins |
|
00:07:00 |
|
Padding |
|
00:04:00 |
|
Borders |
|
00:03:00 |
| Module 03: CSS Intermediate |
|
Styling Text |
|
00:07:00 |
|
Aligning Text |
|
00:04:00 |
|
Styling Links |
|
00:10:00 |
|
Font Family |
|
00:07:00 |
|
Font Styles |
|
00:03:00 |
|
Applying Google Fonts |
|
00:07:00 |
|
Box Model |
|
00:09:00 |
|
Icons |
|
00:09:00 |
|
Tables |
|
00:16:00 |
|
Navigation-Menu |
|
00:11:00 |
|
Dropdowns |
|
00:15:00 |
| Module 04: CSS Advanced |
|
Advanced Selectors |
|
00:05:00 |
|
Forms |
|
00:17:00 |
|
Website Layout |
|
00:21:00 |
|
Rounded Corners |
|
00:08:00 |
|
Color Keywords |
|
00:06:00 |
|
Animations |
|
00:08:00 |
|
Pseudo Classes |
|
00:03:00 |
|
Gradients |
|
00:03:00 |
|
Shadows |
|
00:03:00 |
|
Calculations |
|
00:05:00 |
|
Creating Responsive Page |
|
00:06:00 |
| Module 05: CSS Expert |
|
Button Styles |
|
00:06:00 |
|
Pagination |
|
00:07:00 |
|
Multiple Columns |
|
00:06:00 |
|
Image Reflection |
|
00:03:00 |
|
UI – UX Design |
|
00:09:00 |
|
Social Media Icons |
|
00:08:00 |
|
External CSS Style adding |
|
00:06:00 |
| Module 06: Restful API Introduction |
|
Section Introduction |
|
00:02:00 |
|
Installing XAMPP for PHP, MySQL and Apache |
|
00:12:00 |
|
Installing Code Editor(Visual Studio Code) |
|
00:07:00 |
|
Postman API platform installation |
|
00:06:00 |
|
Composer installation |
|
00:04:00 |
|
Creating PHP Project on XAMPP |
|
00:03:00 |
|
Hello World Program |
|
00:06:00 |
| Module 07: Restful API Basic |
|
What is PHP |
|
00:08:00 |
|
What is Restful API |
|
00:05:00 |
|
HTTP request GET, POST, PUT or DELETE |
|
00:08:00 |
|
REST API project structure |
|
00:06:00 |
| Module 08: Project 1: Restful API Authentication |
|
Create Database and table |
|
00:06:00 |
|
Creating Project forms and folders |
|
00:05:00 |
|
Database Connection |
|
00:13:00 |
|
JSON Web Token Handler(JWT) |
|
00:14:00 |
|
Auth Middleware Token Validation |
|
00:23:00 |
|
Register form |
|
00:20:00 |
|
Login form |
|
00:14:00 |
|
User Token Authorization check form |
|
00:12:00 |
| Module 09: Project 2: Restful API - MySQL |
|
Create Database and table |
|
00:06:00 |
|
Adding Data to table – insert query |
|
00:03:00 |
|
MySQL Select query |
|
00:06:00 |
|
MySQL Update query |
|
00:04:00 |
|
MySQL Delete query |
|
00:02:00 |
|
Get Project2 Source Code |
|
00:02:00 |
|
Create Database Connection |
|
00:02:00 |
| Module 10: Restful API – Web API Services |
|
Create Items Class PHP File |
|
00:04:00 |
|
Create Method form |
|
00:04:00 |
|
Creating Record Using Restful API |
|
00:04:00 |
|
Reading Method form |
|
00:02:00 |
|
Reading Record Using Restful API |
|
00:03:00 |
|
Update Method form |
|
00:03:00 |
|
Update Record Using Restful API |
|
00:05:00 |
|
Delete Method form |
|
00:02:00 |
|
Delete Method Using Restful API |
|
00:02:00 |
|
Coding Exercise |
|
00:01:00 |
|
Solution for Coding Exercise |
|
00:02:00 |
|
SEO friendly Request URLs of REST API |
|
00:02:00 |
| Module 11: MYSQL Introduction |
|
Overview of Databases |
|
00:10:00 |
|
MySQL Installation |
|
00:16:00 |
|
MySQL Workbench Installation |
|
00:09:00 |
|
Connecting to MySQL using Console |
|
00:09:00 |
| Module 12: MySQL Basics |
|
Overview of Challenges |
|
00:04:00 |
|
SQL Statement Basic |
|
00:16:00 |
|
SELECT Statement |
|
00:09:00 |
|
SELECT DISTINCT |
|
00:05:00 |
|
Column AS Statement |
|
00:12:00 |
|
COUNT function |
|
00:11:00 |
| Module 13: MySQL Filtering Data |
|
SELECT WHERE Clause – One |
|
00:05:00 |
|
SELECT WHERE Clause – Two |
|
00:11:00 |
|
ORDER BY |
|
00:08:00 |
|
LIMIT |
|
00:09:00 |
|
BETWEEN |
|
00:11:00 |
|
IN Operator |
|
00:11:00 |
|
LIKE and ILIKE |
|
00:11:00 |
| Module 14: MySQL Functions |
|
Overview of GROUP BY |
|
00:06:00 |
|
Aggregation function SUM() |
|
00:09:00 |
|
Aggregation MIN() and MAX() |
|
00:05:00 |
|
GROUP BY – One |
|
00:09:00 |
|
GROUP BY – Two |
|
00:12:00 |
|
HAVING Clause |
|
00:05:00 |
| Module 15: MySQL Joins |
|
Overview Assessment |
|
00:02:00 |
|
Overview of JOINS |
|
00:04:00 |
|
Introduction to JOINS |
|
00:04:00 |
|
AS Statement table |
|
00:03:00 |
|
INNER JOIN |
|
00:18:00 |
|
FULL Outer Join |
|
00:11:00 |
|
LEFT Outer JOIN |
|
00:08:00 |
|
RIGHT JOIN |
|
00:08:00 |
|
Union |
|
00:07:00 |
| Module 16: MySQL Advanced Commands |
|
Advanced SQL Commands |
|
00:04:00 |
|
Timestamps |
|
00:12:00 |
|
EXTRACT from timestamp |
|
00:10:00 |
|
Mathematical Functions |
|
00:12:00 |
|
String Functions |
|
00:22:00 |
|
SUBQUERY |
|
00:13:00 |
| Module 17: MySQL Structure Creation |
|
Database and Tables |
|
00:06:00 |
|
Data Types |
|
00:10:00 |
|
Primary key and Foreign key |
|
00:06:00 |
|
Create Table in SQL Script |
|
00:13:00 |
| Module 18: MySQL Data Queries |
|
Insert |
|
00:11:00 |
|
Update |
|
00:07:00 |
|
Delete |
|
00:04:00 |
| Module 19: MySQL Structure Queries |
|
Alter Table |
|
00:10:00 |
|
Drop Table |
|
00:05:00 |
| Module 20: MySQL Constraints |
|
NOT NULL Constraint |
|
00:08:00 |
|
UNIQUE Constraint |
|
00:09:00 |
| Module 21: MySQL Backup and Restore |
|
Overview of Databases and Tables |
|
00:05:00 |
|
Backup database using phpMyAdmin |
|
00:12:00 |
|
Restoring a Database |
|
00:07:00 |
| Order Your Certificate |
|
Order Your Certificate Now |
|
00:00:00 |