B.E.S.T.
Level 3 - Web Services Prog. Concepts


php & Database
PHP

Basics : Introduction to PHP- What is PHP? What is PHP File? What can PHP do? Why PHP? Syntax of PHP- Basic PHP Syntax, Comments in PHP, PHP Case Sensitivity, Variables- Creating / Declaring PHP Variables, PHP Variables, PHP is a Loosely Typed Laguage, PHP Variable Scope.

Data-types : cho / Print Statements, Data Types- Integer, String - String Functions : strlen(), str_word_count(), strrev(), strpos(), str_replace(), Float, Boolean, Array, Object, NULL, PHP Strings, PHP Constants.

Control Flow Statements & Operators : Decision Making, if statement, if...else statement, if...elseif....else statement, switch statement, Operators- Arithmatic, Assignment, Comparison,Increment/Decrement, Logical, String,Array.

Loops : while, do...while, for, foreach, PHP Functions- Create User Define Function, PHP Function Arguments, Default Argument Value, Returning Value.

Functions : Create User Define Function, PHP Function Arguments, Default Argument Value, Returning Value.

Array : What is Array, Create Array in PHP, Indexed Array, Associative Array,Multidimensional Array, Array Sort : sort(), rsort(), asort(), ksort(), arsort(), krsort().

Form : Form Handling, GET and POST, Form Validation, PHP Include- Include(), Required().

Cookies : What is Cookies? Create / Retrieve Cookies, Modify a Cookie Value, Delete Cookies, Check if Cookies are Enabled.

Sessions: What is PHP Sessions? Start PHP Session, Get PHP Session Variable Values, Modify a PHP Session Variable, Destroy PHP Session, Essential Functions- PregMatchDateTime, Count(), Superglobals- $_SERVER, $_REQUEST, $_POST, $_GET.

Essential Functions: PregMatch, DateTime, Count(), Superglobals- $_SERVER,$_REQUEST, $_POST, $_GET, Math Function- rand(), round(), abs(), sqrt(), HTTP Function - Header().

File Handling : PHP File Handling, PHP Manipulating Files, PHP readfile() Function, PHP 5 File Open/Read/Close, PHP Open File – fopen(), PHP Read File – fread(),PHP Close File – fclose(), PHP Read Single Line – fgets(), PHP Read Single Character – fgetc().

File Upload : PHP File Upload, Create The HTML Form, Create The Upload File PHP Script, Check if File Already Exists, Limit File Size, Limit File Type, Complete Upload File PHP Script.

PHP Filters : PHP Filters and Advance Filters, PHP Error Handling, Basic Error Handling: Using the die() function, Creating a Custom Error Handler, Error Report levels, Set Error Handler, Trigger an Error, Error Logging, Send an Error Message by E-Mail, PHP Exceptions-What is an Exception? Basic Use of Exceptions, Try, throw and catch,Creating a Custom Exception Class Multiple Exceptions, Re-throwing Exceptions.


Maria DB

Basics : Introduction to DBMS and RDBMS, Difference between DBMS and RDBMS, Introduction to SQL, SQL Syntax, SQL DataTypes, User Rights.

Database Operations : How to create Database? How to Drop Database? How to create table? How to drop table?, Operations and Privileges in SQL. Import and Export Tables.

Keys & sql Functions : Primary key foreign key, index, Alter table, Constarints, Not null, Unique, auto increment, Dates, sql functions.

SQL Statements : Select, Insert, Update, Delete, Select- Distinct, where, And, or, notorder By, Null values, Min and Max Count, Sum, Like, Joins (Inner, Outer, Full, Self), union, Group By, Order By, Having.



Best Essential S/w Technologies (Diploma)