Sysoft 7140 - Database Integration

Email: train@sysoft.com Phone: (800) 467-9736 or (732) 549-9002 Fax: (732) 549-7060

Sysoft 7140	Database Integration
Description	This course focuses on integrating databases in Web applications with special attention to performance, ease of development and security.
Certification	- SIP Level 2
Topics	- Databases on the Web - Using a Database to Publish Data on the Web - Using a Database to Share Data - Sharing Messages - Sharing a Mailing List - Using a Database for E-Commerce - E-Commerce on a Grand Scale--the Shoe Store - E-Commerce on a Small Scale--Machine Parts - Using a Database to Keep Web Pages up to Date - Database Concepts - How Databases Work on the Web - Creating a Database-Driven Web Site: Overview - Internet Service Provider/Database Service Provider - Database Software - Application Servers and Other Intermediaries - CGI Scripts and Perl - Transitions - Other Internet/Database Service Provider Services - E-Commerce and Secure Servers for serving Database - Maintenance and Support - Database Quality Issues - Marketing of Databases - Database Pricing Platforms and Environments - Types of Databases - End-User Tools - Programmer Tools - Custom-Written Databases - Microsoft Access - Microsoft Access Overview Tables - Queries - Forms - Reports - Macros - Modules - Using ODBC - Publishing on the Web Publish to the Web Wizard - Static HTML - Using IDC/HTX Files Active Server Pages - Using ADO/RDS - Publishing Your Files - Upsizing Microsoft Access Databases - FileMaker Pro - FileMaker Pro Overview - Databases Relations - Layouts Searches - Scripts - Modes - Publishing on the Web - Instant Web Publishing - Databases for Programmers - DB2 - Oracle - Microsoft SQL Server - Sybase - Informix - Application Servers and Development Tools - Where Is the Application Server? - Tools for Working with Application Servers - Database-Centric Tools - HTML-Centric Tools - Programmer-Centric Tools - Which Tool Is Right for You? - Tango Enterprise - Why Tango? - The Tango Workspace - Defining Actions - Manipulating Data - Sending Mail and Writing to Files - SQL and Relational Databases - Publishing Data on the Web - Sharing Data - E-Commerce - Keeping Web Pages Up to Date - General Database Needs - The Relational Model - The Relational Model in Two Simple Points - Objects - Integrity - Operators - Normalization - SQL - The Basic Rule of SQL - Why This Matters for Database-Driven Web Sites - Cursors - Why This Matters - Sensitive Cursors - Select Examples of Select Statements - Why This Matters - Insert - Delete - Update - Create - Views - Indexes - Programming with Databases - Result Sets - Procedural Programming - Database Programming - Differences between Procedural and Database Programming - Why This Matters - Timing and Performance - Automating Web Page Production - Interface Adaptations - Transaction Processing - The Data and Nothing But the Data - Sending Data to Web Sites with HTTP and Forms - Requesting a Resource on the Web - Actions - URLs - Sending Data as Part of a Request Searchparts and Queries - Sending Data in the Message Body - Forms and Tables - A Table Example HTML for the Table Example - The Navigation Bar - The Data Entry Form - What Is a Form? - Form Tags - Controls - Types of Controls - Attributes of Controls - Hidden Controls - Submitting a Form - Form Design Issues - Size of Forms Scrolling and Screen Size - Logical Size - Managing Large Databases - Net Dyanamics - Cold Fusion - ODBC/JDBC - ASP/ADO/RDS - Symantec Cafe - Database Edition