Learn PHP and MySQL for Beginners the Easy Way - 13 Hours

Learn PHP and MySQL and get ready to take your web development skills to the next level!
4.0 (12 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
3,796 students enrolled
$19
$70
73% off
Take This Course
  • Lectures 84
  • Length 12 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2013 English

Course Description

Discover how to use PHP and MySQL, a popular choice for developing powerful web applications!

These days, you’re nowhere without a website, so there’s a huge value to web development skills. PHP is one of the most widely-used scripting languages around, and this course will help you master the basics of the language so that you can build your own website, or help refine your company’s. Discover the power of PHP as you take your website development skills to the next level.

During the 6.5 hour PHP beginner course, discover the fundamental concepts beginner PHP developers need to master. Your professional instructor combines practical lectures that ensure you have a solid grasp of the basics with coding examples that include exercise files so you get real hands-on practice.

Follow along as you learn the PHP syntax, development environment, and other basic concepts. Discover more advanced topics including database storage, object oriented development, using the standard PHP library, and basic SQL language commands.

This course includes exercise example files, certificate of completion, and quiz.

During the 5.5-hour MySQL beginner course, discover the fundamental concepts beginner MySQL administrators need to master. Your professional instructor combines practical lectures that ensure you have a solid grasp of the basics with practical examples that include exercise files so you get real hands on practice.

Follow along as you learn how to install MySQL for the first time. Discover critical concepts for designing a database. Explore how to administrate a MySQL database including limiting access, creating users, database backup and performance monitoring. Then get ready to take your MySQL skills to the next level as you learn SQL for developers, database replication, data encryption and more.

This course includes a certificate of completion, and quiz.

What are the requirements?

  • A text editor and a passion for learning.

What am I going to get from this course?

  • By the end of the course, you will have a foundation of PHP and MySQL knowledge
  • Discover how to use PHP variables
  • How to debug PHP code
  • Learn how to read a configuration file
  • Discover the basics of using a PHP library
  • Common security threats
  • Understanding MySQL architecture and installation of MySQL
  • Learning database design
  • Administration of a database
  • Using indexing for database performance
  • Discover SQL for Developers
  • Understanding query analysis and optimization
  • Setting up replication in MySQL

What is the target audience?

  • Anyone new to PHP
  • Anyone new to databases
  • Web developers

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: PHP Programming Training Course
Course Objectives; PHP Definition, Syntax, Key Words and Tags
Preview
11:20
IMPORTANT - Read this to ensure the best video quality!
Article
PHP Development Environment; Whitespace and Comment
Preview
07:40
PHP course exercise files
Article
Variables; Exercise 2
11:00
Echo vs. Print; Single vs. Double Quotes
Preview
05:42
Operators
11:28
Controlling the Flow of Execution; Exercise 3
11:18
Repeating Codes; Exercise 4
11:42
Debugging PHP; Scaffolding Code
Preview
04:54
Arrays; Exercise 5
10:55
Functions - Part 1
11:39
Functions - Part 2; Exercise 6
13:52
External PHP
Preview
07:42
Runtime Error Handling
10:34
Reading and Writing to a File
11:53
Reading a Configuration File; Exercise 7
08:07
Form Processing; Cookies and Sessions Superglobals; Exercise 8
10:04
Database Storage - Part 1
05:04
Database Storage - Part 2
12:33
Object-Oriented Development - Part 1
13:01
Object-Oriented Development - Part 2
13:02
Object-Oriented Development - Part 3
04:37
Inheritance Demo
13:38
Exercise 9
01:59
Common Threats
02:44
Security Demo and Exercise 10
12:53
PHP Built-in Constants and Standard PHP Library
12:34
Standard PHP Library Demo - Part 1
10:13
Standard PHP Library Demo - Part 2
07:10
SPL Data Structures and Exception Types
08:44
SPL Data Structures Demo
14:57
SPL Exception Types Demo; Exercise 11
08:06
Relational Database Management Systems and SQL Language
05:50
SQL Statement
07:48
Select Statement Demo - Part 1
14:13
Table Joins and Union
05:36
Select Statement Demo - Part 2
14:47
Joins Demo
04:08
Insert, Update and Delete Commands; Aggregate Functions
08:01
Queries and Store Procedure
05:58
Design Pattern Categories
06:12
Singleton Pattern Demo
08:52
Observer Pattern Demo
06:52
PHP Programming Quiz
40 questions
Section 2: MySQL Training Course
Course Review
00:43
Course Outline and Intro to MySQL and Database
Preview
10:11
MySQL Architecture and Installation of MySQL
Preview
15:55
Installation Demo - Part 1
Preview
03:35
Installation Demo - Part 2
09:37
Database Design
08:46
MySQL Workbench Download
07:34
Database Table and Constraints
09:39
Database Designing and Normalization - Part 1
11:51
Database Designing and Normalization - Part 2
08:10
Storage and Data Types
05:25
Data Types Demo
11:20
ACID and Transactions
09:44
Locks, Deadlocks, Isolation Levels and Logging
07:16
Isolation Levels and Locking Demo
12:43
Locking Mechanism Demo and MySQL ACID Support
06:22
Responsibilities of a Database Administrator
03:41
Creating a User and Limiting Access to a Database; Basic Maintainance Function
10:34
Protecting your Database; How to Perform Database Backup
07:44
Performance Monitoring
10:49
InnoDB Indexing and Clustered vs. Unclustered Index
14:17
Query and Where Clause
05:28
Impact of Indexing on Database Performance
10:33
Performance Optimization
07:49
Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers
13:16
Data Definition Language; How to Create Database Objects
12:27
SQL Select Statements
Preview
07:48
SQL Select Statements Demo
10:19
Joins
05:36
Combining Related Table Using Joins
16:06
Insert, Update and Delete Commands
06:08
Insert, Update, and Delete Commands Demo
08:47
Query Optimization
03:40
Query Optimization Demo
06:39
Database Replication
06:39
Setting Up Replication in MySQL
04:57
Data Encryption
05:13
High Availability
10:43
Course Wrap-up
04:08
Column-Level Database Encryption Demo
04:44
MySQL Quiz
40 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Over 270,000 Students, Used in 180 Countries, 115 Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Ready to start learning?
Take This Course