PHP-MySQL Training

PHP-MySQL Summer Training Patna

PHP-MySQL Summer Training Patna
PHP-MySQL Courses Description

PHP is a server-side scripting language designed for web development but also used as a general-purpose programming language. It is originally created by Rasmus Lerdorf in 1994, the PHP reference implementation is now produced by The PHP Group. PHP originally stood for Personal Home Page,but it now stands for the recursive acronym PHP: Hypertext Preprocessor

PHP code may be embedded into HTML code, or it can be used in combination with various web template systems, web content management systems, and web frameworks. PHP code is usually processed by a PHP interpreter implemented as a module in the web server or as a Common Gateway Interface (CGI) executable. The web server combines the results of the interpreted and executed PHP code, which may be any type of data, including images, with the generated web page. PHP code may also be executed with a command-line interface (CLI) and can be used to implement standalone graphical applications.

MySQL is the world's most popular open source database. With its proven performance, reliability and ease-of-use, MySQL has become the leading database choice for web-based applications, used by high profile web properties including Facebook, Twitter, YouTube, Yahoo! and many more.Oracle drives MySQL innovation, delivering new capabilities to power next generation web, cloud, mobile and embedded applications.

PHP-MySQL Course Contents

Introduction

  • Basic Knowledge of websites
  • Introduction Of Dynamic Website
  • Introduction to PHP
  • Why and Scope of PHP
  • XAMPP Installation

Handling Html Form With Php

  • Hypertext Markup Languages
  • Structure of HTML
  • Basic HTML Tags
  • Advanced HTML Tags
  • Introduction to Doc Types Web Design with CSS
  • Introduction to Cascading Style Sheets

Programming Basics

  • Syntax of PHP
  • Embedding PHP in HTML
  • Embedding HTML in PHP
  • Introduction to PHP Variable
  • Understanding Data Types
  • Using Operators
  • Writing Statements and Comments
  • Using Conditional Statements
  • If(), else if() and else if condition Statement
  • Switch() Statements
  • Using the while() Loop
  • Using the for() Loop

Function

  • PHP Functions
  • Creating an Array
  • Modifying Array Elements
  • Processing Arrays with Loops
  • Grouping Form Selections with Arrays
  • Using Array Functions
  • Using Predefined PHP Functions
  • Creating User-Defined Functions

Advanced Concepts

  • Reading and Writing Files
  • Reading Data from a File
  • Managing Sessions and Using Session Variables
  • Creating a Session and Registering Session Variables
  • Destroying a Session
  • Storing Data in Cookies
  • Setting Cookies
  • Dealing with Dates and Times
  • Executing External Programs

Introduction to Database - MySQL Database

  • Understanding a Relational Database
  • Introduction to MySQL Database
  • Understanding Tables, Records, and Fields
  • Understanding Primary and Foreign Keys
  • Understanding SQL and SQL Queries
  • Understanding Database Normalization
  • Dealing with Dates and Times
  • Executing External Programs

Working with MySQL Database & Tables

  • Creating MySQL Databases
  • Creating Tables
  • Selecting the Most Appropriate Data Type
  • Adding Field Modifiers and Keys
  • Selecting a Table Type
  • Understanding Database Normalization
  • Altering Table and Field Names
  • Altering Field Properties
  • Backing Up and Restoring Databases and Tables
  • Dropping Databases and Table Viewing Database, Table, and Field Information
  • SQL 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 Table and Column Aliases

    Working with PHP & MySQL

    • Managing Database Connections
    • Processing Result Sets
    • Queries Which Return Data
    • Queries That Alter Data
    • Handling Errors

    JavaScript

    • Introduction to JavaScript
    • Variables, operators, loops
    • Using Objects, Events
    • Common java script functions
    • Java Script Validations

    PHP LIVE Project

    • Project Discussion
    • Requirements analysis of Project
    • Project code Execution
    • Project Testing
Related Courses