SQL Server 2000 Foundation for Web Developers
Duration 3 days
Objectives
After completing this course you will be able to use Structured Query Language to build basic queries and to assemble and summarise information from related data. You will learn how to build stored procedures and triggers and to create and administer your SQL Server database. Finally you will create reports and build a simple web application from your database.
This course is aimed at Web Developers wishing to create data-driven driven web sites for their customers. Requirements
Knowledge of static web page construction and design; familiarity with HTML and a scripting language (such as JAVASCRIPT or VBSCRIPT) an advantage but not essential.
Course Outline
SQL Server and Databases Overview
• Overview of SQL Server
• SQL Components
• Database Elements
• What is a table?
• Normalisation and Relations
• Primary and Foreign Keys
Using Structured Query Langauge
• Overview of Structured Query Language
• The SELECT statement
• WHERE, LIKE and Wildcards
• Inner Joins
• Outer Joins
• Transact SQL vs ANSI SQL92
Manipulating Your Data
• Data Manipulation Language (DML)
• INSERT, UPDATE
• Using Transactions - The basic Unit of work
• Using data from within MS WORD
Using SQL Server Data in Microsoft Access
• Bridging the gap between desktop and server databases
• Linking Tables
• Using Access for Reporting
• Building a Report in Access
Creating Stored Procedures
• Storing SQL in the Database
• The CREATE PROCEDURE command
• The EXEC command
• Variables and Cursors
• Passing Parameters to Stored Procedures
• Returning Results and Result Sets
• Output Parameters
Using Triggers
• Controlling Changes to the Database
• The CREATE TRIGGER command
• Optimal use of Triggers
• Managing Triggers
• Special Tables: Inserted and Deleted
Managing Databases
• Working with SQL Server Enterprise Manager
• The Server Subtree Nodes
• Creating Databases
• Creating Database Objects
• Scripting Databses objects
Security and Safety of your Server
• Backing up the Database
• Restoring the Database
• Controlling Access to the Database
• Security and Permissions
Putting it all Together: Building a Web Application I
• Simple Web Publishing
• Internet Databse Connector (IDC)
• Overview of the Database Server Process
• The IDC file and the HTX file
Putting it all Together: Building a Web Application II
• ASP, ADO and COM
• Introduction to VBSCRIPT
• An Active Server Page document
• Using Objects
• ActiveX Data Objects
• Displaying Data
Putting it all Together: Building a Web Application III
• Planning your application
• Designing an interface
• Describing a logical Data Model
• The Guestbook Application
• Handling updates
• Guestbook ASP page
• SignBook ASP page
• SaveEntry ASP page
• Comments ASP page
| 
