0471-6454555
9447387064
9847003556

No1 Training Institute in Kerala

SQL Server

SQL Server 2008 Reporting Services

Using Report Designer Publishing a Report Using Report Builder / Report Manager Security and SQL Server Choosing Service Accounts Authentication Modes Roles / Users / Permissions / Object Ownership
TRINITY TECHNOLOGIES

SQL Server 2008 Services

The Import and Export Wizard Attaching / Detaching Databases Backup of Databases/ Restoring Databases
TRINITY TECHNOLOGIES

Triggers

Creating / Altering Triggers Using the Inserted and Deleted Tables Recursive and Nested Triggers
TRINITY TECHNOLOGIES

Advanced Transact-SQL

Transactions Cursors Structured Error Handling Concept of Commit, rollback
TRINITY TECHNOLOGIES

Views, Stored Procedures, and Functions

Using Views Using Stored Procedures Using Functions
TRINITY TECHNOLOGIES

Action Queries

DELETE / INSERT / UPDATE INSERT INTO Statement with VALUES Clause Understanding INSERT and SELECT Subquery Data Removal with the DELETE Statement Data Modification with the UPDATE Statement
TRINITY TECHNOLOGIES

SELECT queries

The select / from/ where /order by / group by and having clause / using Top n Inner Join, Self Join, Outer Join and Cross Join Basic SQL SELECT and SELECT INTO Statements Sorting SELECT Query Results with ORDER BY Nested & Correlated Subqueries,Union Date & Time, String and Math System Functions Dynamic SQL for Automatic Query Generation The GROUP BY Clause & Aggregate Functions
TRINITY TECHNOLOGIES

T-SQL Basics

What is SQL? Syntax Conventions Executing SQL Statements Identifiers Creating Data Types, Operators, Variables, Functions Using SQL to Build and Alter Objects
TRINITY TECHNOLOGIES

Basics of Database Design

Normalization Introducing SQL Server Management Studio Understanding Logical Data Modelling Creating a Database Adding Tables Creating Indexes and Constraints Building Relations
TRINITY TECHNOLOGIES

About SQL Server?

SQL Server Editions Installing SQL Server
TRINITY TECHNOLOGIES

About SQL Server?

SQL Server Editions Installing SQL Server

Basics of Database Design

Normalization Introducing SQL Server Management Studio Understanding Logical Data Modelling Creating a Database Adding Tables Creating Indexes and Constraints Building Relations

T-SQL Basics

What is SQL? Syntax Conventions Executing SQL Statements Identifiers Creating Data Types, Operators, Variables, Functions Using SQL to Build and Alter Objects

SELECT queries

The select / from/ where /order by / group by and having clause / using Top n Inner Join, Self Join, Outer Join and Cross Join Basic SQL SELECT and SELECT INTO Statements Sorting SELECT Query Results with ORDER BY Nested & Correlated Subqueries,Union Date & Time, String and Math System Functions Dynamic SQL for Automatic Query Generation The GROUP BY Clause & Aggregate Functions

Action Queries

DELETE / INSERT / UPDATE INSERT INTO Statement with VALUES Clause Understanding INSERT and SELECT Subquery Data Removal with the DELETE Statement Data Modification with the UPDATE Statement

Views, Stored Procedures, and Functions

Using Views Using Stored Procedures Using Functions

Advanced Transact-SQL

Transactions Cursors Structured Error Handling Concept of Commit, rollback

Triggers

Creating / Altering Triggers Using the Inserted and Deleted Tables Recursive and Nested Triggers

SQL Server 2008 Services

The Import and Export Wizard Attaching / Detaching Databases Backup of Databases/ Restoring Databases

SQL Server 2008 Reporting Services

Using Report Designer Publishing a Report Using Report Builder / Report Manager Security and SQL Server Choosing Service Accounts Authentication Modes Roles / Users / Permissions / Object Ownership