| 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 | ||
| FULL Outer Join | 00:11: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:11: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 Now | 00:00:00 | ||