Introduction to Relational Database Design and SQL
Course Transferable to CSU
Hours: 54 hours LEC
This course is designed to introduce relational database technology, normalization, entity relationships, logical model design, and ISO-ANSI standard Structured Query Language (SQL). Topics covered include: database design, basic properties of a relational database such as relations, tables, primary keys, foreign keys and principles of normalization, simple SQL select statements, sorting and grouping data, joining tables, subqueries and views. The course covers core concepts in identifying data and information management requirements for organizations, data modeling, and normalization techniques. The database design section focuses on logical model design and entity relationship (ER) modeling. The course exposes students to the use of Relational Database Management Systems using an industrial-strength database management system. Students will leave the course with a good working knowledge of database technology.