SQL Certification Training in Houston

Syllabus of PHP & MySQL Certification Course in Houston

• What is PHP?
• The history of PHP
• Why choose PHP?
• Installation overview

• Embedding PHP code on a page
• Outputting dynamic text
• The operational trail
• Inserting code comments

• Variables
• Strings
• String functions
• Numbers part one: Integers
• Numbers part two: Floating points
• Arrays
• Associative arrays
• Array functions
• Booleans
• NULL and empty
• Type juggling and casting
• Constants

• If statements
• Else and elseif statements
• Logical operators
• Switch statements

• While loops
• For loops
• Foreach loops
• Continue
• Break
• Understanding array pointers

• Defining functions
• Function arguments
• Returning values from a function
• Multiple return values
• Scope and global variables
• Setting default argument values

• Common problems
• Warnings and errors
• Debugging and troubleshooting

• Links and URLs
• Using GET values
• Encoding GET values
• Encoding for HTML
• Including and requiring files
• Modifying headers
• Page redirection
• Output buffering

• Building forms
• Detecting form submissions
• Single-page form processing
• Validating form values
• Problems with validation logic
• Displaying validation errors
• Custom validation functions
• Single-page form with validations

• Working with cookies
• Setting cookie values
• Reading cookie values
• Unsetting cookie values
• Working with sessions

• MySQL Certification introduction
• Creating a database
• Creating a database table
• CRUD in MySQL
• Populating a MySQL Certification database
• Relational database tables
• Populating the relational table

• Database APIs in PHP
• Connecting to MySQL Certification with PHP
• Retrieving data from MySQL
• Working with retrieved data
• Creating records with PHP
• Updating and deleting records with PHP
• SQL Certification injection
• Escaping strings for MySQL
• Introducing prepared statements

• Blueprinting the application
• Building the CMS database
• Establishing your work area
• Creating and styling the first page
• Making page assets reusable
• Connecting the application to the database

• Adding pages to the navigation subjects
• Refactoring the navigation
• Selecting pages from the navigation
• Highlighting the current page
• Moving the navigation to a function

• Finding a subject in the database
• Refactoring the page selection
• Creating a new subject form
• Processing form values and adding subjects
• Passing data in the session
• Validating form values
• Creating an edit subject form
• Using single-page submission
• Deleting a subject
• Cleaning up
• Assignment: Pages CRUD
• Assignment results: Pages CRUD

• The public appearance
• Using a context for conditional code
• Adding a default subject behaviour
• The public content area
• Protecting page visibility

• User authentication overview
• Admin CRUD
• Encrypting passwords
• Salting passwords
• Adding password encryption to CMS
• New PHP password functions
• Creating a login system
• Checking for authorization
• Creating a logout page

• Using variable variables
• Applying more array functions
• Building dates and times: Epoch/Unix
• Formatting dates and times: Strings and SQL
• Setting server and request variables
• Establishing global and static variable scope
• Making a reference assignment
• Using references as function arguments
• Using references as function return values

• Introducing the concept and basics of OOP
• Defining classes
• Defining class methods
• Instantiating a class
• Referencing an instance
• Defining class properties

• Understanding class inheritance
• Setting access modifiers
• Using setters and getters
• Working with the static modifier
• Reviewing the scope resolution operator
• Referencing the Parent class
• Using constructors and destructors
• Cloning objects
• Comparing objects

• File system basics
• Understanding file permissions
• Setting file permissions
• PHP permissions
• Accessing files
• Writing to files
• Deleting files
• Moving the file pointer
• Reading files
• Examining file details
• Working with directories
• Viewing directory content

• Configuring PHP for email
• Sending email with mail()
• Using headers
• Reviewing SMTP
• Using PHPMailer