The purpose of these sessions is to introduce SLU IT professionals to concepts related to relational databases, database management systems (DBMS's) and database applications. The focus of the sessions will be to prepare each person for up-coming Oracle Training. Hands-on activities will be presented using Microsoft Access and Oracle PL/SQL. instructor: Rick Mathieu, Department of Decision Sciences and MIS email: mathieur@slu.edu phone: 977-2127 |
Relational Database Concepts Preparation for Oracle Training at Saint Louis University |
The purpose of these sessions is to introduce SLU IT professionals to concepts related to relational databases, database management systems (DBMS's) and database applications. The focus of the sessions will be to prepare each person for up-coming Oracle Training. Hands-on activities will be presented using Microsoft Access and Oracle PL/SQL. instructor: Rick Mathieu, Department of Decision Sciences and MIS email: mathieur@slu.edu phone: 977-2127 |
Proposed Schedule (location: Davis-Shaughnessy Hall Room 373): |
Friday April 4 |
Topic: Components of a database system. Relational terminology. |
Activity: Forms, reports and queries in Access |
Friday April 11 |
Topic: Intertable and intratable data integrity. Key fields. ER diagrams; SQL |
Activity: SQL - table creation in Oracle |
Friday April 25 |
Topic: SQL - Joins, Subqueries, Views; Working in the SQL *Plus Environment |
Activity: Views in Oracle; Formatting in Oracle; Access Reports |
Friday May 2 |
Topic: Intro to PL/SQL - Procedures, Triggers; Web-Based DB Applications; Intro to XML |
Activity: PL/SQL; ASP; XML |