Think Career in IT
Think Steps......

IT Training from the masters

PHP-MySql

In PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics.In our MySQL Training we are covering from the basic SQL Queries and we are integrating that into PHP. By most of the web applications all around the world using the open source technologies as a mixture and it makes more impact in our daily life. For example, PHP, MySQL with Apache is the perfect combination for any web applications.

HTML
  • Markup Languages.
  • Structure of HTML.
  • Basic HTML Tags.
  • Advanced HTML Tags.
  • Difference between HTML & XHTML.
  • XHTML Basics.
  • Introduction to Doc Types.
CSS
  • Introduction to Cascading Style Sheets.
  • Types of Style Sheets.
  • Types of CSS Selectors.
  • CSS properties.
  • Converting Table layout to CSS.
  • Custom CSS Layout Design.
  • Creating simple and dropdown menus.
  • Creating Appealing forms using CSS.
  • CSS Tips and Optimization Techniques.
PHP
  • Introduction PHP, PHP Installation.
  • Apache Installation.
  • PHP Basics , Arrays and Custom Functions.
  • Creating basic programs with PHP.
  • Editing Records and Performing Queries.
  • PHP with MySQL.
  • Creating Forms with HTML.
  • Validations with JavaScript.
  • Joomla
  • Jquery
  • Project.
  • Zend FrameWork (MVC pattern programming )
MySQL
  • Introduction Mysql.
  • MySQL Installation.
  • Working with Databases and Tables.
  • SQL Query
    • AND , OR , NOT , NOTIN
    • WHERE / HAVING
    • ORDER BY
    • BETWEEN
    • LIKE OPERATOR
    • DISTINCT
    • NESTED QUERY ( SET COMPARISON, CO-RELATED SUBQUERY)
      • JOINS
      • EXISTS / NOT EXISTS OPERATOR
      • CONTROL FLOW FUNCTIONS
    • CASE()
      • UNION, UNION ALL
      • LIMIT CLAUSE
  • BUILD IN FUNCTIONS
    • STRING FNCTIONS
    • LENGTH()
    • INSTR()
    • LOCATE()
    • CONCAT()
    • CONTAC_WS()
    • REPLACE()
    • SUBSTRING()
    • REPEAT()

Courses