DB101: Database Driven Websites (2 days)

Course Overview

This is an intensive two-day course designed to provide attendees with a background in architecting database-driven web systems. The course begins with a short overview of client and server technologies available for database-driven systems including HTML, XML, CSS, JavaScript, Flash, Scripting Languages, LAMP, J2EE, .NET, Portal Systems & RDBMS systems. Next, the course examines the Oracle 9i RDBMS/Oracle 9iAS Application Server product suite as an exemplar of a modern product set for database-driven websites. This examination covers the RDBMS (including SQL & PL/SQL), iAS Application Server including Oracle Components for Java (OC4J), TopLink, Portal(formerly WebDB), and Internet File System (iFS). The discussed technologies excel at developing websites which are data centric.

Finally, the course looks at the J2EE architecture defined by Sun and implemented by vendors such as BEA, IBM, Oracle & Open Source developers. The J2EE platform represents the state of the art technology for developing database-driven websites which are cross-platform and processing centric, i.e. are built using components which represent application logic or support integration with external systems. Topics covered in this section include Java Database Connectivity (JDBC), SQLJ, JDO, Java Servlets, Java Server Pages (JSP), JSP Tag Libraries, Enterprise Java Beans (EJB) and Web Services. The course includes realistic hands-on exercises which illustrate and complement the up-to-date lectured content. This course will provide participants with a formal appreciation of the pros and cons of database-driven web sites and systems, an understanding of Oracle's web development & deployment options, and a hands-on appreciation of J2EE technologies which facilitate database-driven website development.

Audience

This course is designed for architects, developers and programmers of web sites and web applications, and website managers.

Course Objectives

This course will provide participants with:

• A background in architecting database-driven web systems
• A formal appreciation of the pros and cons of database-driven web sites and systems
• An understanding of Oracle's web development & deployment options
• A hands-on appreciation of J2EE technologies which facilitate database-driven website development

Pre-Requisites

Students should be familiar with, and be able to construct basic web pages using HTML, and have some exposure to developing web scripts and applications (preferably with Java) for dynamic web content delivery. Additionally, basic database operation using a modern RDBMS (preferably Oracle), and querying of databases using SQL is recommended.

Course Topics

The following key topics will be covered over the 2 day period:

• Overview of client and server technologies available for database-driven systems including:
• HTML
• XML
• CSS
• JavaScript
• Flash
• Scripting Languages
• LAMP
• J2EE
• .NET
• Portal Systems
• RDBMS Systems
• Examination of the Oracle 9i RDBMS/Oracle 9iAS Application Server product suite as an exemplar of a modern product set for database-driven websites. This covers:
• RDBMS (including SQL & PL/SQL)
• iAS Application Server including Oracle Components for Java (OC4J)
• TopLink
• Portal (formerly WebDB)
• Internet File System (iFS)
• J2EE architecture defined by Sun and implemented by vendors such as BEA, IBM, Oracle & Open Source developers. Topics include:
• Java Database Connectivity (JDBC)
• SQLJ
• JDO
• Java Servlets
• Java Server Pages (JSP)
• JSP Tag Libraries
• Enterprise Java Beans (EJB)
• Web Services
• Practical Exercises