Compufield -computer Institute training,learning,academy,colege, specialized in fast track courses in multimedia,web designing,e-commerce,software, in Network engineering,certification courses,fashion, textile,jewellery,interior designing courses. India,Bombay(Mumbai)

Our Courses


			Email ID:

Why Foreign / Indian students prefer to study Computer Courses
at COMPUFIELD? Mumbai - India

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

SQL Server 2005

SQL-Server 2005

Our Programming Student's Review

Programming Review
1	2	3

SQL-Server 2005

SQL Server, the Relational Database Management System(RDBMS) allows to store huge Database and manage the same easily. It is an enterprise database management and analysis system.

Salient Features

XML Support: Simplify the integration of your back-end systems and data transfer across firewalls using XML.

High Availability : Maximize the availability of your business applications with log shipping, online backups.

Automated Tuning : Automatic tuning and maintenance features enable administrators to focus on other critical tasks

Improved Developer Productivity : User-defined functions, cascading referential integrity, and the integrated Transact-SQL debugger allow you to reuse code to simplify the development process.

Security : Ensure your applications are secure in any networked environment, with role-based security and file and network encryption.

Data Transformation Services : Automate routines that extract, transform, and load data from heterogeneous sources

Application

~
~
~
~
~
~
~

Multinational Companies with huge database to be maintained
Banking Industry
Production Industry
Data warehousing companies
Educational / Training Industry
Air-transportation Service Industry
Any business or service industry that stores database

Topics

~
~
~
~
~
~
~
~

Understanding Query Flow
Syntactical Flow of the Query Statement
Logical Flow of the Query Statement
From Clause Data Sources
Possible Data Sources
Named Ranges
[Table Name]
Four-Part Table Names

~
~
~
~
~
~
~
~
~
~
~

Where Conditions
Using the Between Search Condition
Using the In Search Condition
Using the Like Search Condition
Multiple Where Conditions
Select….Where
Ordering the Result Set
Specifying the Order by Using Column Names
Specifying the Order by Using Expressions
Order by and Collation
Select Distinct

~
~
~
~
~

Operators
Scalar Functions
User Information Functions
Data-Time Functions
String Functions

~
~
~
~
~
~
~
~
~

Inner Joins
Creating Inner Joins within SQL Code
Number of Rows Returned
Multiple Table Joins
Outer Joins
Outer Joins and Optional Full Outer Joins
Placing the Conditions within Outer Joins
Self-Joins
Multiple-Condition Joins

~
~

Using Unions
Intersection Union

~
~
~
~
~
~
~
~
~

Simple Subqueries
Using Scalar Subqueries
Using Subqueries as Lists
Using Subqueries as Tables
Simple Aggregations
Basic Aggregations
Grouping within a Result Set
Simple Groupings
Aggravating Queries

~
~
~
~
~
~

Why Use Views?
Working with Views
Creating Views with DDL Code
Order By and Views
View Restrictions
Executing Views

~
~
~
~
~
~
~
~
~
~

Inserting Data
Inserting One Row of Values
Inserting the Result Set from a Stored Procedure
Updating Data
Updating a Single Table
Deleting Data
Creating Tables
Creating Primary Keys
Primary Keys
Creating Foreign Keys

~
~
~
~
~

DDL Triggers
Creating and Altering DDL Triggers
EventData()
Enabling and Disabling DDL Triggers
Implementing Trigger

~
~
~
~
~
~

XML Data Type
Querying XML Data
Merging XQuery with Select
Reading XML into SQL Server
Creating XML with SQL Server 2005
ql

Course Duration	Fees (Indian RS.)	Fees (US $)
40 sessions of 1 hr. each	7,000	200

Franchise
Enquiry

IT Corporate Training

Student Project Galleries

Any Course,
Any Time, Any Where

Free E-greetings
For ever occasion

Students Registration
	Registration Form
	Payment Facilities
	Visa to Apply
	Accommodation
	Course Schedules
	Indian Consulates

Miscellaneous
	Location of Compufield (HO.)
	Site Map
	About Us
	FAQ
	Our Centers

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.