SQL Server 7 Database Design

Course Description
Course Outline

Course Overview

Students will learn how to implement databases in Microsoft SQL Server 7.

Prerequisites

Windows NT 4 System Architecture and Network Support and SQL Fundamentals or equivalent knowledge. Students should have experience working with relational databases and an understanding of basic SQL statements.

Benefits

Students will learn how to design, create, and manage databases and their objects in SQL Server 7. In addition, students will learn how to use the Transact-SQL language to retrieve and manipulate data from SQL Server.

Target student

Students should be able to complete the tasks necessary to implement and administer a Windows NT Server 4 domain and should be familiar with relational database concepts.

We offer a range of SQL Server training courses

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 subqueries 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 Microsoft English Query

Publisher:	Microsoft
Version:	7
Length:	4 days
Course-ID:	044462

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Excellent course, most topics were useful and the others were interesting and will be good to know about even if they don't affect my job personally

- IRI