SQL Server 7.0 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 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 Microsoft 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 programing 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 .

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 5 hours Training Presented in: English

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.

Objective

Upon completion of this course the student will be able to:

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

• Using the Web Assistant Wizard
• Stored Procedures and Queries
• Calling the Web Assistant

Unit 3: IIS as a Publishing Tool

• Overview
• Components
• Levels of Internet Support

Unit 4: Server-side Technologies

• Web Programming Interfaces
• ActiveX data Objects (ADO)
• Active Server Pages

Unit 5: Client-side Technologies

• ActiveX Documents
• ActiveX Controls
• ActiveX Scripting
• English Query

Duration

5 Hours

Minimum Requirements

IBM-compatible PC with 166 MHz or higher processor 32 MB RAM (64 MB RAM recommended); 800x600 SVGA color monitor with 16-bit high color display; Internet Explorer 4 or Netscape Navigator 4 or later with Shockwave 7.0.1; Windows 95 Windows 98 Windows NT; 3.5 diskette (for tracking); 28.8 kbps connection or higher for on-line use.

Media

CDROM
Web Based Training

• SQL Server 7.0 Installing and Upgrading
• SQL Server 7.0 Introduction