|
SQL Server
7 Developer Part 1 - SQ7D1
Description
The SQL Server 7.0 Part 1 course will introduce you to application development
with SQL Server 7.0. Instruction by industry expert Richard Campbell focuses
on practical solutions to real-life database development problems. At the conclusion
of this course you will understand how to install and configure SQL Server 7.0
and be familiar with database design principles and how to create SQL databases.
Course Outline
Module 1
Section A: SQL Server Components • Setup Files • Introduction •
Server Components
Section B: Management Tools • The Enterprise Manager • The SQL Server
Profiler • The SQL Server Analyzer
Section C: Using Books Online • What is Books Online? • The BOL User
Interface • Summary
Section D: Prerequisites • Overview • Hardware Requirements •
Software Requirements
Section E: Installing SQL Server • Before You Install • SQL Server
Editions • Running SQL Server Setup • Unattended Installation
Section F: Upgrading/Uninstalling • Guidelines for Upgrading • Switching
from 6.x to 7.0 • Uninstalling
Section G: Configuring the Server • Registering the Server • Setting
Up Security • Autostart • Server Settings • Memory Connections
• Processor • Database Settings • Security Overview
Module 2
Section A: Setting Up a Database • Database Fundamentals • Creating
a Database • Modifying a Database • Deleting a Database
Section B: Tables • Data Types • User Defined Data Types • Creating
Tables • Table Properties
Section C: Creating Indexes • Table Indexing • Creating Indexes
Section D: Normalization Basics • Data Normalization • Entity Integrity
• Domain Integrity • Referential Integrity • Business Rules •
Normal Form • Normalization Summary • Denormailization
Section E: Tools for Enforcing Data Integrity • Identity Columns •
Constraints • Rules • Referential Integrity • Creating Keys •
Database Diagrams • Creating a Relationship • Using Triggers
Price £375 (Bundle of 2)
Complementary Courses
SQ7D2 - SQL Server 7 for Developers Part 2
SQ7A - SQL Server 7 Administration
SQ7W - SQL Server 7 Datawarehousing
SQSD - SQL Server 7 Implementing Database Design
<<Back
<<Contact Us
|
