Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Microsoft SQL Server 7.0
with Richard Campbell

View the Course Outline

Our Microsoft SQL Server 7.0 training is designed for programmers who write applications that connect to Microsoft SQL Server and other SQL Server compliant databases. Whether you are new to client/server development or you’ve developed full-blown multi-tier solutions, Application Developers Training Company’s Microsoft SQL Server 7.0 training focuses on guiding intermediate-level database developers to more effective, efficient solutions to their application issues.

Course includes 15+ hours of total training time...

  • 7 CDs
  • Over 5 hours of media run time
  • Over 600 pages of courseware on CD-ROM
  • Step-by-step hands-on-labs
  • Sample code
 
Format Modules Retail Price
Microsoft SQL Server 7.0
CD-ROM

 7 CD-ROMs
$195.00  
CD-ROM & Books

  7 CD-ROMs + Printed Books
$265.00  
• Read about with Richard Campbell.
Course Outline (Outlines are subject to change.)

Level 1: SQL Server 7.0

Modules Run Time Pages
2 CDs 1 hour 200

Level 1 CD-ROMs teach you the how to install and configure Microsoft SQL Server 7.0 and how to get started setting up and designing your database.


In Level 1 you will learn...

  • Learn to install and configure Microsoft SQL Server 7.0.
  • Set up and normalize your database.
  • Import and link data to Microsoft SQL Server.
  • Convert databases from Microsoft SQL Server 6.5 to Microsoft Server 7.0.
  • Migrate your Microsoft Access databases into Microsoft SQL Server 7.0.

Prerequisites: To get the most out of the Introduction to Microsoft SQL Server 7.0 course, you should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.

 SESSION 1 (54min)

SQL Server Tour
  • 1.1 SQL Server Components
  • 1.2 Management Tools
  • 1.3 Overview of SQL Server Security
  • 1.4 Using Books Online
Installation and Configuration of SQL Server
  • 2.1 Prerequisites
  • 2.2 Installing SQL Server
  • 2.3 Upgrading from Previous Versions of SQL Server
  • 2.4 Uninstalling SQL Server
  • 2.5 Configuring the Server
 SESSION 2

Setting up a Database
  • 3.1 Creating Databases
  • 3.2 Creating, Dropping, and Altering Tables
  • 3.3 Modifying Tables
  • 3.4 Creating Indexes
Database Design
  • 4.1 What Is Data Normalization?
  • 4.2 Tools for Enforcing Data Integrity

back to top

Level 2: SQL Server 7.0

Modules Run Time Pages
5 CDs 4 hours 400

The first part of Level 2 focuses on querying; you’ll learn how to create a basic query using SELECT statements and then move into more advanced types of queries. Then you’ll learn how to use stored procedures, triggers, and views. Level 2 CD-ROMs also teach you techniques for making the best use of Microsoft SQL Server. You’ll learn how to optimally configure Microsoft SQL Server and use techniques for backing up your data.

In Level 2 you will learn...

  • Create basic queries using SELECT statements.
  • Use joins, subqueries, and action queries.
  • Use stored procedures, triggers, and views.
  • Use transaction processing and locking to resolve multi-user conflicts.
  • Configure and tune SQL Server using the Wizards.
  • Set up the security features of your SQL Server database.
  • Publish SQL Server data to the Web.
    •

Prerequisites:To get the most out of Developing Databases with Microsoft SQL Server 7.0, you should already know how to create and maintain tables in SQL Server, and how to write simple SQL queries for retrieving and manipulating data.

SESSION 3 (56 min)

Basic Querying
  • 5.1 Understanding SQL
  • 5.2 The SELECT Statement
  • 5.3 The WHERE Clause
  • 5.4 The ORDER BY Clause
  • 5.5 The GROUP BY Clause
Joining
  • 6.1 Principals of Joining
  • 6.2 Inner Joins
  • 6.3 Outer Joins
  • 6.4 Self Joins
  • 6.5 Unions
 SESSION 4 (52 min)

Action Queries
  • 7.1 Data Manipulation
  • 7.2 Inserting Data
  • 7.3 Updating Data
  • 7.4 Deleting Data
Advanced Querying
  • 8.1 Distributed queries
  • 8.2 OpenRowSet
  • 8.3 OpenQuery
  • 8.4 Advanced Transact-SQL
  • 8.5 Parallelism
 SESSION 5 (84 min)

Stored Procedures, Triggers and Views
  • 9.1 Introduction to Stored Procedures
  • 9.2 Writing Stored Procedures
  • 9.3 Triggers
  • 9.4 Views
  • 9.5 System Functions Reference
Tuning and Configuration
  • 10.1 Filegroup Tuning
  • 10.2 Partitioning Data
  • 10.3 Optimizing Queries
  • 10.4 Optimizing Hardware (and NT)
  • 10.5 Performance Monitor
SESSION 6 (51 min)

Transaction Processing 11.1 Transactions
  • 11.2 Working with Locks
  • 11.3 Monitoring Processes and Locks
  • 11.4 Transaction Isolation
  • 11.5 Deadlocking
Maintaining and Backing up SQL Server
  • 12.1 Backup and Restore
  • 12.2 Creating a Backup Strategy
  • 12.3 Implementing Backups
  • 12.4 Introducing the Database Maintenance Plan Wizard
  • 12.5 Restoring from a Backup
SESSION 7 (56 min)

Security
  • 13.1 Security Overview
  • 13.2 Authentication
  • 13.3 Assigning Permissions
  • 13.4 Using Roles
  • 13.5 Administering Security
Using Microsoft OLAP Services
  • 14.1 Understanding OLAP Cubes
  • 14.2 Building a Simple Cube
  • 14.3 Browsing Data from a Cube

back to top

Your Instructor

Richard Campbell is your instructor. Richard is a director for Eclipse Software, developing Internet applications using Visual InterDev, Visual Basic, and SQL Server. He is a consultant to corporations on development methodology, technology and training, as well as technical editor for Access/Office/VB Advisor, co-author of the Advisor Answers column, and a member of the organization team for the Advisor DevCon conferences. Richard is also the author of the courseware for national SQL Server 7.0 training seminars and these video tapes.

back to top

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007 		 
? Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy