DataBase Management Systems: Lecture Notes & Supplements

by Patrick McDermott

This document contains Lecture Notes and supplements, primarily PowerPoint presentations, for the class X408 Concepts of Relational Database Systems at the University of California Berkeley Extension. They are designed as a resource for students who take the class. Enormous amounts of data reside in databases. Companies who can leverage data into useful information will gain a strategic edge over their competitors. 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 DBMSs. The course concentrates on helping students gain confidence in using DBMSs and understanding data structures. Study techniques for creating and using database applications in depth. You learn requirements analysis and specification; logical database design; normalization; database implementation; recovery, concurrency, integrity, and security concerns; and database use. The course curriculum focuses mainly on the relational database model and SQL.

232 pages, Paperback

Published March 20, 2011

About the author

Patrick McDermott is president of McDermott Computer Decisions, Inc., in Oakland, California. He received his B.A. in Economics from California State University at Sacramento. He has served as director of the Data Management Association (DAMA).