Software programming Institute, Academy, training school,Mysql, Php, joomla courses

Our Courses

Creative


			Email ID:

Search for our courses

~	C & C++
~	Java
~	C#
~	VB.NET
~	ASP.NET
~	Diploma in JAVA Programming
~	Diploma in DOT NET Technology
~	Diploma In Software Engineering
Courses in Database Administration
~	Diploma in ORACLE Database Administrator (OCP) Oracle 9i DBA
~	Diploma in ORACLE Database Administrator (OCP) Oracle 10g DBA
~	Diploma in Database-Administration [RDBMS]
~	ORACLE (Paper I ) SQL
~	MS SQL Server 2005
Courses in Web Development
~	Diploma in Internet Application & E-Commerce
~	Diploma in Web 2.0 Technology (Rich Internet Application)
~	Certificate in Web Development (Server Side)
~	Certificate in Web 2.0 Technology (Client Side)
~	LAMP

Mysql Topics Covered


Database Design with My SQL Why use a Relational Database?

Blasted Anomalies
~ ~ ~	The update anomaly The delete anomaly The insert anomaly

Normalization
~ ~ ~	First normal form Second normal form Third normal form

Types of Relationships
~ ~ ~	The one-to-many relationship The one-to-one relationship The many-to-many relationship

Advanced Database Concepts
~ ~ ~	Referential integrity Transactions Stored procedures

The Structured query Language for Creating and Altering Tables

Essential Definitions
~ ~	Null Values Indexes

The create database Statement

The use database Statement

The create table Statement

Column Types
~ ~ ~	String column types Numeric column types Date and time types

Creating Indexes

Table Types
~ ~ ~	MyISAM InnoDB Tables Berkeley DB Heap

The alter table Statement
~ ~ ~ ~ ~ ~	Changing a table name Adding columns Dropping columns Adding indexes Dropping indexes Changing column definitions

Using the show Command
~ ~ ~ ~ ~ ~	show databases show tables show columns show index show table status show create table

GUI Tools for Manipulating MySQL Tables and Data
~	Using phpMyAdmin

The Structured Query Language for Inserting, Editing, and Selecting Data
~ ~ ~ ~	The insert Statement The update Statement The delete Statement The replace Statement

The Basic select Statement
~ ~ ~ ~	The Where clause order by limit group by and aggregate functions

Joining Tables
~ ~ ~ ~ ~ ~	The two-table join (equi-join) The multi-table join The outer join The self join Unions Correlated subqueries

Management has full right to Change courses, contents, tuition fees without prior notice

COMPUFIELD offers a unique style of learning -
	One computer : One student : One Instructor	The timing can be fixed based on our mutual convenience, between 9.00 a.m. to 7.00 p.m.
	Maximum Instructor to Student Ratio 1:4	Course duration in working days = Total sessions divided by number of sessions (hours) per day.
	Sessions : Each session will be of 1 hour	No extra charges/refund for more/less time taken to complete the course.
	Fees is for one course and it includes instructions, practicals,practice, project, preparation for exam (if any)	Lodging, boarding and travelling not included in the fees.
	Overseas / local Students take 5 to 10 hours per day to complete their courses earlier.	Management has full right to change courses, contents, tuition fees without prior notice.