|SQL Server 2008 online training | Call us +917386622889

SQL Server 2008

Click Here For ENQUIRY

Basics DBMS RDBMS Oracle and SQL Server SQL Server Environment SQL Server 2005 and 2008 SQL Server Management Studio SQL Server Business Intelligence Development Studio SQL Language DDL DML DCL Data Integrity Entity Integrity Domain Integrity Referential Integrity  Database Design Normalization De Normalization Database Diagrams (E-R) Joins and Sub Queries T-SQL Operators Simple Queries Built in Functions Joins SubQueries Advanced Queries T-SQL Enhancements in SQL Server- 2008 Views Create View Advantage of View Updatable View NonUpdatable View Index View Stored Procedures System Stored Procedure User Stored Procedures Passing In/Out Parameters Altering Procedure Advantages of Procedure Extended Stored Procedure User Defined Functions Scalar UDF Inline DDF Multi Statement Table DDF Table Variables Temporary Tables Triggers DML Triggers (After | Instead of ) DDL Triggers Magic Tables Advantages of Triggers Transactions and Locks Explicit Transactions TCL Commands Lock Types Isolation Levels Dead Locks MS-DTC Cursors Declaring Cursors Modifications Thorough Cursors Types of Cursors Advantages of Cursors Indexes Clustered Index Non Clustered Index Creating Index Advantages of Indexes XML Integration FOR XML OPEN XML XML Data Type .NET 2.0 (CLR) Integration CLR Objects CLR Stored Procedures CLR User Defined Functions Security Windows Authentication SQL Server Authentication Creating Login Database Permissions Introduction to Roles, Schema Droping Login Database Maintenance Backup Database Restore Database Deployment of Database Generating T-SQL Scripts and Batches System Databases and System Tables SQL Server Agent Jobs Schedules Alerts Operators Data Transformation Services BCP DTS Packages / SSIS Packages Datawarehousing Support OLTP OLAP Analysis Services (SSAS) Reporting Services (SSRS) Sample Projects Introduction to DBA Concepts Replication Performance Monitoring SQL Server Configuration Manager Service Broker