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

Neo4J Fundamentals

Neo4J Fundamentals

Neo4J FundamentalsDuration: 1 DayThis course will give you a foundational knowledge of graph databases and use cases. You'll learn all the getting-started basics, including data import and creation, basic modelling, and querying. Learn to use Neo4j's powerful query...

Introduction to Python Programming

Introduction to Python Programming

Introduction to Python ProgrammingIT PERSONEL involve in DEVELOPMENT/PROGRAMMINGDuration: 3 DaysIn this course, you will learn about and explore the Python language at an introductory level. You will learn to write Python programs dealing with sequences and mappings,...

Introduction to MongoDB

Introduction to MongoDB

Introduction to MongoDBDuration: 4 DaysIntroduction to MongoDB course teaches participants how to use the MongoDB open-source NoSQL document database. Attendees learn Mongo's most compelling use cases and master the fundamentals of Mongo’s features.All students should...