Learn Php And Mysql For Beginners The Easy Way - 13 Hours

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


Homepage

https://www.udemy.com/course/learn-php-and-mysql-training-course/