Backend Programming With Php & 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 jаvascript
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


Homepage

https://www.udemy.com/course/backend-programming-with-php-mysql/