Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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:
I hope you enjoy the course, and I look forward to working with you!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to PHP|
Introduction to PHP, RequirementsPreview
Getting XAMPP and Brackets, Starting Server
First PHP ScriptPreview
Variable in PHP
If, if else, if else if..., Switch
While, Do While, For, Foreach
|Section 2: Object Oriented Features|
Functions in PHP
Require, Include and some String Functions
Scoping Rules and the Global Keyword
|Section 3: Arrays and Variables|
Arrays in PHP
$_SERVER Variables in PHP
$_GET in PHP
$_POST in PHP
$_REQUEST in PHP
|Section 4: MySQL Database Insight|
Connecting to MySQL
Inserting to MySQL, and Wrapup
|Section 5: Introduction and Installation of MySQL|
Table Creation with SELECT and INSERT
MySQL Data Types
Creating an Auto Incrementing Primary Key
|Section 6: MySQL Basic Statments|
Loading sql Files into MySQL
Introduction to SELECT Query
SELECT Query Demo
|Section 7: MySQL Advanced Statements|
MySQL Update Query
DISTINCT, COUNT and GROUP by Clauses
Introduction to Joins
|Section 8: MySQL Advanced Statements Part 2|
The Delete Query
Types of Joins
Creating and Using Views
Setting Up a Many to Many Relationship
Demo of Many to Many Relationship
EDUmobile Academy develops high quality video training courses around topics in mobile development including iPhone, Android, Windows Phone, Java, Responsive Web Design and other emerging technologies.
Every course is created by an expert developer AND a trained mentor in the area of expertise.
Each course undergoes a rigorous planning, review and an internal quality check phase - to ensure that the teaching is of highest standards available online.
EDUmobile Academy was founded in 2008 when smart phones were just emerging into the market. Founder Vishal Lamba is experienced in multiple areas of digital design, mobile development and design, web technologies and digital marketing. He has a mathematics and computer science degree from Lawrence University, USA.
Vishal works closely with content creators and teachers to ensure that every course released meets the internal rigorous quality standards.
All course creators and trainers are currently based in the USA. Support for each course on Udemy is provided with quick turn around by a small team of developers and trainers.