PHP & MySQL - Certification Course for Beginners
Beginner LevelDevelopmentPHP

PHP & MySQL - Certification Course for Beginners

Learn to Build Database Driven Web Applications using PHP & MySQL

Created by YouAccel Training
3.5 hours
Video Content
57
Lectures
288,030
Students
4.5
Rating
4.5
(288,030 students enrolled)

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

2 sections β€’ 57 lectures β€’ 03:15:34 total length

PHP Development

30 lectures β€’ 01:47:37

PHP Introduction03:03
PHP Preparation02:55
PHP File Test02:20
PHP Syntax05:37
PHP Variables03:46
+25 more lectures

MySQL Database Integration

27 lectures β€’ 01:27:57

Introduction to MySQL Databases02:40
Introduction PhpMyAdmin02:35
PhpMyAdmin Interface Overview01:12
MySQL Security and Root Superuser05:02
MySQL Creating a Database and Table05:24
+22 more lectures

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

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.

This course includes:

  • 3.5 hours on-demand video
  • 0
  • 1 downloadable resources
  • Access on mobile and TV
  • ∞Full lifetime access
  • Certificate of completion

Instructor

YouAccel Training

Students also download

Explore related courses to expand your learning journey.