PHP and MYSQL - advanced

The Advanced PHP and MySQL training course delves deeper into topics introduced in basic PHP and MySQL training module and explores a number of intermediate to advanced topics. Discover ways to secure entire website and protect information in database. Learn how to design a database for optimum speed. Explore programming techniques that go beyond the fundamentals. Combine PHP with Flash, CSS and JavaScript to create some amazing web applications.

This Advanced PHP and MySQL class is suitable for those who have significant knowledge and skills with PHP and MySQL.

By attending Advanced PHP and MySQL workshop, Delegates will learn to:

  • Develop a web application that allows users to create, preview, and send a customized Flash greeting card
  • Combine PHP with CSS to create dynamically styled web pages
  • Discover ways to gather useful information about visitors to their site and track user information
  • Create a secure script that allows visitors to upload files to the web server
  • Understand where to use arrays, loops and alternative conditional operators
  • Create, change, and remove records in a database
  • Learn how to design database tables to maximise speed and minimise data corruption
  • Perform advanced MySQL searches
  • Use MySQL joins to combine data from various tables and generate usable reports
  • Understand how to set up a secure website so that information cannot be intercepted and read during transmission
  • Learn how to encrypt and decrypt data
  • Use best practices to store data securely on a server so that it cannot be deciphered even by the server administrator

COURSE AGENDA

  • Deleting
  • Updating and replacing
  • Fixing typos in MySQL
  • Limiting
  • Ordering
  • Case-sensitive searches
  • Normalisation
  • Table Joins
  • References
  • Alternative conditional operators
  • Arrays
  • Loops
  • Tracking user information
  • Using code to display images
  • Uploading files securely
  • Error reporting
  • Register globals
  • Webpage encryption
  • Creating a server certificate and key
  • Working with SSL in development environment
  • Making sure a page is always encrypted
  • Database encryption and decryption techniques
  • Personalised Flash greeting card and a sticky form
  • Dynamic CSS menus
  • Breadcrumbs
  • Session variables

Copyright © 2025 All Rights Reserved by Cuesys Infotech.

Designed By  99 DESIGN AGENCY