| 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 | ||
