Softcademy

Starting

Structure of HTML5

Tags

Path link

HTML5 rules

New semantic elements

Physical styles

Lists - Ordered & Unordered

Adding images

Adding tables

Adding forms

Forms - GET vs POST

Forms - selection list

Audio & Video

div vs span

Linking CSS

CSS simple selectors

CSS Pseudo-selectors & Attributes

Useful units

Padding & Margin

Transition & Transform

Shadow

@media query

div inline-block

Flex layout

Grid layout

Positioning

Adding navigation bar

Cleaning up the section

Create Parallax

Footer & name anchor

Editing contact page

Designing the form

Finishing the form

Finishing & overlay effect

Clone / Download the project

Before moving to the next section (PHP)

Installation

Preparation

Basic syntax

Variables

Concatenation

Data types with var_dump()

PHP Operators

Strings

If else statement (condition)

If else example with HTML form

More with if else statements

Switch operator

Switch operator example with date

For loop

For loop - solution

While & do while

Functions

Try Catch

Array

Array & foreach loop

Associative array

File handling

File handling - fopen, fread, fwrite

File handling - append

File handling - delete

File handling - CSV

File handling - file_get_content & glob

Cookie - set cookie

Cookie - delete cookie

Session

Session with example

Filter & Sanitize

OOP (Object-Oriented Programming

OOP - Explained

OOP - Constructor & Destructor

OOP - Access modifiers

OOP - Inheritance

OOP - Overriding & final keyword

OOP - Constants

OOP - Interfaces

OOP - Static methods

OOP - Namespaces

Starting with MySQL

Create database

Create & describe table

Create other tables

Foreign key

Insert data

Alter table

Select from more tables with join

Joins overview

Where clause, order by, & alias

Aggregate functions

Limit & Offset

Useful operations

Working with dates - datediff

Working with dates - interval

Subquery & Group by

Wildcards

In & Not in

Select from more tables

Select total

Delete

Delete with subquery

Update

Drop / Delete table