PHP & MySQL - Certification Course for Beginners

Learn to Build Database Driven Web Applications using PHP & MySQL

4.32 (3347 reviews)
Udemy
platform
English
language
Web Development
category
230,589
students
3.5 hours
content
Jul 2019
last update
$199.99
regular price

What you will learn

PHP Variables, Syntax, Variable Scope, Keywords

Echo vs. Print and Data Output

PHP Strings, Constants, Operators

PHP Conditional Statements

PHP Elseif, Switch, Statements

PHP Loops - While, For

PHP Functions

PHP Arrays, Multidimensional Arrays, Sorting Arrays

Working with Forms - Post vs. Get

PHP Server Side - Form Validation

Creating MySQL Databases

Database Administration with PhpMyAdmin

Administering Database Users, and Defining User Roles

SQL Statements - Select, Where, And, Or, Insert, Get Last ID

MySQL Prepared Statements and Multiple Record Insertion

PHP Isset

MySQL - Updating Records

Description

Welcome to the PHP & MySQL Certification Course for Beginners.

This course offers a comprehensive guide to learning how to code in PHP. We also explore integrating MySQL Databases into your PHP Projects for dynamic, user driven functionality.

We start with PHP basics, including variable declaration and data output. The lessons then transition into working with objects, conditional statements, loops, functions, arrays, form validation, sorting, and much more.

After the PHP Section, students learn to unleash the true power of dynamic page development with MySQL database integration. We start with table creation and user management. From there we progress into commonly used SQL statements for database administration. Students are also taught how to create database connections and to execute SQL statements directly from PHP scripts. Our coding style keeps script security, and execution efficiency in mind at all times.

If you are interested in embarking into the world of PHP Development with Database integration, don’t wait another second. Enrol today in this exciting new course.

What you'll learn - Overview:

  • PHP Variables, Syntax, Variable Scope, Keywords

  • Echo vs. Print and Data Output

  • PHP Strings, Constants, Operators

  • PHP Conditional Statements

  • PHP Elseif, Switch, Statements

  • PHP Loops - While, For

  • PHP Functions

  • PHP Arrays, Multidimensional Arrays, Sorting Arrays

  • Working with Forms - Post vs. Get

  • PHP Server Side - Form Validation

  • Creating MySQL Databases

  • Database Administration with PhpMyAdmin

  • Administering Database Users, and Defining User Roles

  • SQL Statements - Select, Where, And, Or, Insert, Get Last ID

  • MySQL Prepared Statements and Multiple Record Insertion

  • PHP Isset

  • MySQL - Updating Records

Screenshots

PHP & MySQL - Certification Course for Beginners - Screenshot_01PHP & MySQL - Certification Course for Beginners - Screenshot_02PHP & MySQL - Certification Course for Beginners - Screenshot_03PHP & MySQL - Certification Course for Beginners - Screenshot_04

Content

PHP Development

PHP Introduction
PHP Preparation
PHP File Test
PHP Syntax
PHP Variables
PHP Variable Scope
PHP Global Keyword
PHP Static Keyword
PHP Echo vs Print
PHP Data Types
PHP Objects
PHP Strings
PHP Constants
PHP Operators
PHP Conditional Statements
PHP ElseIf Statement
PHP Switch Statement
PHP While Loops
PHP For Loops
PHP Functions
PHP Functions Continued
PHP Arrays
PHP Multidimensional Arrays
PHP Sorting Arrays
PHP Superglobal Variables
PHP Forms Introduction
PHP POST vs GET Basics
PHP Form Output and Validation
PHP Form Required Fields
PHP Validation Continued

MySQL Database Integration

Introduction to MySQL Databases
Introduction PhpMyAdmin
PhpMyAdmin Interface Overview
MySQL Security and Root Superuser
MySQL Creating a Database and Table
MySQL Creating a New User
MySQL Database and Table Specific Privileges
MySQL Modifying and Deleting a Table
MySQL Modifying and Deleting a Database
Introduction to SQL
SQL Statements in PhpMyAdmin
Connect to MySQL Database using PHP
MySQL Database - Import Data
SQL Select
SQL Distinct Keyword
SQL Where Clause
SQL And Operator
SQL Or Operator
SQL Order By
MySQL Insert Into
MySQL Get Last ID
MySQL Insert Multiple Records
MySQL Prepared Statements
MySQL Delete Records
PHP Header Function
PHP Isset
MySQL Update Records

Reviews

