Web Applications for Specialisation on Development Course

Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.

Get 24/7 access to all content for a full year.

Each of our students gets full tutor support on weekdays (Monday to Friday)

Introduction

How to ask a great questions

Introduction CSS

Choosing Code Editor

Installing Code Editor (Sublime Text)

CSS Syntax

Creating a first page with CSS Style

Inline CSS

Internal CSS

External CSS

CSS Classes

CSS IDs

Colors

Backgrounds

Floating

Positioning

Margins

Padding

Borders

Styling Text

Aligning Text

Styling Links

Font Family

Font Styles

Applying Google Fonts

Box Model

Icons

Tables

Navigation-Menu

Dropdowns

Advanced Selectors

Forms

Website Layout

Rounded Corners

Color Keywords

Animations

Pseudo Classes

Gradients

Shadows

Calculations

Creating Responsive Page

Button Styles

Pagination

Multiple Columns

Image Reflection

UI - UX Design

Social Media Icons

External CSS Style adding

What is PHP

Installing XAMPP for PHP, MySQL and Apache

Installing Code Editor(Visual Studio Code)

Creating PHP Project on XAMPP

Hello World Program

Variables

Echo and Print

Data Types

Numbers

Boolean

Arrays

Multi-Dimensional Array

Sorting Arrays

Constants

Strings

String Formatting

String Methods

Coding Exercise

Solution for Coding Exercise

Arithmetic operators

Assignment operators

Comparison operators

Increment - decrement operators

Logical operators

Ternary operator

If statement

If-else statement

If-elseif-else statement

Switch-case statement

Flow Chart

While loop

Do-while loop

For loop

For each loop

Coding Exercise

Solution for Coding Exercise

Creating a Function

Function with Arguments

Default Argument

Function return values

Call-by-value

Call-by-reference

$_POST Method

$_GET Method

Form Handling

Date and Time

Include

Require

Sessions

File Reading

File Upload

What is OOP

Class and Objects

Constructor

Destructor

Access Modifiers

Inheritance

Method overriding

Abstract Class

Interface

MySQL Basic PhpMyAdmin

Creating Database and Table

Database Connection

PHP Form Create records

PHP Form Reading records

PHP Form Update Data

PHP Form Delete records

Registration Form

MD5 Algorithm for Encrypting

Sha Algorithm

Login Form

On Submit Validation

Input Numeric Validation

Login Form Validation

Form Server-side all Data Validation

Form Server-side Validation

Try-throw-catch

Try-throw-catch-finally

Overview of Databases

MySQL Installation

MySQL Workbench Installation

Connecting to MySQL using Console

Overview of Challenges

SQL Statement Basic

SELECT Statement

SELECT DISTINCT

Column AS Statement

COUNT function

SELECT WHERE Clause - One

SELECT WHERE Clause - Two

ORDER BY

LIMIT

BETWEEN

IN Operator

LIKE and ILIKE

Overview of GROUP BY

Aggregation function SUM()

Aggregation MIN() and MAX()

GROUP BY - One

GROUP BY - Two

HAVING Clause

Overview Assessment

Overview of JOINS

Introduction to JOINS

AS Statement table

INNER JOIN

FULL Outer Join

LEFT Outer JOIN

RIGHT JOIN

Union

Advanced SQL Commands

Timestamps

EXTRACT from timestamp

Mathematical Functions

String Functions

SUBQUERY

Database and Tables

Data Types

Primary key and Foreign key

Create Table in SQL Script

Insert

Update

Delete

Alter Table

Drop Table

NOT NULL Constraint

UNIQUE Constraint

Overview of Databases and Tables

Backup database using phpMyAdmin

Restoring a Database