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
Remote Instruction
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.

Winter 2021 Schedule

Available Format(s):

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

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

Enrollment limited. Enrollment deadline: January 12, 2021. Internet access required. Materials required.

Refund Deadline
No refunds after January 10, 2021
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 February 01, 2021 12:00:00 AM)
-
This section has no set meeting times.
377304
Fee:
$995.00
See Details
Notes

Enrollment limited. Enrollment deadline: April 6, 2021. Internet access required. Materials required.

Refund Deadline
No refunds after March 24, 2021
Course Requirements
Data Modeling Essentials by Graeme Simsion
Internet access required to retrieve course materials.

These courses have regular meeting times and are fully online, via remote instruction. Click “See Details” below for more information.

Future Offering (Opens February 01, 2021 12:00:00 AM)
-
Tuesday 6:30PM PT - 9:30PM PT
Location: Online
377305
Fee:
$995.00
See Details
Notes

Enrollment limited. Enrollment deadline: April 6, 2021. Internet access required. Materials required.

Refund Deadline
No refunds after April 12, 2021
Course Requirements
Internet access required to retrieve course materials.
Data Modeling Essentials
Schedule
Type
Date
Time
Location
Online
Tue Mar 30, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Apr 6, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Apr 13, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Apr 20, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Apr 27, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue May 4, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue May 11, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue May 18, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue May 25, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Jun 1, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Jun 8, 2021
6:30PM PT - 9:30PM PT
Online

Available Format(s):

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

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

Enrollment limited. Enrollment deadline: June 29, 2021. Internet access required. Materials required.

Refund Deadline
No refunds after May 02, 2021
Course Requirements
Data Modeling Essentials by Graeme Simsion
Internet access required to retrieve course materials.

These courses have regular meeting times and are fully online, via remote instruction. Click “See Details” below for more information.

Future Offering (Opens April 26, 2021 12:00:00 AM)
-
Tuesday 6:30PM PT - 9:30PM PT
Location: Online
378874
Fee:
$995.00
See Details
Notes

Enrollment limited. Enrollment deadline: June 28, 2021. Internet access required. Materials required.

Refund Deadline
No refunds after July 05, 2021
Course Requirements
Internet access required to retrieve course materials.
Data Modeling Essentials, Third Edition by Graeme Simsion
Schedule
Type
Date
Time
Location
Online
Tue Jun 22, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Jun 29, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Jul 6, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Jul 13, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Jul 20, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Jul 27, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Aug 3, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Aug 10, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Aug 17, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Aug 24, 2021
6:30PM PT - 9:30PM PT
Online
Online
Tue Aug 31, 2021
6:30PM PT - 9:30PM PT
Online

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