An Introduction to Microsoft SQL Server

In This Guide:

01 - Introduction to Databases and SQL Server

Having a database as well as an SQL Server is beneficial and advantageous to any organization especially with the continuous popularity of information technology

02 - Installing and Getting around SQL Server

Going through the step by step installation of an SQL server and learning the basic how-to's

03 - Basic Administrative Tasks

Discussing the basic administrative tasks

04 - SQL Server - A Practical Introduction to SSIS

Understanding the SSIS or SQL Server Integration Services

05 - Normalization and Sample Database Creation

Tips and guidelines in creating a well designed database

06 - Basic Queries and Data Modification

Answering basic queries and data modification

07 - Complex Queries and Views

Understanding of complex queries and views in SQL

08 - Advanced Programming with T-SQL

Writing structured programs for the SQL server DBMS

09 - An Introduction to SQL Server Tools and Components

Getting to know the components and tools that simplify Database administration and monitoring

10 - XML Programming in SQL Server 2005

Using the universal format to represent information