Mobile No:
+91 9991180404, 8607211337
Email ID:
info@isofttechnoware.com
Microsoft® SQL Server™ 2008 provides the Microsoft® Windows Server System™ integrated server software with a database platform for the next generation of connected, scalable, and reliable enterprise applications. The breadth and depth of innovation in this version is in response to the needs of customers. This white paper is targeted to database administrators, to give you an understanding of the new features in and capabilities of SQL Server 2008. From many enhancements of existing features, to an entirely new security model, database administration is now more productive and in tune with the needs of the administrator.
Syllabus Of Sqlserver 2008
T-SQL
1) Sql server management studio 2005
2) Select statement
3) Insert statement
4) Update statement
5) Delete statement
JOINS
1) Inner joins
2) Outer joins
3) Cross joins
4) Union
5) Create statement
6) Create database
7) Create table
8) Alter statement
9) Alter database
10) Alter table
11) Drop statement
CONSTRAINTS
12) Type of constraints
13) Domain constraints
14) Entity constraints
15) Referential integrity constraints
16) Constraints naming
17) Key constraints
18) Primary key constraints
19) Foreign key constraints
20) Unique constraints
21) Check constraints
22) Default constraints
23) Disabling constraints
XML
1) Using xml
2) Xml data type
3) xquery
TRIGGERS
1) Create trigger
2) Alter trigger
3) Drop trigger
4) With append
5) Replication
6) Data integrity rules
7) Dealing with requirements
8) Check data with triggers
9) Custom error message
STORE PROCEDURES (SP)
1) Create SP
2) Alter SP
3) Drop SP
4) CLR SP

RULES
1) Defaults 2) Rule
3) Triggers for data integrity
4) Choose what to use
ADVANCE QUERY
1) Sub query
2) Nested sub-query
3) Correlated sub- query
4) How Correlated sub – queries work
5) Correlated sub –queries in the
WHERE clause
6) Dealing with Null data
7) Exists operator
8) Data converting INDEXES
1) Create ,altering and dropping indexes
2) Index statement VIEWS
1) Simple views
2) Filter views
3) Complex views
4) Edit views with T-Sql
5) Dropping views
TRANSACTIONS
1) Begin Tran
2) Commit Tran
3) Rollback Tran
4) Save Tran
 ADVANCE TOPIC
1) creating database with files
2) creating data type
3) xml- related features
4) optimize indexes
5) data integrity implementation
6) Backup database
7) Re-store Database
8) Cursor
 9) System Functions
10) User define function
11) CLR with .net
12) Full text index
13) Reporting
14) Service broker
15) Error handly
16) BCP(Bulk Copy programmer )
17) Sql server data type
18) System database
19) SQL SERVER 2008
 
 
 
 
 
 
 
Web Designing Web Designing Web Designing
Web Designing Web Designing Web Designing Web Designing