Enquiry




    Web Scripting With PHP

    Learn Php & MySQL

    Introduction to PHP

    • Discuss the history of PHP
    • Identify the need of PHP
    • Learn about PHP tools and setup
    • Write a simple PHP script
    • Learn about user I/O
    • Use PHP to generate HTTP headers
    • Pass variable via URL

    Form Handling in PHP

    • Use the GET method
    • Use the POST method
    • Retrieve data from forms using the form method
    • Use the hidden fields

    Using Variables and Expressions in PHP

    • Define identifiers
    • List the data types
    • Use variables and constants
    • Define scope of variables
    • Use the HTTP environment variables
    • Use the assignment operator
    • Use local variables
    • Use global variables
    • Use static variables

    PHP Operators

    • Use Arithmetic operators
    • Use Logical operators
    • Use rational operators
    • Use Bitwise operators
    • Use Assignment operators
    • Use String operators
    • Use Increment and Decrement operators

    Conditional Statements in PHP

    • Use the If statement
    • Use the Switch statement
    • Use the Ternary (?) operator

    Flow Control in PHP

    • Use Loops
    • Use Jump statements
    • Define a function
    • Use built-in PHP functions
    • Create a user- defined function
    • Pass arguments to a function
    • Return values from a function
    • Use a recursive function

    Working with Arrays

    • Define an array
    • Create and use arrays
    • Merge arrays
    • Use single and multidimensional arrays
    • Use array- related functions

    Handling Databases with PHP

    • Discuss about Database APIs
    • Connect to the database
    • Use data access functions
    • Perform SQL queries using PHP
    • Build HTML tables using SQL queries

    Working with Cookies

    • Set a cookie
    • Retrieve a cookie in PHP
    • Delete a cookie
    • Identify problems with cookies

    Session Management in PHP

    • Define a session
    • Work with the session
    • Start the session
    • Register the session
    • End the session
    • Work with the php.ini file

    Handling E-mail with PHP

    • Send e-mails
    • Attach files with e-mails
    • Explain the OOP concepts
    • Explain inheritances
    • Create classes
    • Create constructors
    • Create and use objects

    Database Handling using MySQL

    Introduction to MySQL as an open source Database

    • List the advantages of MySQL over other RDBMA
    • Differentiate MySQL with other RDBMS.
    • List the advantage of PHP in MySQL.

    Installing and Configuring MySQL

    • Evaluate various distributing options to MySQL.
    • Install MySQL on Windows Platform
    • Install MySQL on Linux platform
    • Configuring MySQL using scripts
    • Initializing MySQL at the startup
    • Install MySQL
    • Configure MySQL using customization scripts

    Using MySQL

    • Create a database
    • Explain a data type
    • Identify the different types of data
    • Create a table
    • Explain the use of Normalization
    • Identify the different forms of Normalization
    • Explain the concepts of Indexes and Referential Integrity

    Implementing the SQL queries using MySQL-1

    • View and alter the database
    • Retrieve data from a table
    • Modify the table definitions
    • Delete table definitions
    • Modify the database
    • Use Select command
    • Use Select command with WHERE clause
    • Modify the table structure
    • Drop the table

    Implementing the SQL queries using MySQL-II

    • Work with Keys
    • Work with Indexes
    • Manipulate tables
    • Manipulate tables with INSERT, MANIPULATE, UPDATE and DELETE
    • Using Order BY
    • Using the Group By Command

    Using Joins

    • Know the basic concepts and reason behind joining tables
    • Use Equi-join
    • Use Outer- join
    • Use self-join
    • Use multiple Select queries in a single Select query
    • Use UNION with the query

    Using Basic Functions in MySQL

    • Use GROUP BY and HAVING clause in MySQL queries
    • Use the Mathematical functions
    • Use the date functions
    • Use String information function
    • Use the system information functions

    Controlling and Managing MySQL database

    • Create User Account
    • Allocate appropriate privileges to users
    • Alter privileges
    • Using GRANT command to assign privileges to user
    • Using REVOKE command to alter privileges granted to users

    Enquire Now

    Php & MySQL Training




      Learn Adobe Photoshop

      ADOBE PHOTOSHOP CC

      This course is designed for Photographers, Digital Designers, Digital Artists and for the Photo enthusiasts.

      Read More

      Adobe InDesign CC

      ADOBE INDESIGN CC

      The industry-leading page design and layout toolset lets you work across desktop and mobile devices to create, preflight, and publish everything from printed books and brochures to digital magazines, eBooks, and interactive online documents.

      Read More

      Adobe Animate CC

      ADOBE ANIMATE CC

      This Adobe Animate training course is geared toward users who have no formal training with Animate and is ideal for digital and traditional designers looking to move further into the interactive realm, and is a great way for you to learn Animate.

      Read More