COURSE 5375 | 3-day SESSION
PHP Programming with MySQL
The course addresses ETL to load a data warehouse, database synchronization, Web services access, file transformation, and other capabilities. At the end of this course, users will be able to model their needs, generate jobs and deploy them.
Begin mastering the most popular dynamic Web development technology
PHP is the most commonly used programming language for creating non-static Web sites. PHP’s syntax is simple and easy-to-read, making it an ideal language for those new to programming. Still, PHP’s capabilities are virtually limitless, allowing seasoned programmers to push the boundaries of what’s possible. PHP developers can get started with no initial costs, creating projects that run on every major operating system, interacting with all the common technologies in use today. This 3-day hands-on course will provide Web developers with all of the knowledge and experience they need to begin creating dynamic Web applications today.
During this class, you will:
- Understand the benefits and uses of dynamic Web sites
- Learn how to program in PHP
- See how to design and develop databases
- Become conversant with SQL and MySQL
- Leave with tons of usable code
- Run through many real-world, in-class programming examples
Advantages of PHP:
- Easy to learn, easy to use
- Virtually limitless in usage
- Runs on most operating systems
- Works well with MySQL and other databases
- Lots of free support, code, tutorials, and more available online
Real-World Examples
- Testing a PHP installation
- Creating an HTML form
- Handling HTML forms with PHP
- Validating form data
- Storing submitted data in a database
- Retrieving records from a database
- Creating multi-page applications
- Using templates
Prerequisites:
There are no absolute prerequisites, although attendees will find it easier to follow along and do in-class exercises if they have some experience with any of the following:
- (X)HTML and Web development
- JavaScript or any programming language
- Any database application
Application Areas Include:
- Handling user-submitted data
- Data warehousing
- State maintenance over multiple pages
- Sending emails
- Web application development
Features of PHP:
- Simple, easy-to-read syntax
- Extremely flexible
- Supports both procedural and Object Oriented programming
- Integration with all popular tangential technologies
- Open-source
Immediate Objectives of Attending this Class
- Understand the benefits and uses of dynamic Web sites
- Learn how to program in PHP
- See how to design and develop databases
- Become conversant with SQL and MySQL
- Leave with tons of usable code
- Run through many real-world, in-class programming examples
- Leave this class prepared to build an open-source enterprise web application!
You Will Quickly Learn How To:
- Handle HTML form data using PHP
- Store information in a database
- Retrieve information from a database
- Create multi-page Web applications
- Save time by making your sites modular, from the ground up
- Build User authentication
- Perform Data validation
- Configure PHP
- Leverage XHTML
- Use and manipulate arrays
- Interact with database applications using three different interfaces
- Debug Web applications efficiently and with a minimum of frustration
- Use the full power of a database
- Provide a natural, seamless interaction for a website's end user
Who Should Attend:
This class provides essential skills for anyone who wants to
understand how to harness the two powerful open-source
technologies of PHP and MySQL in tandem to develop
dynamic, efficient programming results. Invaluable for:
- Web Developers
- IT Managers
- Project Managers
- Business Analysts
- Application Developers
- Data Analysts
- Programmers
- Webmasters
|
