FIND YOUR DREAM WITH KMA

Microsoft® SQL Server™

  • 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.

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

  • 1) Type of constraints
  • 2) Domain constraints
  • 3) Entity constraints
  • 4) Referential integrity constraints
  • 5) Constraints naming
  • 6) Key constraints
  • 7) Primary key constraints
  • 8) Foreign key constraints
  • 9) Unique constraints
  • 10) Check constraints
  • 11) Default constraints
  • 12) 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

  • I) Dealing with Null data
  • II) Exists operator
  • III) Data converting INDEXES
  • IV) Create ,altering and dropping indexes
  • VI) 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 WHICH MAKE DIFFERENT

  • 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