Thursday, 15 August 2013

primavera online training| primavera training| call us

talend online training| talend training| call us+919000444287 ...

www.21cssindia.com/courses/talend-online-training-160.html
online training, courses, talend online training, carbone, olivier, cv, talend, Engineer, Research, Developement, Training, elearning, soft, training , open source, ...
 

linux online training| linux training| call us+919000444287 - dharani ...

www.21cssindia.com/courses/linux-online-training-104.html
Linux Online Training, Linux training, Linux course contents, Linux , call us: +919000444287,dharani@21cssindia.com.

primavera online training| primavera training| call us+ ...

www.21cssindia.com/courses/primavera-online-training-22.html
Primavera Online Training. Click Here For Enquiry. The Project Management Life Cycle. Review the relationship between Primavera P6 and the Project ...
 

hyperion online training| hyperion training| call us+919000444287

  1. hyperion online training| hyperion training| call us+919000444287 ...

    www.21cssindia.com/courses/hyperion-online-training-30.html
    Hyperion Online Training, Hyperion training, Hyperion course contents, Hyperion , call us: +919000444287,dharani@21cssindia.com.
  2. cognos online training

    www.21cssindia.com/courses/cognos-online-training-27.html
    Cognos online training, Cognos online training Hyderabad. Online Cognos Training courses, convenient and cost- effective from the comfort of your own home ...
  3. abinitio online training| abinitio training| call us+919000444287 ...

    www.21cssindia.com/courses/abinitio-online-training-16.html
    AB INITIO Online Training. Click Here For Enquiry. Introduction to Ab initio. Ab initio Architecture (Co-operation system, GDE, EME). Sandbox creation, check-in ..

Tuesday, 30 July 2013

|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