Programming Courses


Connect with us on WHatsAPP

 
Course Contents
   
Free Trial Session Is Limited To Phase I Only
   
Phase 1
Working with My SQL
1)
Database Design with My SQL
2)
Why use a Relational Database?
3)
Blasted Anomalies
The update anomaly
The delete anomaly
The insert anomaly
4)
Normalization
First normal form
Second normal form
Third normal form
5)
Types of Relationships
The one-to-many relationship
The one-to-one relationship
The many-to-many relationship
6)
Advanced Database Concepts
Referential integrity
Transactions
Stored procedures
7)
The Structured query Language for Creating and Altering Tables
Essential Definitions
Null Values
Indexes
8)
The create database Statement
9)
The use database Statement
10)
The create table Statement
11)
Column Types
String column types
Numeric column types
Date and time types
12)
Creating Indexes
13)
Table Types
MyISAM InnoDB Tables
Berkeley DB
Heap
14)
The alter table Statement
Changing a table name
Adding columns
Dropping columns
Adding indexes
Dropping indexes
Changing column definitions
15)
Using the show Command
show databases
show tables
show columns
show index
show table status
show create table
16)
GUI Tools for Manipulating MySQL Tables and Data
Using phpMyAdmin
MySQL Control Center
Using MacSQL
17)
The Structured Query Language for Inserting, Editing, and Selecting Data
The insert Statement
The update Statement
The delete Statement
The replace Statement
18)
The Basic select Statement
The Where clause
order by
limit
group by and aggregate functions
19)
Joining Tables
The two-table join (equi-join)
The multi-table join
The outer join
The self join
Unions
Correlated subqueries
Part II: Working with PHP
1)
Getting Started with PHP-Variables
2)
Assigning Simple Variables Within a Script
Delimiting strings
Assigning arrays within a script
Assigning two-dimensional arrays in a script
3)
Accessing Variables Passed from the Browser
HTML forms variables
Passing arrays
Cookies
Sessions
4)
Testing Variables
isset0
empty0
is_null0
is_int0
is_double0
is_string0
is_array0
is_bool0
is_object0
is_resource0
is_scalar0
gettype0
5)
Changing Variable Types
Variable Variables
6)
Control Structures
7)
The if Statement 
Determining true or false in PHP
Comparison operators
Logical operators
Complex if statement
if…else statements
if…elseif statements
8)
switch…case
Loops
White…
do…while
for
foreach
continue and break
9)
PHP’s Built-in Functions
Function Basics
Arguments
Return values
10)
Function Documentation
Important PHP Functions
String handling functions
Regular expression functions
Variable functions
Type-conversion functions
Array functions
Object/class functions
Print functions
Date/time functions
File-system functions
Script Control functions
Random number generator functions
Session functions
MySQL functions
HTTP header functions
Image functions
Mail functions
URL functions
Error functions
Output buffering
Information functions
11)
Writing Organized and Readable Code
Indenting
Code blocks
Function calls
SQL statements
12)
Includes
Include0 and Require0
Include_once0 and Require_once0
13)
User-Defined Functions
Function basics
Returning values
Using a variable number of arguments
Variable scope
14)
Object-Oriented Programming
Classes, Continued
Object cloning
Destructors
Exceptions
   
Part III
15)
Creating a shopping Cart
Where users can shop for Products and data stored in the backend
Admin Module / Security
Giving Accesstom Users / Clients / Admin
Creating the entire admin module using seesions and cookies
This is the "Project" undertaken by our students
during the course
 
   
 

 

 

 

   

* The cost for the course in Indian Rupees (INR) would change depending on the "Current Rate"of US Dollar

           
 
SOLVE YOUR QUERIES ONLINE
Email:
Google Talk:
Yahoo Messenger:
WhatsAPP / Viber
MSN Messenger:
Skype Talk:
Connect with us on WhatsAPP  / Connect with us on Viber +91 9819006132
Contact Person:
Mr. Faiyaz Khairaz: Mobile - Connect with us+91 9819006132
Office Address:
Head Office: Chinoy Mansion, First Floor, Block # 2,
Opposite St. Stephens Church, Warden Road,
Mumbai(Bombay) - 400 036, Contact No.:+91-22-23676218 / +91-22-23679302 /
Mobile: +91-9819006132.
 
"Compufield -computer Institute specialized in fast track courses-multimedia,web designing,software engineering,certification courses,fashion,jewellery,interior designing courses. India,Bombay(Mumbai)." "COMPUFIELD-Leader in Global IT Corporate training having more than 20yrs exp.Programs offered MS-Office, Advance Excel, Java, Oracle, Linux and many more.""Compufield : free e-greeting cards, animated, musical greetings, ecards, postcards for Christmas, xmas, new year, eid, diwali, valentine's day, birthday, friendship, anniversary, love, congratulations, Halloween."