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
READ MORE ABOUT THIS COURSE
Fall
Winter
Spring
Summer
In Person
Live Online
Starting at $1,095.00
As few as 10 weeks
4.0
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.

Spring 2025 Schedule

Date & Time
Details
Format
 
-
Monday 6:00PM - 9:30PM PT
Available
See Details
Instructor: Scott Howard
402574
Fee:
$1,095.00
In Personformat icon
Location: UCLA
Updating...
See Details
Notes

Enrollment limited; early enrollment advised. Visitors not permitted.

Enrollment deadline: April 6th, 2025

Refund Deadline
No refunds after April 13, 2025
Course Requirements
Internet access required to retrieve course materials.
Data Modeling Essentials, Third Edition by Graeme Simsion
©2004 Morgan Kaufmann
ISBN 978-0126445510
Schedule
Type
Date
Time
Location
Discussion
Mon Mar 31, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Discussion
Mon Apr 7, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Discussion
Mon Apr 14, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Discussion
Mon Apr 21, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Discussion
Mon Apr 28, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Discussion
Mon May 5, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Discussion
Mon May 12, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Discussion
Mon May 19, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Discussion
Mon May 26, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Discussion
Mon Jun 2, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
-
Tuesday 6:00PM - 9:30PM PT
Available
See Details
Instructor: Scott Howard
402575
Fee:
$1,095.00
Live Onlineformat icon
Location: Remote Classroom
Updating...
See Details
Notes

Enrollment limited; early enrollment advised. Enrollment deadline: April 6th, 2025

Refund Deadline
No refunds after April 14, 2025
Course Requirements
Data Modeling Essentials by Graeme Simsion
©2004 Morgan Kaufmann
ISBN 0126445516
Internet access required to retrieve course materials.
Schedule
Type
Date
Time
Location
Lecture
Tue Apr 1, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Apr 8, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Apr 15, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Apr 22, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Apr 29, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue May 6, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue May 13, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue May 20, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue May 27, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Jun 3, 2025
6:00PM PT - 9:30PM PT
Remote Classroom

Summer 2025 Schedule

Date & Time
Details
Format
 
-
Monday 6:00PM - 9:30PM PT
Future Offering (Opens April 28, 2025 12:00:00 AM)
See Details
Instructor: Scott Howard
403638
Fee:
$1,095.00
In Personformat icon
Location: UCLA
Updating...
See Details
Notes

Enrollment limited; early enrollment advised. Enrollment deadline: June 29th, 2025

Refund Deadline
No refunds after July 06, 2025
Course Requirements
Data Modeling Essentials by Graeme Simsion
©2004 Morgan Kaufmann
ISBN 0126445516
Internet access required to retrieve course materials.
Schedule
Type
Date
Time
Location
Lecture
Mon Jun 23, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Lecture
Mon Jun 30, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Lecture
Mon Jul 7, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Lecture
Mon Jul 14, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Lecture
Mon Jul 21, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Lecture
Mon Jul 28, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Lecture
Mon Aug 4, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Lecture
Mon Aug 11, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Lecture
Mon Aug 18, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
Lecture
Mon Aug 25, 2025
6:00PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2748
-
Tuesday 6:00PM - 9:30PM PT
Future Offering (Opens April 28, 2025 12:00:00 AM)
See Details
Instructor: Scott Howard
403637
Fee:
$1,095.00
Live Onlineformat icon
Location: Remote Classroom
Updating...
See Details
Notes

Enrollment limited; early enrollment advised. Enrollment deadline: June 29th, 2025

Refund Deadline
No refunds after July 07, 2025
Course Requirements
Data Modeling Essentials by Graeme Simsion
©2004 Morgan Kaufmann
ISBN 0126445516
Internet access required to retrieve course materials.
Schedule
Type
Date
Time
Location
Lecture
Tue Jun 24, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Jul 1, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Jul 8, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Jul 15, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Jul 22, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Jul 29, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Aug 5, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Aug 12, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Aug 19, 2025
6:00PM PT - 9:30PM PT
Remote Classroom
Lecture
Tue Aug 26, 2025
6:00PM PT - 9:30PM PT
Remote Classroom

Contact Us

Our team members are here to help. Hours: Mon-Fri, 8am-5pm.
phone-icon 310-206-6794
phone-icon dt@uclaextension.edu

This course applies towards the following certificates & specializations…

Database Management
database-management-ce0097
Systems Analysis
systems-analysis-ce0042
Ready to start
your future?
Keep up to date on the latest news and offerings in Data Analytics & Management
By signing up, you agree to UCLA Extension’s Privacy Policy.

vector icon of building

Corporate Education

Learn how we can help your organization meet its professional development goals and corporate training needs.

Learn More

vector icon of building

Donate to UCLA Extension

Support our many efforts to reach communities in need.

Innovation Programs

Student Scholarships

Lifelong Learning

See More