Course

MICROSOFT SQL SERVER

Microsoft SQL SERVER TRAINING IN NOIDA

📷 4.7 out of 5 based on 5147 Votes.

Microsoft SQL Server is Microsoft’s relational database management system for Windows. Any of our SQL Server 2008 courses can also be taught using SQL Server 2008 R2. Accelebrate’s SQL Server 2008 training classes cover a wide range of subjects, including administration, tuning, query writing with T-SQL, reporting with SSRS, data moving and transformation with SSIS, and multi-dimensional analysis with SSAS and MDX.Request pricing for SQL Server 2008 training for your team.

Basics

  • Database
  • DBMS
  • RDBMS

SQL Server Environment

  • SQL Server 2005 and 2008, 2012

Membership, Authorization, And Security

  • DDL
  • DML (INSERT, UPDATE, DELETE, MERGE)
  • TCL
  • DDL
  • DCL

Data Integrity

  • Domain Integrity
  • Entity Integrity
  • Referential Integrity

Joins and Sub Queries

  • SQL Operators
    Relational OperatorsBasic Relational operators
    Advanced Relational operators
  • 3. Logical operators
  • Simple Queries
  • Built in FunctionsCharacter Functions
    Number Functions
    Date Functions
  • Joins
  • Sub-Queries
  • Advanced Queries

Views

  • Create View
  • Advantage of Views
  • Updatable Views
  • Non Updatable Views
  • Indexed View

Introduction to T-SQL

  • Anonymous Block
  • Stored Block

Anonymous block(including 2008 features)

Structured Exception Handling

Cursors

  • Declaring Cursors
  • Modifications Through Cursors
  • Types of Cursors
  • Advantages of Cursors

Stored block/Stored Procedures

  • System Stored Procedure
  • User Stored Procedures
  • Advantages of Procedures
  • Passing In/Out Parameters
  • Altering Procedure
  • Extended Stored Procedures

User Defined Functions

  • Scalar UDF
  • Inline UDF
  • Multi Statement Table UDF
  • Table Variables, Temporary Tables

Triggers

  • DML Triggers (After | Instead of )
  • DDL Triggers
  • Advantages of Triggers

Transactions and Locks

  • Implicit Transactions
  • Explicit Transactions
  • TCL Commands
  • Lock Types
  • Isolation Levels
  • Dead Locks
  • MS-DTC

Indexes

  • Clustered Index
  • Non Clustered Index
  • Creating Index
  • Advantages of Indexes

Security

  • Windows Authentication
  • SQL Server Authentication
  • Creating Login
  • Database Permissions
  • Introduction to Roles, Schema
  • Droping Login

Data Transformation Services

  • BCP
  • Data Transformation Services Packages / SQL
  • Server Integration Services Packages

Features of 2012

  • Column store indexes
  • Sequence objects
  • Pagination
  • Error handling
Download Course Brochure
Enquiry Now