PHP & MySQL – Certification Course for Beginners

PHP & MySQL - Certification Course for Beginners

PHP & MySQL – Certification Course for Beginners

Learn to Build Database Driven Web Applications using PHP & MySQL

Language: english

Note: 4.4/5 (3,601 notes) 244,702 students

Instructor(s): YouAccel Training

Last update: 2019-07-10

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

 

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.

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.

 

Course 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

 

PHP & MySQL - Certification Course for BeginnersPHP & MySQL - Certification Course for Beginners

Time remaining or 971 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate