SQL Server Developer Training Program. Topics Covered

SQL Server Developer Training Program

Training Mode: Class Room/On-line

Training Methodology: Real-time Project oriented Training Features:

1) Trainers from Corporate 2) Unlimited Lab facility

3) Valid Materials(Soft/Hard Copy)

4) Resume Preparation and Mock Interview 5) 100% Placement Assistance

Topics Covered

Introduction of SQL Server 2008

 SQL Server 2008 Editions, Components, and Tools

 Using SQL Server Management Studio (SSMS)

 Working with Tables, Queries, and Views

Designing and Creating a Database

 Relational Database Design

 Implementing the Design

Working with SQL Server Management Studio

 Getting Started with Management Studio

 Exploring the Object Explorer

 Working with the Query Editor

 Using SQL Server Books Online

Transact-SQL Programming

 Overview of Transact-SQL

 Using Built-In Functions

 Controlling Flow

Transactions and Error Handling

 Transaction Concepts

 Applications and Transactions

Data Selection Queries

 Using ORDER BY to Sort Data

 The GROUP BY Clause

 Joining Tables

Complex Querying

 Working with NULL Values

 Writing Correlated Subqueries

Modifying Data

 Modifying Data with Transact-SQL

 Inserting Data

 Updating Data

 Deleting Data

Creating Views

 What Is a View?

 Creating Views

 Updating Data Using a View

 Using Computed Columns

 Indexed Views

 Partitioned Views

Creating User-Defined Functions

 User-Defined Function Overview

 Scalar Functions

 Inline Table-Valued Functions

 Multi-Statement Table-Valued Functions

 Using Functions, Views, and Stored Procedures

Creating Stored Procedures and Triggers

 Creating Stored Procedures

 Creating Triggers

Advanced Query Techniques & Cursors concepts

 Advanced T-SQL Techniques

 Executing Dynamic SQL

Advanced Techniques

 Complex Data and Structures

 Writing More Efficient Queries

 Maintaining Query Files

SQL Server DBA Training Program

Training Mode: Class Room/On-line

Training Methodology: Real-time Project oriented Training Features:

1) Trainers from Corporate 2) Unlimited Lab facility

3) Valid Materials(Soft/Hard Copy)

4) Resume Preparation and Mock Interview 5) 100% Placement Assistance

Managing the Database

 SQL SERVER DATABASE STRUCTURE  IMPORTANCE OF SYSTEM DATBASES

 CREATE NEW DATABASE AND ASSIGN DATA AND LOG FILES  UNDERSTAND TRANSACTION LOGS

 MANAGE TRANSACTION LOGS  SHRINKING THE DATABASE  REGISTER SQLSERVERS

Selecting Microsoft SQL Server 2008 Editions

 UNDERSTAND THE TYPES OF SQL SERVER SERVICES  DENTIFY THE NEED FOR DIFFERENT SQL SERVER EDITIONS  LIST THE DIFFERENT EDITIONS OF MICROSOFT SQL SERVER 2008

 DENTIFY THE DIFFERENCES BETWEEN THE VARIOUS SQL SERVER EDITIONS

Backup Concepts

 TYPES OF BACKUP

 HOW TO DO COMPRESS BACKUP?

 CHECK THE VALIDITY OF DATABASE BACKUP  HOW TO SETUP THE BACKUP STRATEGIES?

Restore Concepts

 RESTORE WITH RECORVERY  RESTORE WITH NORECOVERY

Data Transfer Concepts & Linked Servers

 IDENTIFY DATA TRANSFER TOOLS FOR IMPORTING AND EXPORTING DATA  UNDERSTAND AND USE THE BULK COPY PROGRAM (BCP)

 UNDERSTAND AND USE THE BULK INSERT COMMAND

 UNDERSTAND AND USE THE SQL SERVER IMPORT AND EXPORT WIZARD  DATA TRANSFER FROM FLAT FILES

 LINKED SERVERS AND ITS USAGE

 LINK BETWEEN ORACLE AND SQL SERVER

 FETCH DATA FROM ANOTHER SERVER BY USING ODBC

Logins And Users Concepts

 SETUP A LOGIN

 ASSIGN PERMISSION TO THE LOGINS

 CREATE AND ASSIGN ROLES TO THE PARTICULAR USER  SET THE GRANT PERMISSION TO ALL STORED PROCEDURES

Installation Concepts

 CREATE SERVICE ACCOUNTS

 UNDERSTAND THE SQL SERVER CONFIGURATION MANAGER  UNDERSTAND SQL SERVER INSTANCES

 SET AUTHENTICATION MODES

 INSTALL AND CONFIGURE A SQL SERVER INSTANCE  INSTALL A SAMPLE DATABASE

 CONFIGURE DATABASE MAIL

 INSTALLATION & CONFIRUGATION OF SQL SERVER  HOW TO SETUP A SEPARATE INSTANCE?

 FIND AND INSTALL LATEST SERVICE PACK  FINDING INSTALLATION ERROR LOGS

 CHECKING CURRENT INSTALLATION VERSION AND HOTFIXES  APPLYING PATCHES

Automating Tasks with JOBS & SQL SERVER AGENTS

 MANAGE SQL SERVER AGENT JOBS  UNDERSTAND OPERATORS

 DEFINE SQL SERVER ALERTS  HOW TO CREATE JOB?  HOW TO SCHEDULE THE JOB?

Performance Monitoring ,FIXING & TROUBLE SHOOTING

 WORK WITH COUNTER LOGS

 WORK WITH PERFORMANCE COUNTERS  WORK WITH SQL SERVER PROFILER  WORK WITH LOGS

 MANAGE SPACE FOR LOGS AND DATABASES  IDENTIFY REASONS FOR SERVICE FAILURE  HOW TO FIX ORPHANUSERS?

 HOW TO CHECK THE ORPHAN TRANSACTION?  HOW TO CHECK THE OPEN TRANSACION?  HOW TO MAKE SCRIPT?

Replication

 UNDERSTAND REPLICATION

 UNDERSTAND DIFFERENT REPLICATION METHODS  DESCRIBE WHAT ARE REPLICATION AGENTS  RESOLVE DATA CONFLICTS

 IMPLEMENT SNAPSHOT REPLICATION  IMPLEMENT TRANSACTIONAL REPLICATION  IMPLEMENT MERGE REPLICATION

ADHOC TOPICS

 IMPORTANT SQL SERVICES  DTS PACAGAES & SSIS PACKAGES

 IMPORT DTS PACKAGES TO 2005 OR 2008 VERSIONS  HOW TO SETUP A DATABASE MAIL?

 SET THE DATABASE INTO SINGLE USER MODE  REBUILD MASTER DATABASE

 MULTIPLE WAY OF INSERTING DATA  SYSTEM STORED PROCEDURES  DBCC TOPICS

 IMPORTANT DBCC COMMANDS & HOW TO USE THOSE  IMPORTANT DMV’S

 DATABASE MAINTENANCE PLANS

 OBTAIN DATA FROM INFORMATION SCHEMA  FIND DUPLICATE VALUES FROM PARTICULAR TABLES  MONITORING TOOLS

 HOW TO CHECK THE PERFORMANCE USING TOOLS?

 ADDING DATA OR LOG FILES TO THE NEW DRIVE TO AN EXISTING DATABASE  KILL SESSIONS

Contact Us