Main Pages

Trainingwarehouse | Courseware | IT Instructor-Led Courseware | Databases | Database-Driven Web Sites

Trainingwarehouse > Courseware > IT Instructor-Led Courseware > Databases > Database-Driven Web Sites

Database-Driven Web Sites Student Manual Ref: TMDDWS Days of training: 5 Prerequisites: Students taking this course should be familiar with the Windows operating system and with using Internet Explorer to view Web pages. Students should also have experience programming with Visual Basic. Web Database Processing Understanding the basics of the Web Understanding Web Basics Understanding communication protocols and Web addresses Understanding listener processes Understanding the basics of databases Understanding databases Understanding client/server databases Understanding Web pages Creating dynamic Web pages using client-side processing Creating dynamic Web pages using server-side processing Relational database concepts and introduction to Microsoft Access Introduction to relational databases Understanding relational databases Understanding the Clearwater Traders Sales Order database Creating database tables and inserting data Creating a database table Importing tables into a database Enforcing referential integrity Inserting data Updating and deleting data Structured Query Language (SQL) Using SQL to create database queries Writing a query to retrieve all data rows from a single table Creating a query that retrieves specific records Using AND or OR operators to retrieve specific records Using IS NULL and IS NOT NULL operators Sorting query results Calculating the difference between integer values Calculating the difference between two date values Using the GROUP BY clause in a query Using the COUNT function Using SQL to perform queries on multiple tables Joining data in multiple related tables Using the UNION query Using SQL to insert, update or delete data Inserting records into a table Entering specific values into a table Updating a record in a table Updating multiple records in a table Updating all the records in a table Deleting a record from a table Deleting records from related tables Introduction to HTML Using basic HTML tags to create Web pages Creating a Web page Formatting text Adding graphics and rules to a Web page Tables in Web pages Creating a table Changing the table size and alignment Working with columns Applying table borders and cell spacing Aligning table objects Using Hyperlinks Creating hyperlinks to a point within a Web page Creating a hyperlink to another Web page Creating a hyperlink to an e-mail address Web Servers Introducing the Personal Web Server Using the Personal Web Server Observing the root document directory and the default document Browsing directories Creating and managing virtual directories Examining the Web site activity log Monitoring Web site performance Referencing files on a Web server Using absolute URL addresses Using relative URL addresses Comparing Personal Web Server with Internet Information Server Using Visual Basic 6.0 to create Web-based database applications Discussing the Visual Basic 6.0 interface Using Visual Basic to create an application Examining a Visual Basic project Using Visual Basic to create a database application Creating a Visual Basic database application Creating the ADO data connection object Processing SQL queries Using code to modify form control properties Creating code to insert, update and delete records Using a DataGrid control Using the Packaging and Deployment Wizard Creating an ActiveX document Creating an installation package for your ActiveX document Displaying an ActiveX document using a hyperlink Client-side scripts Relating HTML forms and scripting Creating a Web form Using a scripting language Creating client-side scripts using VBScript Referencing form fields and button click events Discussing VBScript variables and their scope Understanding Functions Using advanced VBScript Validating HTML form inputs Debugging client-side scripts Creating temporary cookies Creating persistent cookies Displaying Web pages and sharing cookie values Displaying a Web page in a new browser window Displaying a new Web page in the same browser window Retrieving the values of individual cookie variables Server-side scripts Introduction to Active Server Pages Creating a directory on the Web server for ASP files Writing an ASP script Creating a hyperlink with a dynamic URL Retrieving input parameters into an ASP Debugging ASP scripts Creating a Web page application Sharing data values between multiple ASPs Verifying and summarizing data Creating and retrieving cookies using client-side scripts Using client-side scripts to navigate to ASPs Inserting data into a database Processing and updating databases Creating cookies Suppressing form parameter values in URLs Compiled Web Server programs Introduction to the Common Gateway Interface Writing a CGI Program using Visual Basic 6.0 Displaying a Web page Retrieving records from a database Debugging a program using Visual Basic Retrieving input variables Sharing data values with other CGI programs Advantages and disadvantages of a CGI program Using ActiveX DLL's for server-side Web processing Comparing CGI Programs with ActiveX DLLs Creating an ActiveX DLL using Visual Basic Retrieving database data in an ActiveX DLL Passing form input parameters to an ActiveX DLL Database-Driven Web Sites Student Manual Price: (4 or fewer items) £39.95 (Excluding VAT at 17.5%) Price: (5 to 19 items) £35.96 (Excluding VAT at 17.5%) Price: (20 to 49 items) £31.96 (Excluding VAT at 17.5%) Price: (50 or more items) £27.97 (Excluding VAT at 17.5%)		Quantity:

Database-Driven Web Sites Instructor Manual Ref: TIDDWS Price: £40.95 (Excluding VAT at 17.5%)		Quantity:

Trainingwarehouse > Courseware > IT Instructor-Led Courseware > Databases > Database-Driven Web Sites