IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

Hot Topics

3-day ITIL Foundation

5-day PRINCE2™ Practitioner

4-day Business Analysis

3-day Project Management Fundamentals

Course Title:
Microsoft SQL Server - Database Design

Duration: 5 days

Course Overview
This instructor-led, group-paced, classroom-delivery learning model, with structured hands-on activities will enable students to learn how to design, create, and manage databases and their objects in Microsoft SQL Server. In addition, students will learn how to use the Transact-SQL language to retrieve and manipulate data from SQL Server.

Target Audience


Students enrolling in this course should be able to complete the tasks necessary to implement and administer a Windows NT Server 4.0 domain and should be familiar with relational database concepts.

Course Objectives


Upon successful completion of this course, students will be able to:

Identify the features of SQL Server.
Understand how to use Transact-SQL to query their databases.
Design and implement databases.
Create and manage tables.
Implement data integrity techniques.
Design and implement indexes.
Query multiple tables through the use of joins.
Design sub-queries.
Use aggregate functions in queries.
Create and manage views.
Design and implement stored procedures.
Create triggers.
Manage transactions and locks.
Implement queries across multiple servers.
Install and use Microsoft Search Service and Microsoft English Query.

Course Content


An Overview of SQL Server
Exploring the features of SQL Server
SQL Server database structure
The SQL Server architecture
Identifying SQL Server management tasks

Exploring Transact-SQL
What is Transact-SQL?
Transact-SQL statements
Programming in Transact-SQL

Designing and Implementing Databases
Identifying database design issues
Creating databases
Maintaining databases

Creating and Managing Tables
Creating tables
Maintaining tables
Scripting tables

Designing Data Integrity
Understanding data integrity
Implementing constraints

Implementing Indexes
Designing indexing
Implementing indexes
Maintaining indexes

Joining Tables
Querying multiple tables
Implementing advanced table joins

Advanced Queries
Designing sub-queries
Changing data through queries

Using Functions
Working with aggregate functions

Designing Views
Creating and managing views

Creating Stored Procedures
Designing stored procedures
Creating stored procedures
Using parameters in stored procedures
Managing stored procedures

Creating Triggers
Designing triggers
Creating and managing triggers

Understanding Transactions and Locks
Working with transactions
Working with locks

Implementing Distributed Queries
Establishing linked servers
Creating and managing distributed queries

Designing Advanced Queries
Implementing the Microsoft Search Service
Using Micorosft English Query

Enter your email address to register for our newsletter: