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 |
Membership renews after 12 months. You can cancel anytime from your account.