Getting Started with PHP and MySQL Development
4.2 (55 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.
2,664 students enrolled

Getting Started with PHP and MySQL Development

We’ll Introduce fundamental of PHP and the Basic Concepts of RDBMS in general with MySQL Database for Beginners
4.2 (55 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.
2,664 students enrolled
Created by EDUmobile Academy
Last updated 1/2016
English
English [Auto]
Current price: $126.99 Original price: $194.99 Discount: 35% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 27 downloadable resources
  • 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
  • Over 40 lectures and 4 hours of content!
  • You will acquire knowledge of basic PHP Functions, Arrays and many more..
  • You will be able to create your basic PHP website.
  • Understand the Basic Relational Database Management System Concepts.
  • Execute Basic to Advanced MySQL Queries.
Course content
Expand all 40 lectures 03:55:53
+ Introduction to PHP
6 lectures 39:54
Getting XAMPP and Brackets, Starting Server
02:35
Variable in PHP
05:00
If, if else, if else if..., Switch
10:02
While, Do While, For, Foreach
09:13
+ Object Oriented Features
5 lectures 35:05
Functions in PHP
05:42
Require, Include and some String Functions
09:13
Classes Overview
07:09
Scoping Rules and the Global Keyword
03:35
Static Properties
09:26
+ Arrays and Variables
5 lectures 27:23
Arrays in PHP
10:35
$_SERVER Variables in PHP
05:55
$_GET in PHP
04:08
$_POST in PHP
02:49
$_REQUEST in PHP
03:56
+ MySQL Database Insight
4 lectures 18:58
Sample Database
01:59
Connecting to MySQL
05:11
Inserting to MySQL, and Wrapup
06:47
+ Introduction and Installation of MySQL
5 lectures 35:38
Database Creation
02:46
Table Creation with SELECT and INSERT
06:26
MySQL Data Types
12:47
Creating an Auto Incrementing Primary Key
08:06
+ MySQL Basic Statments
4 lectures 22:44
Describe Table
03:59
Loading sql Files into MySQL
06:55
Introduction to SELECT Query
06:34
SELECT Query Demo
05:16
+ MySQL Advanced Statements
5 lectures 27:05
MySQL Update Query
03:15
Mathematical Operations
06:06
DISTINCT, COUNT and GROUP by Clauses
04:02
Table Relationships
07:47
Introduction to Joins
05:55
+ MySQL Advanced Statements Part 2
6 lectures 29:07
The Delete Query
04:36
Types of Joins
06:04
Joins Demo
04:36
Creating and Using Views
02:43
Setting Up a Many to Many Relationship
04:36
Demo of Many to Many Relationship
06:32
Requirements
  • Knowledge of Basic HTML Tags
  • Knowledge of some Scripting Language Preferred, but Not Necessary.
  • Knowledge of RDBMS Concept is Helpful but Not Required
Description

PHP is an object oriented general purpose language suitable for a wide variety of tasks. In this course, we'll learn how to use PHP as a server-side scripting language for use in web development.

MySQL is a general purpose relational database management system (RDBMS) used mainly to provide a back-end database for web applications. In this course, we'll introduce 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, we'll take a practical “how-to” approach to working with data. Here's what you'll learn:

The course cover following topics:

PHP

  • basic syntax, variables,loops and decision constructs.
  • Object oriented features
  • String functions.
  • Arrays
  • REQUEST, GET, and POST
  • Integrate MySQL databases with PHP.
  • Creating databases and tables
  • Adding data to a table with INSERT
  • Reading a table with SELECT
  • How to use WHERE to filter data
  • Using ORDER BY to sort data
  • JOINs and how to use them to read from multiple tables
  • Changing data in a table with UPDATE
  • The DELETE query: removing one or more rows of data from a table
  • Using a text file to load a database schema

MySQL

I hope you enjoy the course, and I look forward to working with you!

Who this course is for:
  • Any Fresher Wants to Learn Basic PHP & MySQL
  • Expert who Needs to Brush up PHP & MySQL Skills