SQL Server 7.0 Management Part III

Press here to Purchase this Product includes all topics outlined MSRP ~~$349.95~~
Sale $159.95
Learn all the topics listed below
Main Page

Installing, Configuring, Administering Microsoft Windows 2000 Professional (70-210)

Installing and Upgrading

Installing on Multiple Computers

Managing Standard Hardware Devices

Enhanced Support for Hardware Devices

Administering Users and Groups

Administering Resources

Customizing the Desktop Environment

Optimizing System Performance

Recovering Data & System Performance

Implementing and Monitoring Security

Connecting through Networks

Installing, Configuring, Administering Microsoft Windows 2000 Server (70-215)

Installing and Upgrading

Managing Hardware Devices & Drivers

Managing File and Print Resources

Configuring Storage Use

Maintenance and Troubleshooting

Implementing Local Security and Policies

Monitoring and Optimizing

Configuring Network Services

Managing Terminal Services

Setting Up Remote Access Service

Sharing Resources Over the Internet

Implementing Interoperability

Automated Methods of Installation

Implementing and Administering Microsoft Windows 2000 Network Infrastructure (70-216)

Administering DNS

Administering DHCP

Administering WINS

Configuring Network Protocols

Configuring IP Routing Protocols

Configuring Internet Connection Sharing and Network Address Translation

Administering RAS

Using Certificate Services

Implementing and Administering Microsoft Windows 2000 Directory Services Infrastructure (70-217)

Installing, Configuring & Troubleshooting Active Directory

Managing & Optimizing Active Directory Components

Implementation Change & Configuration Management

Managing User Environments & Software Deployment

Remote Installation of Windows 2000

Designing a Microsoft Windows 2000 Directory Services Infrastructure (70-219)

Introduction to Windows 2000 Active Directory Services Infrastructure

Business Requirements and Naming Strategies

Planning a Domain Structure in Windows 2000 Active Directory Services

Active Directory Security & Replication Strategies

Advanced Active Directory Concepts

Designing Security for a Microsoft Windows 2000 Network
(70-220)

Analyzing an Organization's Security Requirements

Providing Security Access in a LAN

Providing Security Access in Remote Networks

Providing Security Access-Internet

Designing a Microsoft Windows 2000 Network Infrastructure (70-221)

Preparing for Windows 2000 Network Server Infrastructure

Designing a Network Strategy

Designing a WINS/DFS Strategy

Internet Connection Infrastructure

Wide Area Network Infrastructure

Internet Connectivity Strategy

Supplementary Courses

Windows 2000 Server Migration Part I

Windows 2000 Server Migration Part II

SQL Server 7 Implementation - Implementing a Database Design on Microsoft SQL Server 7.0 (70-029)

Introduction

Installing and Upgrading

Management Part I

Management Part II

Management Part III

Data Warehousing Using SQL Part I

Data Warehousing Using SQL Part II

Developing SQL Client/Server Part I

Developing SQL Client/Server Part II

Advanced Features Part I

Advanced Features Part II

Web Integration

SQL Server 7 Administration - System Administration for Microsoft SQL Server 7.0 (70-028)

Database Administration Part I

Database Administration Part II

SQL Server 7.0 Management Part III

This course explains how to design a logical model of a database and identifies the components to use in order to organize and access a SQL Server database. It describes the advanced programmatic features of the SQL language, which can be used to extend the functionality of SQL stored procedures. The course examines the functions of a SQL cursor, including how to navigate a result set using a cursor. It describes different types of cursors and the meaning of the global and local scope of a cursor. It explains how to design and manage explicit, implicit, and automatic transactions and it describes different locks.

Management Part III training covers such topics as:

Database Design
Advanced Transact-SQL
Cursors
Transaction Management

This course is designed for Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential. The series will help the student pass the Microsoft Exam 70-028: Administering Microsoft SQL Server 7.0 and Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0.

Description
This course explains how to design a logical model of a database and identifies the components to use in order to organize and access a SQL Server database. It describes the advanced programmatic features of the SQL language, which can be used to extend the functionality of SQL stored procedures. Additionally, this course examines the functions of a SQL cursor, including how to navigate a result set using a cursor. It describes different types of cursors and the meaning of the global and local scope of a cursor. It also explains how to design and manage explicit, implicit, and automatic transactions and it describes different locks. Related Exam: Microsoft exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.
Audience
Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential. The series is designed to help the student pass the Microsoft Exam 70-028: Administering Microsoft SQL Server 7.0 and Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0. This series is also appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure Microsoft SQL Server.
Prerequisites
Students understand computer system fundamentals, and have user knowledge of Windows 95, Microsoft Office, Internet browsing, and HTML, and e-mail systems.
Course Duration
» 5 hours
Topics Include
Unit 1: Database Design
» Creating a Logical Data Model
» Logical Database Components
» Data Integrity
Everything Courseware
SQL Server 7.0 Management Part III
Unit 2: Advanced Transact-SQL
» Programming SQL Variables
» Using Control-of-Flow Language
» SQL Transactions
» Creating Stored Procedures
» Implementing Error Handling
Unit 3: Cursors
» Declaring Cursors
» Types of Cursors
» Navigating a Cursor
Unit 4: Transaction Management
» Designing a Transaction
» Locking
» Avoiding Deadlocks

System Requirements CD-Based » Pentium class computer » 200 MHz processor (266 MHz recommended) » 32 MB RAM (64 MB recommended) » CD-ROM drive » Any one of Windows 95, Windows 98, Windows Me, Windows NT 4.0, Windows 2000 or Windows XP (both Windows NT 4.0 and Windows 2000 require at least 64 MB RAM) » SVGA monitor capable of 16-bit color and 800 x 600 screen resolution » Sound card with speakers or headphones (optional)