Index was outside the bounds of the array. Course:(0833) Implementing a Database on Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer
Exclusive
SQL Server

Implementing a Database on Microsoft SQL Server 7.0
(Microsoft Training Course: 0833) - 5 days - £2640 exc VAT

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> Target Audience
THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
This course is designed for developers who need the technical skills required to implement a database solution with the Microsoft SQL Server relational database management system.
> Course outline
  1. Microsoft SQL Server Overview
  2. Transact-SQL Overview
  3. Creating Databases
  4. Implementing Data Integrity
  5. Planning and Creating Indexes
  6. Using joins to combine data from multiple tables
  7. Summarizing Data
  8. Managing Transactions and Locks
  9. Implementing Views
  10. Implementing Stored Procedures
  11. Implementing Triggers
Supplementary Information This course has now retired and is no longer available. We suggest you look at Courses 2779: Implementing a Microsoft SQL Server 2005 Database and 6232: Implementing a Microsoft SQL Server 2008 Database.
Module 1: Microsoft SQL Server Overview
  • What is SQL Server?
  • SQL Server architecture
  • SQL Server components
  • Working with SQL Server
  • Lab:
  • Using SQL Server books online
Skills
  • Skills: Students will be able to:
  • Describe Microsoft SQL Server 7.0 and its supporting operating systems.
  • Describe SQL Server architecture.
  • Describe SQL Server components.
  • Identify SQL Server design options, as well as implementation and administration activities.
top
Module 2: Transact-SQL Overview
  • SQL Server programming tools
  • The Transact-SQL programming language
  • Elements of Transact-SQL
  • Ways to execute Transact-SQL statements
  • Lab:
  • Transact-SQL overview
Skills
  • Skills: Students will be able to:
  • Describe the basic elements of Transact-SQL.
  • List data definition statements.
  • List data manipulation statements.
  • List data control statements.
  • Describe the ways to execute Transact-SQL statements
top
Module 3: Creating Databases
  • Introduction to databases
  • Working with databases
  • Modifying databases
  • Creating filegroups
  • Creating data types
  • Creating tables
  • Generating scripts
  • Lab:
  • Creating databases
Skills
  • Skills: Students will be able to:
  • Evaluate database considerations.
  • Create and configure a database.
  • Manage a database and transaction log.
  • Create and drop user-defined data types.
  • Create and drop user tables.
  • Generate a script.
top
Module 4: Implementing Data Integrity
  • Introduction to data integrity
  • Using constraints
  • Using defaults and rules
  • Lab:
  • Implementing data integrity
Skills
  • Skills: Students will be able to:
  • Describe the three types of data integrity.
  • Determine which features to use to enforce data integrity.
top
Module 5: Planning and Creating Indexes
  • Implementing indexes
  • Creating and dropping indexes
  • Types of indexes
  • Characteristics of indexes
  • Indexing guidelines
  • CREATE INDEX options
  • Maintaining indexes
  • Lab:
  • Creating indexes
Skills
  • Skills: Students will be able to:
  • Determine when indexes are useful and decide the types of indexes to create.
  • Create clustered and nonclustered indexes with unique or composite characteristics.
  • Use the CREATE INDEX options to expedite index creation and improve index performance.
  • Apply the appropriate fillfactor value to accommodate the future growth of tables.
  • Use various tools and verification features to maintain indexes and enhance their optimal performance
top
Module 6: Using joins to combine data from multiple tables
  • Manipulating a result set
  • Using subqueries
  • Modifying data with joins or subqueries
  • Querying a remote SQL Server
  • Lab:
  • Performing advanced queries
Skills
  • Skills: Students will be able to:
  • Combine data from two or more tables using joins.
  • Combine multiple result sets into one result set using the UNION operator and the SELECT INTO statement.
  • Use subqueries to break down and perform complex queries.
  • Use joins and subqueries as selection or data modification criteria within a statement.
  • Set up a distributed environment that accesses data stored in a remote SQL Server.
top
Module 7: Summarizing Data
  • Using aggregate functions
  • Generating a summary value for a column
  • Generating aggregate values within result sets
  • Listing the top n values
  • Lab:
  • Summarizing data
Skills
  • Skills: Students will be able to:
  • Generate a single summary value using aggregate functions.
  • Organize summary data for a column using aggregate functions with the GROUP BY, HAVING, COMPUTE, and COMPUTE BY clauses.
  • Generate summary data for a table using aggregate functions with the GROUP BY clause and the ROLLUP or CUBE operators.
  • Use the TOP n keyword to retrieve a list of the specified top values in a table
top
Module 8: Managing Transactions and Locks
  • Introduction to transactions and locks
  • Managing transactions
  • Managing locks
  • Managing distributed transactions
  • Lab:
  • Managing transactions and locks
Skills
  • Skills: Students will be able to:
  • Describe transaction processing.
  • Execute, cancel, or roll back a transaction.
  • Identify resource items that can be locked.
  • Identify the types of locks.
  • Set locking options and display locking information.
  • Initiate a distributed transaction. top <sql7im.html>
  • Compare distributed transactions and replication.
top
Module 9: Implementing Views
  • Views: an alternate way to look at data
  • Advantages of views
  • Creating views
  • Altering views
  • Modifying data through views
  • Lab:
  • Implementing views
Skills
  • Skills: Students will be able to:
  • Explain the purpose and benefits of using views.
  • Create a view using the CREATE VIEW statement.
  • Drop a view from a database.
  • Locate view definition information.
  • Alter a view.
  • Update a source table using a view
top
Module 10: Implementing Stored Procedures
  • Introduction to stored procedures
  • Creating, executing, and modifying stored procedures
  • Using parameters in stored procedures
  • Handling error messages
  • Lab:
  • Implementing stored procedures
Skills
  • Skills: Students will be able to:
  • Describe how a stored procedure is processed.
  • Create, execute, modify, and drop a stored procedure.
  • Execute a stored procedure on a remote server.
  • Use parameters with stored procedures.
  • Recompile a stored procedure.
  • Create custom error messages.
top
Module 11: Implementing Triggers
  • Introduction to triggers
  • Creating, dropping, and altering triggers
  • Examples of triggers
  • Lab:
  • Creating a trigger
Skills
  • Skills: Students will be able to:
  • Define a trigger.
  • Explain the advantages of using a trigger.
  • Describe some considerations when using a trigger.
  • Create a trigger.
  • Drop a trigger.
  • Alter a trigger.
top
> Pre-Requisites
Students are expected to have knowledge and some practical experience of the following:
  • Windows NT® Server, experience with relational databases
  • Three to six months SQL Server experience
  • Understanding of basic ANSI SQL statements
> Purpose
The course is in two parts, days 1-4 focus on the use of the SQL Server Client Utilities and uses the Microsoft Official Curriculum. Day 5 covers all aspects of accessing the SQL Server Tables from Access. Thus creating and maintaining the objects that make up a SQL Server database are fully covered as well as practical experience of accessing the data from Access
> Supplementary Information
This course has now retired and is no longer available. We suggest you look at Courses 2779: Implementing a Microsoft SQL Server 2005 Database and 6232: Implementing a Microsoft SQL Server 2008 Database.
> EXAMS
There are no exams directly associated with this course