Getting Started with PHP & MySQL Development

4 Hours

$19.00$199.00

You save 90%

40 Lessons (4h)

Introduction to PHP
Introduction to PHP, Requirements
Getting XAMPP and Brackets, Starting Server
First PHP Script
Variable in PHP
If, if else, if else if..., Switch
While, Do While, For, Foreach
Object Oriented Features
Functions in PHP
Require, Include and some String Functions
Classes Overview
Scoping Rules and the Global Keyword
Static Properties
Arrays and Variables
Arrays in PHP
$_SERVER Variables in PHP
$_GET in PHP
$_POST in PHP
$_REQUEST in PHP
MySQL Database Insight
Using PHPMyAdmin
Sample Database
Connecting to MySQL
Inserting to MySQL, and Wrapup
Introduction and Installation of MySQL
Installing MySQL
Database Creation
Table Creation with SELECT and INSERT
MySQL Data Types
Creating an Auto Incrementing Primary Key
MySQL Basic Statments
Describe Table
Loading sql Files into MySQL
Introduction to SELECT Query
SELECT Query Demo
MySQL Advanced Statements
MySQL Update Query
Mathematical Operations
DISTINCT, COUNT and GROUP by Clauses
Table Relationships
Introduction to Joins
MySQL Advanced Statements Part 2
The Delete Query
Types of Joins
Joins Demo
Creating and Using Views
Setting Up a Many to Many Relationship
Demo of Many to Many Relationship

DescriptionInstructorImportant DetailsRelated Products

Brush Up on Your PHP & MySQL Skills to Further Your Programming Know-How

EDUmobile AcademyThe EDUmobile Academy was founded in 2008 as a bootstrapped initiative of Vishal Lamba, who has been actively involved in the technology space since 1989. We're very passionate about creating courses that have world class standards, and providing heroic support to our community of learners. Every course is created by USA based, technologically qualified mentors, having an absolutely clear diction and command over spoken English. Over the years we've provided guidance and training to a developer community of over 80,000. For more details on this course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Description

PHP is an object-oriented general purpose language suitable for a wide variety of tasks. In this course, you'll learn how to use PHP as a server-side scripting language for use in web development. In addition, you'll study MySQL, a general purpose relational database management system (RDBMS) used mainly to provide a back-end database for web apps. In this course, you'll get introduced to the concepts of relational database management systems in general, and how they relate to MySQL in particular. Unlike traditional courses that concentrate mainly on theory, this course takes a practical “how-to” approach to working with data.

Study PHP & MySQL w/ 40 lectures & 4 hours of content
Learn basic syntax, variables, loops & decision constructs.
Study object oriented features, string functions, arrays, REQUEST, GET & POST
Integrate MySQL databases w/ PHP
Create databases & tables
Add data to a table w/ INSERT
Use SELECT, WHERE & ORDER to sort or filter
Use JOINs to read from multiple tables

Specs

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your Cart

Your cart is empty. Continue Shopping!

Processing order...