PHP & MySQL - Certification Course for Beginners
4.3 (1,346 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
95,023 students enrolled

PHP & MySQL - Certification Course for Beginners

Learn to Build Database Driven Web Applications using PHP & MySQL
4.3 (1,346 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
95,023 students enrolled
Created by YouAccel Training
Last updated 7/2019
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Course content
Expand all 57 lectures 03:15:34
+ PHP Development
30 lectures 01:47:37
PHP Variables
03:46
PHP Variable Scope
03:15
PHP Global Keyword
02:03
PHP Static Keyword
01:45
PHP Echo vs Print
04:01
PHP Data Types
05:46
PHP Objects
02:58
PHP Strings
01:50
PHP Constants
03:04
PHP Operators
08:52
PHP Conditional Statements
02:32
PHP ElseIf Statement
03:11
PHP Switch Statement
01:45
PHP While Loops
04:34
PHP For Loops
01:40
PHP Functions
03:29
PHP Functions Continued
01:49
PHP Arrays
04:51
PHP Multidimensional Arrays
01:59
PHP Sorting Arrays
02:51
PHP Superglobal Variables
02:10
PHP Forms Introduction
04:06
PHP POST vs GET Basics
05:24
PHP Form Output and Validation
09:36
PHP Form Required Fields
04:40
PHP Validation Continued
01:45
+ MySQL Database Integration
27 lectures 01:27:57
Introduction to MySQL Databases
02:40
Introduction PhpMyAdmin
02:35
PhpMyAdmin Interface Overview
01:12
MySQL Security and Root Superuser
05:02
MySQL Creating a Database and Table
05:24
MySQL Creating a New User
05:33
MySQL Database and Table Specific Privileges
03:05
MySQL Modifying and Deleting a Table
04:30
MySQL Modifying and Deleting a Database
04:07
Introduction to SQL
01:35
SQL Statements in PhpMyAdmin
04:05
Connect to MySQL Database using PHP
05:02
MySQL Database - Import Data
01:43
SQL Select
02:27
SQL Distinct Keyword
01:45
SQL Where Clause
01:40
SQL And Operator
01:42
SQL Or Operator
01:01
SQL Order By
01:36
MySQL Insert Into
06:29
MySQL Get Last ID
01:27
MySQL Insert Multiple Records
01:44
MySQL Prepared Statements
02:45
MySQL Delete Records
07:49
PHP Header Function
01:17
PHP Isset
02:35
MySQL Update Records
07:07
Requirements
  • Basic Computer Skills
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.

Who this course is for:
  • Beginner developers who are interested in learning the foundations of PHP.
  • Students who want to integrate MySQL Databases into their PHP Web Applications.
  • Students who want to learn to code in PHP.
  • Students who want to learn how to execute SQL Statements, directly from PHP.