Corporate Training in Microsoft SQL Database Server 2005

COMPUFIELD® Computer Institute
In Mumbai

Price on request
Compare this course with other similar courses
See all

Important information


Important information

Where and when

Starts Location
On request
OPriya Bldg.,1st Floor, Dr. Peter Dias Road, Near Mehboob Studio,, 400050, Maharashtra, India
See map
On request
Chinoy Mansion, First Floor, Block #2, Opp. St.Stephen's Church, Warden Road,, 400036, Maharashtra, India
See map

Frequent Asked Questions

· Requirements

No Prior knowlegde of SQL or any other database product is required for this training

Course programme

Module 1:
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

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

Module 3:
Scalar Functions
User Information Functions
Data-Time Functions
String Functions

Module 4:
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
Multiple-Condition Joins

Module 5:
Using Unions
Intersection Union

Module 6:
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

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

Module 8:
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

Module 9:
DDL Triggers
Creating and Altering DDL Triggers
Enabling and Disabling DDL Triggers
Implementing Triggers

Module 10:
XML Data Type
Querying XML Data
Merging XQuery with Select
Reading XML into SQL Server
Creating XML with SQL Server 2005

Compare this course with other similar courses
See all