Workshop on PHP with MySQL

PHP is a universally useful server-side scripting language initially intended for Web advancement to deliver dynamic Web pages. It is one of the principal created server-side scripting languages to be installed into a HTML source record as opposed to calling an outer document to process information. MySQL is the world's most utilized open source social database administration framework (RDBMS) that keeps running as a server giving multi-client access to various databases. This is a two day workshop intended for the learners to comprehend the PHP Programming and its utilization with MySQL.

Topics Covered in our Workshop :

Installation
  • Introduction PHP and MySQL
  • PHP Installation
  • MySQL Installation
  • Apache Installation.
  • XAMPP and WAMPP Installation
PHP Basics
  • Embedding PHP in HTML
  • Embedding HTML in PHP
  • Introduction Variable Using variables
  • Understanding Data Types Using Operators
  • Writing Statements and Comments Using Conditional Statements
  • If(), else if() and else if condition Statement
Arrays and Custom Functions:
  • Creating an Array
  • Modifying Array Elements
  • Processing Arrays with Loops
  • Grouping Form Selections with Arrays Using Array Functions
  • Creating User-Defined Functions
  • Defining and Invoking Functions
Using PHP with MySQL
  • Managing Database Connections
  • Performing Queries
  • Processing Result Sets
  • Queries Which Return Data
  • Queries That Alter Data
  • Handling Errors
  • Using Ancillary Functions
Creating basic programs with PHP
  • Reading and Writing Files
  • Reading Data from a File
  • Writing Data to a File
  • Testing File Attributes.
  • Managing Sessions and Using Session Variables
  • Creating a Session and Registering Session Variables
  • Destroying a Session
  • Storing Data in Cookies
  • Setting Cookies
  • Retrieving Cookie Data
  • Dealing with Dates and Times
  • Executing External Programs
HTML Basics
  • Creating Forms with HTML
Working with Databases and Tables
  • Creating Databases
  • Creating Tables
  • Specifying Field Data Types
  • Selecting the Most Appropriate Data Type
  • Adding Field Modifiers and Keys
  • Selecting a Table Type
  • Altering Tables
  • Altering Table and Field Names
  • Altering Field Properties
  • Adding and Removing Fields and Keys
  • Altering Table Types
  • Backing Up and Restoring Databases and Tables
  • Backing Up Databases and Tables
  • Restoring Databases and Tables from Backup
  • Dropping Databases and Tables
  • Viewing Database, Table, and Field Information
Editing Records and Performing Queries
  • Inserting Records
  • Editing and Deleting Records
  • Performing Queries
  • Retrieving Specific Columns
  • Filtering Records with a WHERE Clause
  • Using Operators
  • Sorting Records and Eliminating Duplicates
  • Limiting Results
  • Using Built-In Functions
  • Grouping Records
  • Joining Tables
  • Using Sub queries
  • Using Table and Column Aliases
Eligibility Criteria :

As we are conducting a very basic level workshop so no specific criteria is defined anyone willing to do career in animation or having interest in the same are welcomed for the Workshop

Duration :

Workshop duration will be two back to back days with eight hour session each day. Each day is divided in proper theory and hands on practical session.

We Are Arranging Customized Corporate Training Programs Hence All Our Workshops Are Conducted As Per The Client Requirement. Most Of Corporate Training Workshops Are Conducted On Weekends.

Contact Us