Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

PHP & MySQL

}
Duration: 5 Days

Essentially three courses in one: provides thorough introductions to the PHP language and the MySQL database, and shows how these two technologies can be effectively integrated to build powerful websites. When it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. With this course, and there’s no limit to the powerful, interactive Web sites that developers can create.

In this 5 days training will basically covers step-by-step instructions, complete scripts, and tips to guide trainee. Not only this training includes the discussions on the scripting language (PHP) and then the database program (MySQL), it also goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This training is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic.

Basic programming language
Lesson 1: Introduction to PHP

  • Basic Syntax
  • Sending Data to the Web Browser
  • Understanding PHP, HTML, and White Space
  • Writing Comments
  • What Are Variables?
  • Introducing Strings
  • Concatenating Strings
  • Introducing Numbers
  • Introducing Constants
  • Single vs. Double Quotation Marks

Lesson 2: Programming with PHP

  • Creating in HTML Form
  • Handling an HTML Form
  • Conditionals and Operators
  • Validating Form Data
  • Introducing Arrays
  • For and While Loops

Lesson 3: Creating Dynamic Web Sites

  • Including Multiple Files
  • Handling HTML Forms, Revisited
  • Making Sticky Forms
  • Creating and Calling Your Own Functions

Lesson 4: Introducing to MySQL

  • Naming Database Elements
  • Choosing Your Column Types
  • Choosing Other Column Properties
  • Accessing MySQL

Lesson 5: Introduction to SQL

  • Creating Databases and Tables
  • Inserting Records
  • Selecting Data
  • Using Conditionals
  • Using LIKE and NOT LIKE
  • Sorting Query Results
  • Updating Data
  • Deleting Data
  • Using Functions

Lesson 6: Advanced SQL and MYSQL

  • Database Design
  • Performing Joins
  • Grouping Selected Results
  • Creating Indexes
  • Using Different Table Types
  • Performing FULLTEXT Searches
  • Performing Transactions

Lesson 7: Error Handling and Debugging

  • Error Types and Basic Debugging
  • Displaying PHP Errors
  • Adjusting Error Reporting in PHP
  • Creating Custom Error Handlers
  • PHP Debugging Techniques
  • SQL and MySQL Debugging Techniques

Lesson 8: Using PHP with MYSQL

  • Modifying the Template
  • Connecting to MySQL
  • Executing Simple Queries
  • Retrieving Query Results
  • Ensuring Secure SQL
  • Counting Returned Records
  • Updating Records with PHP

Lesson 9: Common Programming Techniques

  • Sending Values to a Script
  • Using Hidden Form Inputs
  • Editing Existing Records
  • Paginating Query Results
  • Making Sortable Displays

Lesson 10: Web Application Development

  • Sending Email
  • Date and Time Functions
  • Handling File Uploads
  • PHP and JavaScript
  • Understanding HTTP Headers

Lesson 11: Cookies and Sessions

  • Making a Login Page
  • Defining the Login Functions
  • Using Cookies
  • Using Sessions
  • Improving Session Security

Lesson 12: Security Methods

  • Preventing Spam
  • Validating Data by Type
  • Preventing XSS Attacks
  • Preventing SQL Injection Attacks
  • Database Encryption

Lesson 13: Perl-compatible Regular Expressions

  • Creating a Test Script
  • Defining Simple Patterns
  • Using Quantifiers
  • Using Character Classes
  • Finding All Matches
  • Using Modifiers
  • Matching and Replacing Patterns

Lesson 14: Making Universal Sites

  • Character Sets and Encoding
  • Creating Multilingual Web Pages
  • Unicode in PHP
  • Collation in PHP
  • Transliteration in PHP
  • Languages and MySQL
  • Time Zones and MySQL
  • Working with Locales

Register Now

Drop us your entry if you are interested to join this course.

 


You may like

RapidMiner Certification

RapidMiner CertificationThe Rapidminer Certification program offers role-based certification for different knowledge domains and levels. The first level is called "Professional" and the second level is "Master". All certificates can be earned independent of each...

Flagship Program

Big Data Journey Flagship ProgramProject Objective: Provide guidance and experience sharing for identified personnel in preparing them to be part of the team behind data anlaytics initiative in the future. An end-to-end training program to get your organization along...

Using Pig, Hive, and Impala with Hadoop

Using Pig, Hive, and Impala with Hadoop

Using Pig, Hive, and Impala with HadoopDuration: 3 DaysThrough instructor-led discussion and interactive, hands-on exercises, participants will navigate the Hadoop ecosystem, learning topics such as: The features that Pig, Hive, and Impala offer for data acquisition,...