Relational Database Management

COM SCI X 414.51

Learn relational database technology, data modeling, SQL, the translation of logical designs to physical storage structures, database integrity, storage and client/server management, and introduction to query optimization.

View Course Options

What you can learn.

Explain what makes a good data model
Create entity relationship diagrams from raw data elements
Normalize entities to 1st, 2nd, and 3rd normal forms
Create database tables
Understand the three aspects of ANSI-Standard SQL (DML, DDL, and DCL)
Code basic SQL queries in a relational database management system (SQL Server)

About this course:

Understanding client-relational database design is vital to system design and implementation. Learn relational database technology, data modeling, SQL, data normalization and the translation of logical designs to physical storage structures. Additional topics include indexes, storage management, transactions, database integrity, concurrency control, recovery, client/server relational database management and introduction to query optimization.

Winter 2025 Schedule

January 6 - March 10

Monday 6:00PM - 9:30PM PT

Available

See Details

Instructor: Ricardo Patlan

400672

Fee:

$1,095.00

In Person

Location: UCLA

Updating...

See Details

Notes

Enrollment limited; early enrollment advised. Visitors not permitted.

Enrollment deadline: January 20th, 2025

Refund Deadline

No refunds after January 19, 2025

Course Requirements

Internet access required to retrieve course materials.

Data Modeling Essentials, Third Edition by Graeme Simsion

ISBN 978-0126445510

Schedule

Type

Date

Time

Location

Discussion

Mon Jan 6, 2025

6:00PM PT - 9:30PM PT