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


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Microsoft SQL Server 2000
with Mary Chipman & Andy Baron


View the Course Outline

Our Microsoft SQL Server 2000 training is designed for developers who want to use SQL Server to build robust, scalable database applications

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

  • 14 modules of training
  • Over 20 hours of media run time
  • Over 1000 pages of printable courseware
  • Step-by-step hands-on-labs
  • Sample code
Microsoft SQL Server 2000
Format Modules Retail Price

CD-ROM

14 CD-ROMs

$295
Buy Now!

CD-ROM & Books

14 CD-ROMs + Printed Books

$435
Buy Now!

DVD-ROM

2 DVD-ROMs

$295
Buy Now!

DVD-ROM & Books

2 DVD-ROMs + Printed Books

$435
Buy Now!

Order online 

Read about Mary Chipman & Andy Baron

Course Outline(Outlines are subject to change.)

Microsoft SQL Server 2000

Modules Run Time Pages
14 20 hours 1000

This course is for developers coming from Microsoft Access, Visual Basic, Active Server Pages or other development backgrounds who want to learn to build successful databases solutions with SQL Server. Even developers who've already used Oracle, Sybase, DB2 or other relational database management systems will find this course useful for getting up to speed on SQL Server 2000. You'll learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll also learn how to take advantage of SQL Server's tools for maintaining your databases.

SQL Server 2000 includes a rich set of tools that go beyond the basics of querying and manipulating data. Microsoft added many very useful capabilities in SQL Server that most developers never discover. You'll learn how to take advantage of SQL Server's tools for securing and tuning your databases. You'll also learn about the advanced features available to you for maintaining, analyzing, searching and distributing your data. Integrate your data safely with Internet and cross-platform applications.


In this course, you will...

  • Learn to install and configure Microsoft SQL Server 2000.
  • Understand basic database design principles and how to implement them in SQL Server.
  • Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
  • Use the programming environment in the Query Analyzer.
  • Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each.
  • Design and implement reliable backup and maintenance plans.
  • Understand the SQL Server security model; and create logins, users and permissions to protect your data.
  • Configure and tune SQL Server, and monitor database activity.
  • Use Data Transformation Services (DTS) to import and export data, or to move it between external data sources, handling data mapping and conversion when necessary.
  • Support distributed users by implementing SQL Server Replication, and understand which replication options are appropriate for which requirements.
  • Publish data to the Web, and take advantage of SQL Server 2000s rich support for Extensible Markup Language (XML).
  • Use Analysis Services to create online analytical processing (OLAP) solutions and to mine your data for hidden patterns.
Prerequisites :

To get the most out of this 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.

MODULE 1

SQL Server Tour
  • SQL Server Editions
  • Graphical Tools
  • Exploring the Enterprise Manager
  • Working with SQL Server Books Online
Installing SQL Server
  • Multiple Instances
  • Installing an Instance of SQL Server
  • Configuring the Server
Designing and Creating a Database
  • Relational Database Design Principles
MODULE 2

Designing and Creating a Database (continued)
  • Implementing the Design
Basic Querying
  • Introduction to the Query Analyzer
  • Retrieving Data
` MODULE 3

Basic Querying (continued)
  • Joining Tables
Action Queries
  • Modifying Data
  • Inserting Data
  • Updating Data
  • Deleting Data
MODULE 4

Using the Query Analyzer
  • Query Analyzer Features
  • The File Menu Items
  • The Edit Menu
  • Query Menu Items
  • Tools Menu Items
  • Window Menu Items
  • Help Menu Items
Programming With Transact-SQL
  • Overview of Transact-SQL
  • Using Built-In Functions
MODULE 5

Programming With Transact-SQL (continued)
  • Control of Flow
  • Error Handling
Transaction Processing
  • Transactions
  • Working with Locks
  • Monitoring Processes and Locks
  • Transaction Isolation
  • Blocking and Deadlocks
Creating Views
  • What is a View?
MODULE 6

Creating Views (continued)
  • Creating Views
  • Updating Views
Backups and Maintenance
  • Creating a Backup Strategy
  • Implementing Backups
  • Restoring from a Backup
  • The Database Maintenance Plan Wizard
Stored Procedures and Triggers
  • Building Stored Procedures
MODULE 7

Stored Procedures and Triggers (continued)
  • Building Stored Procedures (continued)
  • Building Triggers
  • Using INSTEAD OF Triggers
User-Defined Functions
  • User-Defined Functions in SQL Server 2000
  • Scalar Functions
  • Inline Table-Valued Functions
  • Multi-Statement Table-Valued Functions
  • Functions, Views, and Stored Procedures
MODULE 8

Advanced Queries and Linked Servers
  • Dynamic SQL
  • Transact-SQL Cursors
  • Handling Large Data Sets
  • Distributed Queries
Security
  • Security Overview
  • Authentication
  • Understanding Roles
  • Assigning Permissions
MODULE 9

Security (continued)
  • Application Roles
Monitoring, Tuning, and Configuration
  • Evaluating Performance
  • Monitoring with SQL Server Profiler
  • Tuning Queries
  • Working with Indexes
  • Indexed Views
  • Using the Index Tuning Wizard
  • Data Caching
  • The System Monitor
MODULE 10

Using System Objects
  • Exploring System Objects
  • DBCC
Automating Administration with SQL Agent
  • Configuring SQL Server Agent
  • Operators
  • Jobs
  • Alerts
  • Create an Alert
Data Transformation Services (DTS)
  • Introduction
  • The DTS Import/Export Wizard
MODULE 11

Data Transformation Services (DTS) (continued)
  • DTS Packages
  • Controlling DTS Workflow
Replication
  • Introduction to Replication
  • Implementing Replication
Publish SQL Server Data to the Web
  • Publishing Data to the Web
  • The Web Assistant Wizard
  • The SQL Server Web Stored Procedures
  • Scheduling Web Jobs
XML Features, Part I
  • XML Fundamentals
MODULE 12

XML Features, Part I (continued)
  • Generating XML from SQL Queries with FOR XML
  • Using FOR XML Explicit
  • Setting Up IIS for SQL Server
  • Accessing SQL Server Using a URL
XML Features, Part II
  • Creating XML Views with Annotated Schemas
  • Using Xpath to Retrieve SQL Server Data Directly
  • Using OpenXML to Work with XML Documents in Transact-SQL
MODULE 13

XML Features, Part II (continued)
  • Using Updategrams
Full Text Search
  • What is Full-Text Search?
  • Configuring Full-Text Search
  • Writing Full-Text Queries
  • Using Full-Text Search with Documents Stored in SQL Server
MODULE 14

Analysis Services
  • Understanding Analysis Services
  • Building a Simple Cube
  • Browsing Data from a Cube
  • Exploring MDX
  • Data Mining
English Query
  • Overview of English Query
  • Before You Start Preparing Your Database
  • Creating and English Query Application
  • Deploying an English Query Application

back to top


Your Instructor

Andy Baron and Mary Chipman are co-authors and your instructors. They are both Senior Consultants with MCW Technologies, a Microsoft Certified Solution Provider. Mary and Andy specialize in database application development, training, and writing about SQL Server, Visual Basic, the .NET framework and related technologies. They are Contributing Editors at Advisor Media and at Pinnacle Publishing, contributing writers for SQL Magazine, and frequent speakers at industry conferences. Mary and Andy have both received Microsoft's Most Valuable Professional (MVP) award every year since 1995, based on their contributions to Microsoft's online support newsgroups. They are co-authors of The Access Developer's Guide to SQL Server, published by Sams, and Mary co-authored SQL Server 7.0 in Record Time, published by Sybex.

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