Understanding PHP and MySQL

 

What you'll learn

What backend programming is

How to write SQL statements

How to connect frontend to backend

Database connections

Dynamic Web Development

 

Requirements

HTML, CSS and javascript

 

Description

Welcome to Backend Development with PHP and MySQL course! If you aspire to become a skilled backend developer or wish to enhance your web development skills, this comprehensive course is the perfect choice for you.In this hands-on and practical course, you will learn how to build dynamic, interactive, and robust web applications using PHP and MySQL, two of the most popular technologies in the web development industry. Throughout this course, we will cover essential concepts, best practices, and real-world scenarios to empower you to create powerful and secure backend systems.What you'll learn:Fundamentals of PHP: We'll start from scratch, covering the basics of PHP, including variables, data types, functions, control structures, and object-oriented programming. By the end of this section, you'll be comfortable writing PHP code.Working with Databases: You'll learn how to interact with MySQL, one of the most widely used relational database management systems. We'll cover database design, SQL queries, and how to connect PHP with MySQL to perform CRUD (Create, Read, Update, Delete) operations.Handling Forms and User Input: Building dynamic web applications requires handling user input securely.Deployment and Project Management: Learn how to deploy your PHP and MySQL applications to a web server, ensuring your projects are accessible to users worldwide.

 

Overview

Section 1: Introduction

 

Lecture 1 Introduction

 

Lecture 2 XAMPP Installation

 

Lecture 3 PHP Syntax

 

Lecture 4 Variables in PHP

 

Lecture 5 Variable Scope

 

Lecture 6 Data Types

 

Lecture 7 Operators in php

 

Lecture 8 If statements

 

Lecture 9 Switch Statements

 

Lecture 10 Loops

 

Lecture 11 Functions

 

Lecture 12 Form Handling 1

 

Lecture 13 Form Validation 1

 

Lecture 14 Form Validation 2

 

Section 2: MySQL

 

Lecture 15 Intro to MySQL

 

Lecture 16 SQL & XAMPP

 

Lecture 17 SELECT & WHERE Statements

 

Lecture 18 Logic Operators

 

Lecture 19 INSERT & ORDER_BY Statements

 

Lecture 20 UPDATE & DELETE Statements

 

Lecture 21 COUNT, AVG, SUM

 

Lecture 22 LIKE & WILDCARDS

 

Lecture 23 Aliases

 

Lecture 24 MySQL CRUD

 

 

Beginners in backend web development,Web developers who already know basics of frontend web development

Backend_Programming_with_PHP_MySQL.part1.rar - 995.0 MB

Backend_Programming_with_PHP_MySQL.part2.rar - 815.6 MB