Profile

e-Catalog

Contact

Search

Cart

Web and Database Integration

Audience

A wide range of information technology (IT) professionals, including IT managers, system integrators, departmental managers, consultants, and strategic IT planners

Prerequisites

A working knowledge of database and Internet concepts is assumed; the courses Relational Principles, Database Fundamentals, Database Design, and Database Management, while not essential, would be beneficial

Course Aim

To introduce the technologies used to build and deploy web databases

Learning Objectives

Describe the technologies used to build and deploy databases. Recognize and interpret simple SQL statements. Outline the technologies involved in creating web database applications. Identify the security risks of connecting databases to the Web and identify the security measures that can be taken to overcome them. Describe how to incorporate legacy databases with the Internet. Describe how to optimize a web database application.

Topics Covered

Database technologies - Web databases - Flat file and relational databases - Object-oriented databases - Structured Query Language - Exercise: Database technologies Application architecture - Application layers - Client-side gateways - Server-side gateways - Database connection layer - Exercise: Identifying layers - Exercise: Comparing gateways Securing databases on the Web - Internet security - SSL and database privileges - Building a firewall - Exercise: Identifying security solutions Applying databases to the Internet - Integrating legacy databases - Optimizing database performance - The future of web databases - Exercise: Optimizing performance