PHP 5 & PostgreSQL Bootcamp
PHP 5 and PostgreSQL Bootcamp is five intensive days of hands-on programming designed for web application developers who need to master web design with PHP 5 driven by a PostgreSQL database back-end.
PHP 5 & PostgreSQL Bootcamp is designed for:
- Individuals with experience in a scripting language interested in gaining a deep understanding of PHP and PostgreSQL
- HTML-savvy individuals seeking a richer web experience for their customers
- WYSIWYG veterans looking to move far beyond GUI-based website development
Upon completion of PHP 5 & PostgreSQL Bootcamp, the student will:
- Use PHP and PostgreSQL to build a complete CRM website and application
- Understand how to integrate PHP and PostgreSQL with complementary web technologies (e.g., CSS, XML, pdf, AJAX) to produce professional web solutions
- Implement security measures to prevent the most common kinds of attacks in a web environment
- Understand how to integrate third-party libraries (e.g., PEAR) into PHP applications, dramatically reducing development time
Prerequisites
For best results, students should have some experience with HTML.
Syllabus
| Section | Contents |
|---|---|
| PHP 5 Fundamentals | Introduction to variables, decision-making, and loops |
| Functions | Learning how to use existing PHP5 functions and write your own |
| Objects | Understanding PHP5's implementation of object-oriented programming concepts |
| Arrays | Learning how to manage groups of scalars, objects |
| Databases | Using PDO as a lightweight data access layer to a PostgreSQL database |
| Dynamic Web Pages | Integrating PHP and PostgreSQL to produce a public-facing web page |
| Dates and Times | Mastering PHP5's date and time model |
| Multidimensional Arrays | Dealing with arrays of arrays, most commonly encountered with record sets retrieved from a database |
| State in a Stateless Land | How to manage different page states (e.g., list, edit, save, and delete) in the essentially stateless web environment |
| Views | Understanding PostgreSQL Views |
| Dynamic Functions | Using variables to make dynamic function calls |
| Advanced SQL | Introduction of aggregate functions, case statements, and subselects |
| Form Handling | Using PEAR::HTML_Quickform and PDO to manage form and related database content |
| Javascript | Introduction to javascript |
| Remembering Users | Learning how cookies and session variables interact to establish user identity |
| Security | Implementing common sense solutions to common web-based security concerns |
| Archiving | Managing different deletion strategies from the PHP5 and PostgreSQL perspective |
| XML | Introduction to XML on the web, including how to create an RSS feed |
| Web Services | Implementing web services to provide functionality external to the core web application |
| File Upload | Handling PHP5 file uploads, with either a file-system or PostgreSQL solution. |
| AJAX | Integrating AJAX into PHP5 and PostgreSQL web applications |
| FPDF | Introduction to FPDF, a lightweight PHP5-based library for producing dynamic PDFs on the web |
| Graphics | Using the PHP5 GD library to produce web graphics |
Onsite Training
We offer onsite training for PHP 5 & PostgreSQL Bootcamp: we provide an instructor and all class materials. You'll provide the classroom set up, computers for all students, a projector, and a screen. If you find that you'd like to see some customization of the class syllabus to fit a specific project or priority, we can do that too. To get a quote, talk about the syllabus, or ask general questions about onsite training, call us at (404) 527-6211.
What's Included
Class price includes all class materials, a luxury room, three delicious meals a day, a stylish Big Nerd Ranch t-shirt, and ground transportation to and from the airport. Plan to arrive the afternoon or evening before your class begins and depart on the last day of your class after 4 PM.