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!

What you'll learn
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
Requirements
A text editor and a passion for learning.
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.*Updated July 2017: Close captions in English added.


Overview

Section 1: PHP Programming Training Course

Lecture 1 Course Objectives; PHP Definition, Syntax, Key Words and Tags

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 PHP Course Exercise Files

Lecture 4 PHP Development Environment; Whitespace and Comment

Lecture 5 Variables; Exercise 2

Lecture 6 Echo vs. Print; Single vs. Double Quotes

Lecture 7 Operators

Lecture 8 Controlling the Flow of Execution; Exercise 3

Lecture 9 Repeating Codes; Exercise 4

Lecture 10 Debugging PHP; Scaffolding Code

Lecture 11 Arrays; Exercise 5

Lecture 12 Functions - Part 1

Lecture 13 Functions - Part 2; Exercise 6

Lecture 14 External PHP

Lecture 15 Runtime Error Handling

Lecture 16 Reading and Writing to a File

Lecture 17 Reading a Configuration File; Exercise 7

Lecture 18 Form Processing; Cookies and Sessions Superglobals; Exercise 8

Lecture 19 Database Storage - Part 1

Lecture 20 Database Storage - Part 2

Lecture 21 Object-Oriented Development - Part 1

Lecture 22 Object-Oriented Development - Part 2

Lecture 23 Object-Oriented Development - Part 3

Lecture 24 Inheritance Demo

Lecture 25 Exercise 9

Lecture 26 Common Threats

Lecture 27 Security Demo and Exercise 10

Lecture 28 PHP Built-in Constants and Standard PHP Library

Lecture 29 Standard PHP Library Demo - Part 1

Lecture 30 Standard PHP Library Demo - Part 2

Lecture 31 SPL Data Structures and Exception Types

Lecture 32 SPL Data Structures Demo

Lecture 33 SPL Exception Types Demo; Exercise 11

Lecture 34 Relational Database Management Systems and SQL Language

Lecture 35 SQL Statement

Lecture 36 Select Statement Demo - Part 1

Lecture 37 Table Joins and Union

Lecture 38 Select Statement Demo - Part 2

Lecture 39 Joins Demo

Lecture 40 Insert, Update and Delete Commands; Aggregate Functions

Lecture 41 Queries and Store Procedure

Lecture 42 Design Pattern Categories

Lecture 43 Singleton Pattern Demo

Lecture 44 Observer Pattern Demo

Section 2: MySQL Training Course

Lecture 45 Course Outline and Intro to MySQL and Database

Lecture 46 READ ME: Essential Information for a Successful Training Experience

Lecture 47 Course Review

Lecture 48 MySQL Architecture and Installation of MySQL

Lecture 49 Installation Demo - Part 1

Lecture 50 Installation Demo - Part 2

Lecture 51 Database Design

Lecture 52 MySQL Workbench Download

Lecture 53 Database Table and Constraints

Lecture 54 Database Designing and Normalization - Part 1

Lecture 55 Database Designing and Normalization - Part 2

Lecture 56 Storage and Data Types

Lecture 57 Data Types Demo

Lecture 58 ACID and Transactions

Lecture 59 Locks, Deadlocks, Isolation Levels and Logging

Lecture 60 Isolation Levels and Locking Demo

Lecture 61 Locking Mechanism Demo and MySQL ACID Support

Lecture 62 Responsibilities of a Database Administrator

Lecture 63 Creating a User and Limiting Access to a Database; Basic Maintainance Function

Lecture 64 Protecting your Database; How to Perform Database Backup

Lecture 65 Performance Monitoring

Lecture 66 InnoDB Indexing and Clustered vs. Unclustered Index

Lecture 67 Query and Where Clause

Lecture 68 Impact of Indexing on Database Performance

Lecture 69 Performance Optimization

Lecture 70 Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers

Lecture 71 Data Definition Language; How to Create Database Objects

Lecture 72 SQL Select Statements

Lecture 73 SQL Select Statements Demo

Lecture 74 Joins

Lecture 75 Combining Related Table Using Joins

Lecture 76 Insert, Update and Delete Commands

Lecture 77 Insert, Update, and Delete Commands Demo

Lecture 78 Query Optimization

Lecture 79 Query Optimization Demo

Lecture 80 Database Replication

Lecture 81 Setting Up Replication in MySQL

Lecture 82 Data Encryption

Lecture 83 High Availability

Lecture 84 Course Wrap-up

Lecture 85 Column-Level Database Encryption Demo

Anyone new to PHP,Anyone new to databases,Web developers