Installation of Linux Operating System

Course: 35 Minutes

• Course Introduction
• The Architecture of Linux
• Installing the Linux Operating System
• Working with the Linux Command Line
• Editing a File in Linux
• Configuring a Network Service in Linux

Installation of Apache Web Server

Course: 19 Minutes

• Installing the Apache Web Server
• Verifying the HTTPd Daemon
• Viewing Apache Logs

Installation of MySQL Database Server

Course: 19 Minutes

• Storing Data in a Table in RDBMS
• Installing MySQL on Linux
• Verifying the MySQL Database
• Securing the MySQL Installation
• Configuring the MySQL Server
• Creating a Table and Adding Data

Installation of PHP Packages

Course: 40 Minutes

• Installing PHP Packages
• Using Decision-making Operators in PHP
• Using Loops in PHP
• Connecting PHP with MySQL
• Selecting Data from MySQL Database
• Installing phpMyAdmin
• Administering MySQL Database by Using phpMyAdmin

Practice: Building a LAMP Stack
Course: 9 Minutes

MySQL Improved Extension

Course: 41 Minutes

• Course Introduction
• Comparing MySQLi and PDO
• Installing and Configuring MySQLi
• Using Persistent Connections with MySQLi
• Using Prepared Statement with MySQLi
• Using Stored Procedures with MySQLi
• Executing Multiple Statements with MySQLi
• Creating Transactions by Using MySQLi

Managing MySQL Data by Using MySQLi

Course: 33 Minutes

• Creating Databases and Tables by Using MySQLi
• Inserting Data into a Database by Using MySQLi
• Retrieving Data from Database by Using MySQLi
• Updating Data by Using MySQLi
• Deleting Data by Using MySQLi

Practice: Using MySQLi to Manage Data

Course: 10 Minutes

• Exercise: Connect MySQL with PHP by Using MySQLi

Working with PHP Data Objects

Course: 29 Minutes

• Installing and Configuring PDO
• Creating Connections with PDO
• Creating Transactions and Autocommit by Using PDO
• Using Prepared Statements with PDO
• Using Stored Procedures with PDO
• Handling Errors by Using PDO

Managing Data by Using PDO

Course: 43 Minutes

• Creating Database and Tables by Using PDO
• Inserting Data into a Database by Using PDO
• Retrieving Data from Database by Using PDO
• Updating Data by Using PDO
• Deleting Data by Using PDO

Practice: Using PDO to Manage Data

Course: 10 Minutes

• Exercise: Connect MySQL with PHP by Using PDO10

PHP Applications with the Zend Framework

PHP Frameworks

Course: 13 Minutes

• Course Introduction
• Framework Fundamentals
• MVC Fundamentals
• Zend Framework Concepts
• Installing PHP

Zend Framework Fundamentals

Course: 28 Minutes

• Introducing the Zend Framework
• Development Environment Requirements
• Installing Composer
• Installing the Zend Framework
• Installing the Zend Skeleton Application
• Web Server Configuration

Zend Modules

Course: 30 Minutes

• Zend Module Fundamentals
• Module Directory Structure
• Creating Module Folders (for custom module)
• Creating Module Files
• Zend ModuleManager
• Installing the ZFTool Using Composer
• Creating a Zend Module Using the ZFTool

Controllers and Views

Course: 30 Minutes

Practice: Zend Framework MVC

Course: 9 Minutes

• Exercise: Creating a Test Zend Module

Databases and the Zend Framework

Course: 22 Minutes

• Course Introduction
• Installing MySQL
• Zend Models and Data Persistence
• Creating a Model
• Creating a TableGateway Object
• Configuring the TableGateway Object

Zend Database Actions

Course: 31 Minutes

• Configuring the Database Connection
• Adding a Service Locator
• Configuring the Read Action
• Configuring the Add Action
• Configuring the Edit Action
• Configuring the Delete Action

Practice: Creating a Database Connection

Course: 13 Minutes

• Exercise: Retrieving Data from MySQL

Layout and Navigation

Course: 19 Minutes

• Customizing the Layout
• Adding Breadcrumb Navigation
• Configuring the MVC for Pagination
• Adding the Pagination Bar

Advanced Application Functionality

Course: 43 Minutes

• Internationalization Fundamentals4
• Using the Poedit Tool
• Adding Internationalization (Part 1)
• Adding Internationalization (Part 2)
• Adding Zend\Mail
• Adding Site Authentication
• Authenticating Specific Areas of the Application

Practice: Adding Features to Your Zend App

Course: 6 Minutes