SQL Server Web Integration

This course introduces several new or enhanced technologies, procedures, and tools for increased dependence on the Web for business applications. The course presents a comprehensive view of Web applications with SQL Server 7.0. The course outlines Microsoft's overall Web strategy, including reasons for linking the databases to Web clients, possible tasks that can be accomplished through Web applications, tools used for integration and technologies involved. This course introduces the overall concept of web and database integration with Microsoft's SQL Server 7.0 and describes how to use the Web Assistant and its Wizard. The course outlines enhancements to the Microsoft server product, Internet Information Server, how it works, and what tools are available. This course is written to SQL Server 7.0.

SQL Server Web Integration training covers such topics as:

Integrating with the Web
The Web Assistant
IIS as a Publishing Tool
Server-side Technologies
Client-side Technologies

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 students 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 introduces several new or enhanced technologies, procedures, and tools for increased dependence on the Web for business applications. The course presents a comprehensive view of Web applications with SQL Server 7.0. The course outlines Microsoft's overall Web strategy, including reasons for linking the databases to Web clients, possible tasks that can be accomplished through Web applications, tools used for integration and technologies involved. This course introduces the overall concept of web and database integration with Microsoft's SQL Server 7.0 and then describes the elements of and enhancements to the Web Assistant in version 7.0 and how to use the Web Assistant and its Wizard. The course describes enhancements to the Micros oft server product, Internet Information Server, how it works, and what tools are available. Many of the Microsoft technologies have broader SQL Server 7.0 application, but for Web integration, they mean ease of integration, speed, and flexibility for users. Discussed are two programming interfaces recognized by Internet Information Server (ISAPI and CGI), ActiveX Data Objects (ADO), OLE DB, and ASP. Operating from the client side of the architectural model, the ActiveX Documents, ActiveX Controls, ActiveX Scripting, and English Query tools enhance the user's ability to query the database and to transmit the request. This course is written to SQL Server 7.0. Related Exams: Prepares users for both 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. Students are expected to have successfully completed SQL Server 7.0: Introduction, SQL Server 7.0: Installing and Upgrading, SQL Server 7.0: Management Parts I, II, and III, SQL Server 7.0: Database Administration Part I and Part II, SQL Server 7.0: Data Warehousing Using SQL Part I and Part II, SQL Server 7.0: Developing SQL Client/Server Part I and Part II, and SQL Server 7.0: Advanced Features Part I and Part II courses.
Course Duration
» 5 hours
Everything Courseware
SQL Server Web Integration
Topics Include
Unit 1: Integrating with the Web
» Why Integrate? Relationship to Client/Server Model Tools, Server-side Technologies
» Client-side Technologies
Unit 2: The Web Assistant
Unit 3: IIS as a Publishing Tool
Unit 4: Server-side Technologies
Unit 5: Client-side Technologies

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)