Training & Certification

Palium Skills offers the following SQL Server DBA training to individuals and corporates -

Course Outline:

Spring Training Course Overview

Introduction to Microsoft SQL server

• Introductions
• Sql server 2008 editions
• Sql server 2008 requirements
• Downloading sql software
• Selecting installation options
• Installing a named instance
• Sql server installation center overview
• Lunching SQL server management studio

Management Studio

• Introduction
• Working with queries

Keys and Constraints

• Introduction
• Primary Keys
• Foreign Keys and Composite Keys
• Understanding Constraints

Data Definition Language (DDL)

• Creation of table
• Modifying the structure of a table
• Dropping a table
• Working with different options

Data Manipulation Language (DML)

• Inserting, updating & deleting operations
• Operators, Built-in functions, grouping

Basic Queries

• Introduction
• SELECT...FROM
• WHERE
• GROUP BY
• ORDER BY

Special Condition in Query

• Introduction
• Operators
• Combining Conditions
• IN
• LIKE
• BETWEEN
• UNION
• EXCEPT and INTERSECT

Working with Functions

• Using Operators
• ISNULL and COALESCE
• Using Functions

Joins

• Introduction to Joins
• Inner join
• Outer join
• Cross joins
• Unions

Working with Indexes

• Introduction to indexes
• Clustered & non clustered indexes
• Creating, dropping indexes
• Index Maintenance Concepts