Computer Technology and Information Management

A to Z Course Index

Information Sessions

Certificate Programs

Transcripts

Course Locations

Concurrent Enrollment

Order a Catalog

Courses begin every month. A new edition of our catalog is published three times a year in early April, July and December.

Quick Enroll	Search

Introduction to Relational Database Management Systems

X409.1 (2 semester units in EECS-DCS)

A requirement in the Post-Baccalaureate Certificate in Information Systems and Management and a requirement in the Professional Sequence in Database Management

Learn effective relational database design and gain a general overview of relational database management systems. This class introduces students to the terminology and methods used to create and modify Database Management Systems (DBMS). Emphasis is given to accessing large databases and developing methods for working with data on different DBMS. The course concentrates on helping students gain confidence in using DBMS and understanding data structures.

Upon successful completion of this course, students will be able to explain the fundamental architecture of existing database management systems, including data storage techniques of the relational database model. They will be able to use Query-By-Example (QBE) and SQL to formulate basic database queries and transform business requirements into logical and physical database designs using the Normalization Process.

Prerequisite: A previous programming course in any language or equivalent experience is recommended.

There are currently no sections open for enrollment.

---

Sections closed for enrollment

Wed. Oct. 7, San Francisco

ANDREW J. OPPEL, B.A., is a lead data modeler at Blue Shield of California who has more than 30 years of experience in information technology and more than 20 years of experience teaching with UC Berkeley Extension. He is also author of Databases Demystified, SQL Demystified, and Databases: A Beginner's Guide, and co-author of SQL, A Beginner's Guide, all published by McGraw-Hill Professional.

Revised class schedule in red.

• 10 meetings
• Oct. 7 to Dec. 16: Wed., 6:30-9:30 pm (no meetings Nov. 11 and Nov. 25); also
  Nov. 10: Tues., 6:30-9:30 pm
  
• San Francisco: Room 807, UC Berkeley Extension Downtown Center, 425 Market St., 8th Floor (enter on Fremont St.)
• $795 (EDP 321455)

Please note: Class on November 10 will meet in Room 808.

Quick Enroll	Search