Getting Started with PHP and MySQL Development

Getting Started with PHP and MySQL Development, available at $49.99, has an average rating of 4.7, with 40 lectures, based on 61 reviews, and has 2677 subscribers.

You will learn about 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. This course is ideal for individuals who are Any Fresher Wants to Learn Basic PHP & MySQL or Expert who Needs to Brush up PHP & MySQL Skills It is particularly useful for Any Fresher Wants to Learn Basic PHP & MySQL or Expert who Needs to Brush up PHP & MySQL Skills.

Enroll now: Getting Started with PHP and MySQL Development

Summary

Title: Getting Started with PHP and MySQL Development

Price: $49.99

Average Rating: 4.7

Number of Lectures: 40

Number of Published Lectures: 40

Number of Curriculum Items: 40

Number of Published Curriculum Objects: 40

Original Price: $189.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

Any Fresher Wants to Learn Basic PHP & MySQL

Expert who Needs to Brush up PHP & MySQL Skills

Target Audiences

Any Fresher Wants to Learn Basic PHP & MySQL

Expert who Needs to Brush up PHP & MySQL Skills

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!

Course Curriculum

Chapter 1: Introduction to PHP

Lecture 1: Introduction to PHP, Requirements

Lecture 2: Getting XAMPP and Brackets, Starting Server

Lecture 3: First PHP Script

Lecture 4: Variable in PHP

Lecture 5: If, if else, if else if, Switch

Lecture 6: While, Do While, For, Foreach

Chapter 2: Object Oriented Features

Lecture 1: Functions in PHP

Lecture 2: Require, Include and some String Functions

Lecture 3: Classes Overview

Lecture 4: Scoping Rules and the Global Keyword

Lecture 5: Static Properties

Chapter 3: Arrays and Variables

Lecture 1: Arrays in PHP

Lecture 2: $_SERVER Variables in PHP

Lecture 3: $_GET in PHP

Lecture 4: $_POST in PHP

Lecture 5: $_REQUEST in PHP

Chapter 4: MySQL Database Insight

Lecture 1: Using PHPMyAdmin

Lecture 2: Sample Database

Lecture 3: Connecting to MySQL

Lecture 4: Inserting to MySQL, and Wrapup

Chapter 5: Introduction and Installation of MySQL

Lecture 1: Installing MySQL

Lecture 2: Database Creation

Lecture 3: Table Creation with SELECT and INSERT

Lecture 4: MySQL Data Types

Lecture 5: Creating an Auto Incrementing Primary Key

Chapter 6: MySQL Basic Statments

Lecture 1: Describe Table

Lecture 2: Loading sql Files into MySQL

Lecture 3: Introduction to SELECT Query

Lecture 4: SELECT Query Demo

Chapter 7: MySQL Advanced Statements

Lecture 1: MySQL Update Query

Lecture 2: Mathematical Operations

Lecture 3: DISTINCT, COUNT and GROUP by Clauses

Lecture 4: Table Relationships

Lecture 5: Introduction to Joins

Chapter 8: MySQL Advanced Statements Part 2

Lecture 1: The Delete Query

Lecture 2: Types of Joins

Lecture 3: Joins Demo

Lecture 4: Creating and Using Views

Lecture 5: Setting Up a Many to Many Relationship

Lecture 6: Demo of Many to Many Relationship

Instructors

EDUmobile Academy
Programming Made Easy

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 10 votes

4 stars: 21 votes

5 stars: 29 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!