| Section 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 |
| Section 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 |
| Section 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 |
| Section 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 |
| Section 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 |
| Section 06: PHP Introduction |
|
What is PHP |
|
00:08:00 |
|
Installing XAMPP for PHP, MySQL and Apache |
|
00:12:00 |
|
Installing Code Editor(Visual Studio Code) |
|
00:07:00 |
|
Creating PHP Project on XAMPP |
|
00:03:00 |
|
Hello World Program |
|
00:06:00 |
| Section 07: PHP Basic |
|
Variables |
|
00:16:00 |
|
Echo and Print |
|
00:08:00 |
|
Data Types |
|
00:11:00 |
|
Numbers |
|
00:06:00 |
|
Boolean |
|
00:04:00 |
|
Arrays |
|
00:06:00 |
|
Multi-Dimensional Array |
|
00:07:00 |
|
Sorting Arrays |
|
00:04:00 |
|
Constants |
|
00:05:00 |
| Section 08: PHP Strings |
|
Strings |
|
00:04:00 |
|
String Formatting |
|
00:05:00 |
|
String Methods |
|
00:08:00 |
|
Coding Exercise |
|
00:01:00 |
|
Solution for Coding Exercise |
|
00:01:00 |
| Section 09: PHP Operators |
|
Arithmetic operators |
|
00:03:00 |
|
Assignment operators |
|
00:02:00 |
|
Comparison operators |
|
00:05:00 |
|
Increment – decrement operators |
|
00:03:00 |
|
Logical operators |
|
00:06:00 |
|
Ternary operator |
|
00:03:00 |
| Section 10: PHP Decision making system |
|
If statement |
|
00:05:00 |
|
If-else statement |
|
00:02:00 |
|
If-elseif-else statement |
|
00:03:00 |
|
Switch-case statement |
|
00:05:00 |
| Section 11: PHP Control flow statements |
|
Flow Chart |
|
00:06:00 |
|
While loop |
|
00:09:00 |
|
Do-while loop |
|
00:04:00 |
|
For loop |
|
00:15:00 |
|
For each loop |
|
00:04:00 |
|
Coding Exercise |
|
00:01:00 |
|
Solution for Coding Exercise |
|
00:01:00 |
| Section 12: PHP Functions |
|
Creating a Function |
|
00:07:00 |
|
Function with Arguments |
|
00:08:00 |
|
Default Argument |
|
00:03:00 |
|
Function return values |
|
00:06:00 |
|
Call-by-value |
|
00:02:00 |
|
Call-by-reference |
|
00:03:00 |
| Section 13: PHP Super globals |
|
$_POST Method |
|
00:06:00 |
|
$_GET Method |
|
00:02:00 |
| Section 14: PHP Advanced |
|
Form Handling |
|
00:08:00 |
|
Date and Time |
|
00:08:00 |
|
Include |
|
00:06:00 |
|
Require |
|
00:02:00 |
|
Sessions |
|
00:08:00 |
|
File Reading |
|
00:02:00 |
|
File Upload |
|
00:06:00 |
| Section 15: PHP Object oriented programming[OOPs] |
|
What is OOP |
|
00:03:00 |
|
Class and Objects |
|
00:11:00 |
|
Constructor |
|
00:04:00 |
|
Destructor |
|
00:03:00 |
|
Access Modifiers |
|
00:10:00 |
|
Inheritance |
|
00:12:00 |
|
Method overriding |
|
00:06:00 |
|
Abstract Class |
|
00:03:00 |
|
Interface |
|
00:08:00 |
| Section 16: PHP – MySQL Application [CRUD] |
|
MySQL Basic PhpMyAdmin |
|
00:04:00 |
|
Creating Database and Table |
|
00:07:00 |
|
Database Connection |
|
00:05:00 |
|
PHP Form Create records |
|
00:16:00 |
|
PHP Form Reading records |
|
00:11:00 |
|
PHP Form Update Data |
|
00:15:00 |
|
PHP Form Delete records |
|
00:04:00 |
| Section 17: PHP Real world code forms |
|
Registration Form |
|
00:04:00 |
|
MD5 Algorithm for Encrypting |
|
00:03:00 |
|
Sha Algorithm |
|
00:02:00 |
|
Login Form |
|
00:12:00 |
| Section 18: PHP Validations |
|
On Submit Validation |
|
00:09:00 |
|
Input Numeric Validation |
|
00:12:00 |
|
Login Form Validation |
|
00:05:00 |
|
Form Server-side all Data Validation |
|
00:06:00 |
|
Form Server-side Validation |
|
00:06:00 |
| Section 19: PHP Error handling |
|
Try-throw-catch |
|
00:06:00 |
|
Try-throw-catch-finally |
|
00:02:00 |
| Section 20: 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 |
| Section 21: MySQL basic |
|
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 |
| Section 22: 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 |
| Section 23: 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 |
| Section 24: 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 |
|
LEFT Outer JOIN |
|
00:08:00 |
|
RIGHT JOIN |
|
00:08:00 |
|
Union |
|
00:07:00 |
| Section 25: 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 |
| Section 26: 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 |
| Section 27: MySQL data queries |
|
Insert |
|
00:00:00 |
|
Update |
|
00:07:00 |
|
Delete |
|
00:04:00 |
| Section 28: MySQL structure queries |
|
Alter Table |
|
00:10:00 |
|
Drop Table |
|
00:05:00 |
| Section 29: MySQL constraints |
|
NOT NULL Constraint |
|
00:08:00 |
|
UNIQUE Constraint |
|
00:09:00 |
| Section 30: 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 |
|
00:00:00 |