This course is a detailed introduction to SQL designed for application programmers and end users of relational databases. The instructor discusses how to create relational databases and obtain information from them. The course shows you how to create tables and views, use outer joins, find information from the catalog, summarize and group information, use subqueries, and validate data using referential integrity and uniqueness constraints. Both Oracle and Access examples are given, and you use both products in the computer lab. Knowing SQL allows you to work effectively with a large variety of relational database systems.
Enrollment is limited.
Texts for late enrollees will be available at the Extension bookstore in San Francisco. For Section 3 only, there is one person per computer. For all sections, Oracle CDs will be distributed by the second meeting along with course readers. Introduction to Relational Database Management Systems X409.1 or familiarity with a relational database. Section 3 is an intensive format for experienced or advanced users only.