PHP/My SQL

Hypertext Processor is a server-side scripting language that works together with HTML to develop dynamic websites and web applications. It was developed by Rasmus Lerdorf in 1995, who was trying to create a web management system in C, called the Common Gateway Interface (CGI).Lerdorf named the tools Personal Home Page (PHP) tools, the initial name for the new programming language, later standardised into its current recursive definition

Databases can be found in almost all software applications. SQL is the standard language to query a database. The database is a systematic collection of data. Databases support storage and manipulation of data. Databases make data management easy. Some benefits of SQL are High speed, No coding needed, Well defined standards, Portability, Interactive language, and Multiple data views

Syllabus Of PHP/My SQL:

PHP

• PHP Basics
• Installing PHP
• Basic Scripting
• PHP Building Blocks
• PHP Structures
• Function
• Array
• Object Oriented PHP
• Working with Forms
• Working with Files
• Database Integration
• ShellCommands
• Dates
• Cookies
• Session Management
• Exception Handling
• Input Sanitization

My SQL

• Basic Linux commands.
• Installing MySQL.
• Starting and stopping MySQL
• Basic MySQL Queries
• Various logs in MySQL and its uses.
• MySQL client Programs
• Upgrading MySQL.
• Mysqladmin commands.
• Locking in MySQL
• Storage engines in MySQL
• Innodb Configuration
• MySQL Table maintenance
• Information Schema and Performance Schema
• MSQL backup and Recovery.
• MySQL Replication and different Replication Architecture
• MySQL User Management and Routines &Triggers