PHP and MySQL with JQuery Programming

img

Become an Ogma TechLab certified PHP & MySQL Professional. An Industrial Vocational course designed to make you an expert in using PHP & MySQL and learn all that is required to create real world web applications with PHP & MySQL.

About the Course

Ogma TechLab’s PHP & MySQL with JQuery, will introduce attendees to PHP, MySQL and JQuery & Ajax Progamming. This course will cover aspects of how to use PHP, MYSQL along with jQuery & Ajax to create powerful and easy to maintain database driven websites. This course will also cover installation & Configuration of PHP, MySQL with JQuery and Ajax. Attendees will get to implement one project towards the end of the course.

Course Objective

After the completion of the ‘PHP & MySQL with JQuery Programming’ Course at Ogma TechLab, you should be able to:
  • 1. Understand the basics of the Web Technology
  • 2. Learn all major concepts of PHP and MySQL that beginner developers need to master
  • 3. Round off your application development skills by understanding how to implement PHP on a website using JQuery and Ajax
  • 4. Gain the PHP programming skills needed to successfully build interactive, data-driven sites
  • 5. Create forms easily using helper functions and work with form data
  • 6. Use cookies and sessions with helper functions
  • 7. Work with regular expressions, handle exceptions, and validate data
  • 8. Work with PHP text mails and HTML emails
  • 9. How to use and create functions
  • 10. Object oriented concepts
  • 11. Uploading files to server
  • 12. Manipulate system files
  • 13. Able to architect, write, debug, and run complete web applications
  • 14. Test and debug a PHP application
  • 15. Become a proficient PHP/MySQL web developer using MVC architecture

Who should go for this course?

This course can be taken by anyone who wants to be a Web Developer or wants to learn PHP & MySQL with a Jquery and Ajax

Pre-requisites

Basic HTML knowledge, basic understanding of computer programming language, internet, database, especially RDBMS

Why learn PHP & MySQL?

PHP scripting and MySQL database are one of the world’s most popular open source techniques used to develop websites. Add an advantage of a MVC framework to it and you can develop powerful, dynamic and easy to maintain database driven websites. The CakePHP MVC architect also adds some additional security against threats like SQL injections, hacking etc.

Curriculum

  • img Lecture 1

    HTML – Introduction to HTML, HTML5 elements and HTML5 tags, Images, HTML5 list, HTML5 Table, HTML5 Form Div
  • img Lecture 2

    Introduction to CSS, CSS Selector, Applying CSS – Internal, External, Inline, CSS Class and ID
  • img Lecture 3

    JavaScript – Introduction, Variables, Statements, Operator, Conditional Statement, Loop, User Define Functions
  • img Lecture 4

    JQuery – Basic idea about JQuery, Advantage of JQuery, Simple but essential application of jquery, Form validation using jquery
  • img Lecture 1

    Introduction to PHP
  • img Lecture 2

    Embedding HTML with PHP
  • img Lecture 3

    Data Types
  • img Lecture 4

    Declaring variables, Operators, Conditional Statement & Loops
  • img Lecture 5

    Different types of Array, Inbuilt essential array
  • img Lecture 6

    Functions – Inbuilt essential string manipulation functions, User define functions, Data and Time functions, Forms and User Input, File Handling (Read, Write, Append)
  • img Lecture 1

    Introduction to DBMS and RDBMS, PHP and MySQL
  • img Lecture 2

    Creating Database and Tables, Creating Database connection using PHP, Inserting Data into MySQL Database using PHP
  • img Lecture 3

    Retrieving, Update and Delete Data from MySQL database using PHP, MySQL Where clause, Order By, Joining multiple table using php
  • img Lecture 1

    PHP OOPS Concepts
  • img Lecture 2

    Sessions and Cookies
  • img Lecture 3

    File Uploading in PHP
  • img Lecture 1

    Introduction
  • img Lecture 2

    Understanding AJAX XML Http Request
  • img Lecture 3

    Ajax Response and events
  • img Lecture 4

    How to use AJAX in PHP
  • img Lecture 5

    Ajax using MySQL Database
  • img Lecture 1

    Database Level Security
  • img Lecture 2

    Secure Code ih PHP
  • img Lecture 3

    Introduction of MVC Architecture
  • img Lecture 4

    Searching and Filtering technique

Details of the Course