Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 14-12-2016
Search Course Here




Live Chat
Support
Microsoft Sql Server 2008 Online Training

Microsoft SQL Server 2008

overview

Microsoft SQL Server is a relational database server, developed by Microsoft, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network.
prerequisties
  • Attendees must have basic computer knowledge.
Duration
Online
  • It is a 20 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 5 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Introducing SQL Server 2008
    • What's New in SQL Server?
    • SQL Server Editions
    • Installing SQL Server

  • Basics of Database Design
    • Normalization
    • Denormalization
    • Tools for Normalization in SQL Server
    • Introducing SQL Server Management Studio
    • Creating a Database
    • Adding Tables
    • Creating Indexes and Constraints
    • Building Relations

  • T-SQL Basics
    • What is T-SQL?
    • Syntax Conventions
    • Introducing AdventureWorks2008
    • Executing SQL Statements
    • Identifiers
    • Creating Data Types
    • Operators
    • Variables
    • Functions
    • Using T-SQL to Build and Alter Objects

  • SELECT Queries
    • The SELECT Clause
    • The FROM Clause
    • The WHERE Clause
    • The ORDER BY Clause
    • Using GROUP BY and HAVING
    • Using TOP N and TOP N PERCENT
    • UNION Queries
    • Full-Text Search

  • Action Queries
    • SELECT INTO queries
    • DELETE queries
    • TRUNCATE TABLE queries
    • INSERT queries
    • UPDATE queries
    • MERGE queries

  • Locking and Execution Plans
    • What is Locking?
    • Monitoring Locks
    • Tuning Locking
    • Deadlocks
    • Tuning Queries
    • Management Data Warehouse
    • Performance Studio

  • Views, Stored Procedures, and Functions
    • Using Views
    • Using Stored Procedures
    • Using Functions

  • Advanced Transact-SQL
    • Transactions
    • Rowset Functions
    • Ranking Functions
    • Cursors
    • Structured Error Handling

  • XML and SQL Server
    • XML Columns and Indexes
    • Querying and Modifying XML Data
    • Using OPENXML
    • Using FOR XML

  • Triggers
    • Creating DML Triggers
    • Altering DML Triggers
    • Using the Inserted and Deleted Tables
    • Checking Updated Columns
    • Recursive and Nested Triggers
    • Creating DDL Triggers

  • .NET inside of SQL Server
    • Creating CLR User-Defined Functions
    • Creating CLR Stored Procedures
    • Using the Sql Namespace
    • Creating CLR Triggers
    • Creating CLR User-Defined Types
    • Choosing When To Use CLR Objects

  • SMO and RMO Programming
    • Retrieving Server Information
    • Working With Database Objects
    • Generating Scripts
    • Viewing and Modifying Server Configuration
    • Understanding RMO

  • Data Protection/Tracking
    • Understanding Change Data Capture
    • Data Capture Schema and Tables
    • Transparent Data Encryption
Videos

Microsoft Sql Server 2008 Videos will be updated soon
To watch more Videos Click Here

Flash News


AngularJS New Batch Start From 09th DEC & 10th DEC.


Hadoop Dev New Batch Start From 10th DEC & 11th DEC.


IBM COGNOS TM New Batch Start From 11th DEC & 12th DEC.


Informatica Dev New Batch Start From 12th DEC & 13th DEC.


Mean Stack New Batch Start 13th DEC & 14th DEC.

SAP BODS new Batch Starting From 14th DEC & 15th DEC.

SAP S/4 HANA New Batch Start From 15th DEC & 16th DEC
.

Tableau New Batch Start From 16th DEC & 17th DEC

PUBLIC DEMO


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th DEC & 07:00A.M IST on 14th DEC

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings