Client / Server Connetion - Relational Model - Data definition Useing SQL - Modify Table - Using ALTER TABLE queries, add a colum, add an index,add a primary key - INSERT and DELETE queries - UPDATE QUERIES - Using select querise - SELECT,WHERE,LIMIT,ORDER BY, GROUP BY,JOIN - constraints and indexs - views - Expressions - grouping - using Functions - math Functions, compare string values,work with dates - JOIN and subqueries-advanced MYSQL query processing-database management,storedprocedures,triggers,etc - using MYSQL with Forms
PHP
PHP basic - syntax,data types,variables,constants,operator and expression,control structure-functions - returning values,variable scope - arrays - operation,iteration,sorting arrays - security - formatting and manipulating strings with PHP - Web Programming - Forms and URLS,HTTP headers,sessions - session security - useing data and time functions - working with Froms.
APACHE
WEB OPERATION - html PROTOCOL - APACHE Presentation apache installation - apache configuration - virtual hosting - enerating Dynamic page - aliases and redirections - monitoring and administration