David
June 28, 2022
Expected me to have access to the WAMP download and set up tutorial that is in a different class entirely. This was not stated in the pre requisites. I was able to find the WAMP download video as a preview, and am hoping the server setup video doesn't have vital information that will block me from completing the course later.
Pranav
May 16, 2022
In lecture 28, I'm getting the error - Parse error: syntax error, unexpected token "if" on line 24. But the code runs fine in the video. Can you help me? I've checked multiple times for missing ; and {,(, etc. I cannot continue unless this form runs.
Rajkumar
May 13, 2022
Till now it's good understandable! Let's see what happens next ? This lectures can clear my doubts or not !
Henry
May 10, 2022
It is a good course that need constant updates but the sql segment is quite difficult for me…Maybe because this is my first course on MySQL
Eduardo
April 3, 2022
me encanto , esta en ingles y se muy poco ingles ,aun asi me encanto el curso, muy bien explicado y estructurado.. sin duda esta muy bien por que te da muchas bases de php para que puedas expandirte y ser creativo a la hora de programar... directo al grano muchas felicidades ,saludos desde toluca estado de mexico,mexico
Juan
March 24, 2022
Buena explicación y buenos ejemplos recomiendo que sepan algo de programación antes de iniciar el curso. La pantalla dividida no deja ver muy claro el codigo.
Festus
March 22, 2022
This course was great for a beginner like me. It has all the basics required to start up as a new php and mySQL programmer.
Geoff
March 15, 2022
The course was fine but I have 3 problems. 1. Too short -poor value for money (it was only 3 hours long and too brief on PHP and SQL specifics, it really needed more on the PHP built in functions!) 2. There were no exercises, coding challenges or projects, for me the backbone of any good course. 3. The stupid yellow circle used to draw attention on screen obscures so much, that what is being pointed out is not visible. In truth if you have programming experience you are going to be bored and feel it was obvious and if you don't it is way too lightweight and lacking detail to be of any real use to you!
Humberto
February 23, 2022
Aún no sabría si es una buena elección, podría ser mejor porque podría estar en español, por mi no tengo problema pues entiendo bien el inglés, sin embargo para alguien que no entiende inglés es complicado, al principio asumieron que ya estaba instalado wamp, por mi no hubo problema porque lo instale y ya había trabajado con el, aún falta trabajar más ejercicios
Javier
February 22, 2022
Besides it's a bit outdated, the order in which certain things are taught can be confusing, like teaching about the foreach loop, which targets arrays, before teaching what arrays are, how they are defined and how they work.
John
February 9, 2022
The topic and the explanation is very clear and easy to understand for beginners like me. I've learned a lot through this course and it helps me to finish a project for school.
Amey
December 3, 2021
Perfect crash course for beginners in PHP & MySQL. However the basics and PhP tags are not fully explained which I expected. Overall great learning experience with simple tools in Web Development
Vladimir
November 21, 2021
Very little information. No information about COOKIES, SESSIONS and other important features for a beginner programmer.
Ravihara
November 2, 2021
Basic knowledge of php and mysql was quickly and easily updated. I wish YouAccel Training to continue to bring such valuable lessons.
Oisin
October 1, 2021
Nice overview, especially if you're already familiar with another programming language. Not sure if newbies to coding will grasp the depth and complexities of object-oriented programming in a 3 min segment tho. ? Got WAMP up and running and got to play with some PHP and MySQL. I had fun making interactive webpages and learned a lot so 5/5 stars. ⭐⭐⭐⭐⭐ Pros: - The course is great as a short introduction to PHP and MySQL. - Clear audio - Exercise files Cons: - Resolution is less than 1080p and the text used on screen is quite small causing it to become a little bit pixelated. Still readable though you may need to maximize on screen. Might not be clear on mobile. - Highlight color around cursor is too opaque and somewhat blocks what is beneath. This is especially noticeable when the lecturer uses the cursor to point at specific areas of text.

Charts

Price

PHP & MySQL - Certification Course for Beginners - Price chart

Rating

PHP & MySQL - Certification Course for Beginners - Ratings chart

Enrollment distribution

PHP & MySQL - Certification Course for Beginners - Distribution chart

Coupons

DateDiscountStatus
9/26/2019100% OFF
expired
10/14/2019100% OFF
expired
11/13/2019100% OFF
expired
12/13/2019100% OFF
expired
1/6/2020100% OFF
expired
1/31/2020100% OFF
expired
2/12/2020100% OFF
expired
3/12/2020100% OFF
expired
3/25/2020100% OFF
expired
4/4/2020100% OFF
expired
4/11/2020100% OFF
expired
4/23/2020100% OFF
expired
5/5/2020100% OFF
expired
5/16/2020100% OFF
expired
6/2/2020100% OFF
expired
6/17/2020100% OFF
expired
7/6/2020100% OFF
expired
7/10/2020100% OFF
expired
8/6/2020100% OFF
expired
8/26/2020100% OFF
expired
9/5/2020100% OFF
expired
9/18/2020100% OFF
expired
9/21/2020100% OFF
expired
10/5/2020100% OFF
expired
10/20/2020100% OFF
expired
10/23/2020100% OFF
expired
11/6/2020100% OFF
expired
11/21/2020100% OFF
expired
11/26/2020100% OFF
expired
12/19/2020100% OFF
expired
12/24/2020100% OFF
expired
12/28/2020100% OFF
expired
1/22/2021100% OFF
expired
1/27/2021100% OFF
expired
2/19/2021100% OFF
expired
2/25/2021100% OFF
expired
3/19/2021100% OFF
expired
3/22/2021100% OFF
expired
3/30/2021100% OFF
expired
4/8/2021100% OFF
expired
4/23/2021100% OFF
expired
5/10/2021100% OFF
expired
5/28/2021100% OFF
expired
6/19/2021100% OFF
expired
6/30/2021100% OFF
expired
7/11/2021100% OFF
expired
7/20/2021100% OFF
expired
8/2/2021100% OFF
expired
8/21/2021100% OFF
expired
9/2/2021100% OFF
expired
9/28/2021100% OFF
expired
9/30/2021100% OFF
expired
10/10/2021100% OFF
expired
10/27/2021100% OFF
expired
10/30/2021100% OFF
expired
11/21/2021100% OFF
expired
11/26/2021100% OFF
expired
1/9/2022100% OFF
expired
1/30/2022100% OFF
expired
2/13/2022100% OFF
expired
2/17/2022100% OFF
expired
2/22/2022100% OFF
expired
3/8/2022100% OFF
expired
3/16/2022100% OFF
expired
3/25/2022100% OFF
expired
4/9/2022100% OFF
expired
4/18/2022100% OFF
expired
4/30/2022100% OFF
expired
5/11/2022100% OFF
expired
5/22/2022100% OFF
expired
6/13/2022100% OFF
expired
6/29/2022100% OFF
expired

Related Topics

2390114
udemy ID
5/29/2019
course created date
6/19/2019
course indexed date
Bot
course submited by