Available on video or CD ROM
Master Microsoft SQL Server 2000 Application Development with this easy-to-follow CD-ROM collection from AppDev, the company recognized throughout North America for world-class courseware and comprehensive training courses.
Whether you are learning
Microsoft SQL Server 2000 development for the first time or adding to your
reference library, you will find that AppDev’s Professional Training via
CD-ROM™ contains thorough, well-written content that is second to none:
About the Trainer
Andy Baron and Mary Chipman are co-authors and your instructors for the SQL Server 2000 CD-ROMs. 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.CD-ROM Features
AppDev's CD-based training is: |
Like training one-on-one with an expert -- full motion video allows you to see the steps, hear the explanations, and perform the critical tasks. |
|
A complete training solution, including printed books, sample code, and step-by-step, hands-on labs to reinforce key concepts. |
|
Convenient, giving you the freedom to learn at your own pace, wherever and whenever it suits your schedule. |
|
CD-ROM is easy to use, with streamlined interface featuring one-click navigation. |
|
100% guaranteed. |
Course Outline
CD-ROM 1 (95 min)SQL Server Tour
- SQL Server Editions
- Graphical Tools
- Exploring the Enterprise Manager
- Working with SQL Server Books Online
- Multiple Instances
- Installing an Instance of SQL Server
- Configuring the Server
- Relational Database Design Principles
Designing and Creating a Database (continued)
- Implementing the Design
- Introduction to the Query Analyzer
- Retrieving Data
Basic Querying (continued)
- Joining Tables
- Modifying Data
- Inserting Data
- Updating Data
- Deleting Data
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
- Overview of Transact-SQL
- Using Built-In Functions
Programming With Transact-SQL (continued)
- Control of Flow
- Error Handling
- Transactions
- Working with Locks
- Monitoring Processes and Locks
- Transaction Isolation
- Blocking and Deadlocks
- What is a View?
Creating Views (continued)
- Creating Views
- Updating Views
- Creating a Backup Strategy
- Implementing Backups
- Restoring from a Backup
- The Database Maintenance Plan Wizard
- Building Stored Procedures
Stored Procedures and Triggers (continued)
- Building Stored Procedures (continued)
- Building Triggers
- Using INSTEAD OF Triggers
- User-Defined Functions in SQL Server 2000
- Scalar Functions
- Inline Table-Valued Functions
- Multi-Statement Table-Valued Functions
- Functions, Views, and Stored Procedures
Advanced Queries and Linked Servers
- Dynamic SQL
- Transact-SQL Cursors
- Handling Large Data Sets
- Distributed Queries
- Security Overview
- Authentication
- Understanding Roles
- Assigning Permissions
Security (continued)
- Application Roles
- Evaluating Performance
- Monitoring with SQL Server Profiler
- Tuning Queries
- Working with Indexes
- Indexed Views
- Using the Index Tuning Wizard
- Data Caching
- The System Monitor
Using System Objects
- Exploring System Objects
- DBCC
- Configuring SQL Server Agent
- Operators
- Jobs
- Alerts
- Create an Alert
- Introduction
- The DTS Import/Export Wizard
Data Transformation Services (DTS) (continued)
- DTS Packages
- Controlling DTS Workflow
- Introduction to Replication
- Implementing Replication
- Publishing Data to the Web
- The Web Assistant Wizard
- The SQL Server Web Stored Procedures
- Scheduling Web Jobs
- XML Fundamentals
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
- Creating XML Views with Annotated Schemas
- Using Xpath to Retrieve SQL Server Data Directly
- Using OpenXML to Work with XML Documents in Transact-SQL
XML Features, Part II (continued)
- Using Updategrams
- What is Full-Text Search?
- Configuring Full-Text Search
- Writing Full-Text Queries
- Using Full-Text Search with Documents Stored in SQL Server
Analysis Services
- Understanding Analysis Services
- Building a Simple Cube
- Browsing Data from a Cube
- Exploring MDX
- Data Mining
- Overview of English Query
- Before You Start – Preparing Your Database
- Creating and English Query Application
- Deploying an English Query Application
Sale
price: $995.95
Click here for Secure Yahoo Order: Complete SQL 2000 Server Training Series
Get Train in SQL
SQL
Software Training
Best Regards,
Oracle Database,
SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.