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

Summer 2023 Schedule

Date & Time
Details
Format
 
-
This section has no set meeting times.
Available
See Details
Instructor: Ronald Landers
392326
Fee:
$1,095.00
Onlineformat icon
Updating...
ENROLL BY: Jun 26, 2023
See Details
Notes

Enrollment limited. Enrollment deadline: July 2, 2023. Internet access required. Materials required.

Refund Deadline
No refunds after June 30, 2023
Course Requirements
Data Modeling Essentials by Graeme Simsion
©2004 Morgan Kaufmann
ISBN 0126445516
Internet access required to retrieve course materials.
-
Monday 6:30PM - 9:30PM PT
Available
See Details
Instructor: Richard Patlan
392312
Fee:
$1,095.00
In-Personformat icon
Location: UCLA
Updating...
ENROLL BY: Jun 26, 2023
See Details
Notes

Enrollment limited. Enrollment deadline: July 4th, 2023. Internet access required. Materials required.

Refund Deadline
No refunds after July 09, 2023
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 Jun 26, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Jul 3, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Jul 10, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Jul 17, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Jul 24, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Jul 31, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Aug 7, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Aug 14, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Aug 21, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Aug 28, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434

Fall 2023 Schedule

Date & Time
Details
Format
 
-
This section has no set meeting times.
Future Offering (Opens July 31, 2023 12:00:00 AM)
See Details
Instructor: Ronald Landers
393944
Fee:
$1,095.00
Onlineformat icon
Updating...
See Details
Notes

Enrollment limited. Enrollment deadline: October 8, 2023. Internet access required. Materials required.

Refund Deadline
No refunds after October 06, 2023
Course Requirements
Data Modeling Essentials by Graeme Simsion
©2004 Morgan Kaufmann
ISBN 0126445516
Internet access required to retrieve course materials.
-
Monday 6:30PM - 9:30PM PT
Future Offering (Opens July 31, 2023 12:00:00 AM)
See Details
Instructor: Richard Patlan
393942
Fee:
$1,095.00
In-Personformat icon
Location: UCLA
Updating...
See Details
Notes

Enrollment limited. Enrollment deadline: October 8, 2023. Internet access required. Materials required.

Refund Deadline
No refunds after October 15, 2023
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 Oct 2, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Oct 9, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Oct 16, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Oct 23, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Oct 30, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Nov 6, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Nov 13, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Nov 20, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Nov 27, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Dec 4, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434
Discussion
Mon Dec 11, 2023
6:30PM PT - 9:30PM PT
UCLA
Physics & Astronomy Bldg. 2434

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…

Systems Analysis
systems-analysis-ce0042
Applications Programming
applications-programming-ce0045
Database Management
database-management-ce0097
Ready to start
your future?
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

Coding Boot Camp

Lifelong Learning