MS SQL Training

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

Course Outline:

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

Related Courses

Course Categories

A Few Things You’ll Love!

  • Experienced Training Partner
  • Certified & Industry Expert Trainers
  • Multiple Training Delivery Models
  • Customized
    Course
  • 24/7 e-Learning Access
  • Assessments and Mock Tests
  • Placement Assistance
Training Calendar
Whatsapp Logo