PHP1: PHP Foundations Training

The PHP I: Foundations course is designed to provide non-programmers with a solid foundation in the PHP language. This course guides you through the basics of PHP with an experiential approach, filled with numerous examples and hands-on exercises. By the end of the course, you will have completed a functioning Blackjack program while you learn the essentials you need to program in PHP.

This course is designed for:

Those who want to learn the basics of the PHP language, and assumes some familiarity with web sites - what they are and the very basics of how they work - but with no programming experience. Web designers who want to become PHP Developers would certainly benefit from this course. This course may also be appropriate for those programmers who have only limited exposure to other languages, or who program in a language whose syntax is very different from PHP (e.g., RPG, COBOL). If you are a programmer in a Procedural or OO language, we recommend you take the Quick Start: PHP for Experienced Programmers course.

Pre-requisite(s)

None

Objective

To learn the basics of the PHP programming language

Topics Include

  • Introduction to Programming Languages
  • PHP Language Basics: Syntax, Quotes, Comments, Data Types
  • PHP Variable Basics: Numbers, Constants, Variables, Strings, Arrays
  • PHP Control Flow Basics: Operators, Conditionals, Loops
  • PHP Functional Basics: Functions, Libraries, Advanced Arrays, File Handling
  • PHP Programming Basics: Best Practices, Debugging, Brief Introduction to HTML
  • PHP Web Basics: Brief Introduction to Server Communications, Sessions, Security
  • PHP Database Basics: Brief Introduction to MySQL/SQLite Database as it relates to Web Sites
  • PHP Applications Basics: Best Approaches to Creating Applications; Course project

Number of days: 45 days


PHP II - PHP Expert Level Training

The PHP II: Higher Structures course is designed to expand a beginning programmer's understanding of the PHP language. This intermediate-level course builds upon knowledge gained in PHP I: Foundations. It utilizes a hands-on approach with numerous examples and practical exercises, primarily related to the course's Blog project, to enhance learning. You will also have the opportunity to use the Zend Studio IDE (Integrated Development Environment) to continue honing your coding skills utilizing best practices and effective tools.

This course is designed for:

This course continues where PHP I: Foundations leaves off, and is designed for novice PHP developers who want to further advance their skills in the PHP language and already know the basics of PHP syntax, language constructs, and web site functionality. Experienced programmers in Procedural and OO languages should refer to the Quick Start: PHP for Experienced Programmers course description. ILE programmers are coached to complete the PHP I: Foundations and PHP II: Higher Structures courses, as the language syntax they are used to be unique and quite different from PHP.

Pre-requisite(s)

PHP I: Foundations, or equivalent knowledge.

Objective

To learn the essentials for creating web-based PHP applications.

Topics Include

  • PHP Language Concepts: Scope, Globals, working with Files, Advanced Variable Usage / Array Manipulation and References
  • Configuring PHP: PHP.INI configuration considerations
  • Regular Expressions: Using Perl-Compatible Regular Expressions in PHP applications
  • PHP and OOP Concepts: Principles of Object Oriented Programming and Design, Access Modifiers, Abstract Classes, Interfaces, and more
  • Building Applications: Debugging, Security and Validation
  • PHP Web Fundamentals: Server Communication, Sessions & Cookies, Working with Forms and Form Validation, Email, HTTP Headers, Buffers & Caches
  • PHP Database Basics: Introduction to manipulating database contents using PHP; PDO
  • PHP Application Essentials: Best Approaches to Creating Applications; Course project

Number of days: 45 days


Get MySQL 5 for Developer Training

  • Do you want to learn how to develop database applications on MySQL?
  • Do you need to use MySQL Stored Procedures, Triggers, Views, and Information Schema?
  • Do you want to create complex reports, use complex queries to retrieve data and aggregate results?
  • Do you want to transfer your data from one server to another?

Then MySQL 5.0 for Developers is for you! With an Authorized MySQL instructor and hands-on exercises you will learn how to develop applications with all the new features of MySQL5.0 This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification.

At the completion of this course, you should be able to

  • Describe the MySQL client/server architecture
  • Understand the steps necessary to invoke MySQL client programs
  • Utilize the general-purpose MySQL client program to run queries and retrieve results
  • Perform queries and analysis of data utilizing the MySQL Query Browser graphical user interface (GUI)
  • Utilize the general-purpose MySQL client program to run queries and retrieve results
  • Explain the MySQL connectors that provide connectivity for client programs
  • Select the best data type for representing information in MySQL
  • Manage the structural characteristics of your databases
  • Manage the structural characteristics of the tables within your databases
  • Utilize the SELECT statement to retrieve information from database tables
  • Utilize expressions in SQL statements to retrieve more detailed information
  • Utilize SQL statements to modify the contents of database tables
  • Write join expressions in your SQL statements to obtain information from multiple tables
  • Utilize sub queries in your SQL statements
  • Create views utilizing SELECT statements to produce "virtual tables" of specific data
  • Perform bulk data import and export operations
  • Create user defined variables, prepared statements and stored routines
  • Create and manage triggers
  • Use the INFORMATION_SCHEMA database to access metadata
  • Debug MySQL applications
  • Configure and Optimize MySQL

Who should attend

Developers who want to learn MySQL 5.0

Pre-requisite(s)

Having some experience with Relational Databases and SQL.