PHP and MySQL Training

MODULES:

PHP SYLLABUS

- PHP Basics - Syntax, Operators, Variables, Constants, Control Structures, Language Constructs and Functions
- Functions - Syntax, Arguments, Variables, References, Returns, Variable Scope
- Arrays - Enumerated Arrays, Associative Arrays, Array Iteration, Multi-Dimensional Arrays, Array Functions, SPL
- PHP 4/5 Differences - Object Orientation, E_STRICT, References vs. Object Handles
- File Systems and Upload - Copying, renaming, deleting, uploading, uploading security
- Security - Configuration, Session Security, Cross-Site Scripting, Cross-Site Request Forgeries, SQL Injection, Remote Code Injection, Email Injection, Filter Input, Escape Output
- Strings and Patterns - Quoting, Matching, Extracting, Searching, Replacing, Formatting, PCRE
- Databases and SQL - SQL, Joins, Analyzing Queries, Prepared Statements, Transactions
- Web Features - Sessions, Forms, GET and POST data, Cookies, HTTP Headers

Advanced PHP SYLLABUS

- Object Oriented Programming - Instantiation, Modifiers/Inheritance, Interfaces, Exceptions, Static Methods and Properties, Autoload, Reflection, Type Hinting, Class Constants
- XML and Web Services - XML Basics, SimpleXML, XML Extensions, Xpath, Webservices Basics, SOAP, REST
- Streams/Network Programming - Files, Reading, Writing, File System Functions, Streams
- Design and Theory - IDesign Patterns, Code Reuse, OOP Theory

MYSQL SYLLABUS

-Theory, Terminology and Concepts - Client/Server Concepts, Database and Database Objects,
- Data Definition using SQL - Databases, Data Types, Tables, Constraints and Indexes, Views
-Basic Data Manipulation using SQL - Recurring SQL Constructs, Adding data, Modifying data, Removing data, Searching data
-Advanced Data Manipulation using SQL - Expressions, Grouping and Aggregate Functions, Joining Tables
-Transactions - Transaction Concepts, SQL for working with Transactions
-Import/Export - Tools for Import/Export, SQL for Import/Export