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.

READ MORE ABOUT THIS COURSE
Online
Classroom
Starting at $995.00
As few as 10 weeks
4.0
3.6

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 2020 Schedule

Available Format(s):

These courses are fully online and have no regular meeting times.

Enrollment Closed
-
This section has no set meeting times.
373234
Fee:
$995.00
See Details
Notes

Enrollment limited. Enrollment deadline: April 7, 2020. Internet access required. Materials required.

Refund Deadline
No refunds after April 05, 2020
Course Requirements
Data Modeling Essentials by Graeme Simsion
Internet access required to retrieve course materials.

Available Format(s):

These courses are fully online and have no regular meeting times.

Future Offering (Opens April 27, 2020 12:00:00 AM)
-
This section has no set meeting times.
374753
Fee:
$995.00
See Details
Notes

Enrollment limited. Enrollment deadline: June 30, 2020. Internet access required. Materials required.

Refund Deadline
No refunds after June 28, 2020
Course Requirements
Data Modeling Essentials by Graeme Simsion
Internet access required to retrieve course materials.

These courses meet in person and make use of an online presence to varying degrees.

Future Offering (Opens April 27, 2020 12:00:00 AM)
-
Wednesday 6:30PM PDT - 9:30PM PDT
Location: UCLA Extension Lindbrook Center in Westwood
374754
Fee:
$995.00
See Details
Notes

Enrollment limited. Enrollment deadline: June 30, 2020. Internet access required. Materials required.

Refund Deadline
No refunds after July 07, 2020
Course Requirements
Internet access required to retrieve course materials.
Data Modeling Essentials, Third Edition by Graeme Simsion
Schedule
Type
Date
Time
Location
Computer Lab
Wed Jun 24, 2020
6:30PM PDT - 9:30PM PDT
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Jul 1, 2020
6:30PM PDT - 9:30PM PDT
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Jul 8, 2020
6:30PM PDT - 9:30PM PDT
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Jul 15, 2020
6:30PM PDT - 9:30PM PDT
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Jul 22, 2020
6:30PM PDT - 9:30PM PDT
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Jul 29, 2020
6:30PM PDT - 9:30PM PDT
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Aug 5, 2020
6:30PM PDT - 9:30PM PDT
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Aug 12, 2020
6:30PM PDT - 9:30PM PDT
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Aug 19, 2020
6:30PM PDT - 9:30PM PDT
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Aug 26, 2020
6:30PM PDT - 9:30PM PDT
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203

Available Format(s):

These courses are fully online and have no regular meeting times.

Future Offering (Opens August 03, 2020 12:00:00 AM)
-
This section has no set meeting times.
374897
Fee:
$995.00
See Details
Notes

Enrollment limited. Enrollment deadline: October 6, 2020. Internet access required. Materials required.

Refund Deadline
No refunds after October 04, 2020
Course Requirements
Data Modeling Essentials by Graeme Simsion
Internet access required to retrieve course materials.

These courses meet in person and make use of an online presence to varying degrees.

Future Offering (Opens August 03, 2020 12:00:00 AM)
-
Wednesday 6:30PM PDT - 9:30PM PST
Location: UCLA Extension Lindbrook Center in Westwood
374899
Fee:
$995.00
See Details
Notes

Enrollment limited. Enrollment deadline: October 6, 2020. Internet access required. Materials required.

Refund Deadline
No refunds after October 13, 2020
Course Requirements
Internet access required to retrieve course materials.
Data Modeling Essentials, Third Edition by Graeme Simsion
Schedule
Type
Date
Time
Location
Computer Lab
Wed Sep 30, 2020
6:30PM PDT - 9:30PM PST
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Oct 7, 2020
6:30PM PDT - 9:30PM PST
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Oct 14, 2020
6:30PM PDT - 9:30PM PST
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Oct 21, 2020
6:30PM PDT - 9:30PM PST
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Oct 28, 2020
6:30PM PDT - 9:30PM PST
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Nov 4, 2020
6:30PM PDT - 9:30PM PST
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Nov 11, 2020
6:30PM PDT - 9:30PM PST
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Nov 18, 2020
6:30PM PDT - 9:30PM PST
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Nov 25, 2020
6:30PM PDT - 9:30PM PST
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Dec 2, 2020
6:30PM PDT - 9:30PM PST
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203
Computer Lab
Wed Dec 9, 2020
6:30PM PDT - 9:30PM PST
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 203

Contact Us

Our team members are here to help. Hours: Mon-Fri, 8am-5pm.

This course applies towards the following certificates & specializations…

Keep up to date on the latest news and offerings in Data Analytics & Management

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

Coding Boot Camp

Lifelong Learning