Course

Relational Database Design and SQL Programming


Most business and technical data consists of multiple tables with interlocking relationships. Such databases must provide reliable storage, transaction management, access security and multi-user support. In this course, you will learn the concepts and design for a Relational Database Management System (RDBMS) and focus on the Structured Query Language (SQL) to define and manipulate data.

The course covers how to create conceptual, logical and physical designs of relational databases in response to a set of user requirements. Instructions will be provided through the use of several case studies. You will learn design methodology, entity-relationship diagrams (ERD) and normalization principles. You will use an Oracle database to design the ERD and implement a working database. SQL is the query language used to access, maintain and share data with the relational database. You will learn methods for producing readable output, creating and manipulating tables and creating and managing constraints using SQL.

The concepts and SQL language learned here apply to all major RDBMS. You will gain understanding of the relational DB and have hands-on experience in creating database and working with data. The instructor recommends MySQL as an example database.

Topics Include:

  • Relational database concepts
  • Entity-relationship model
  • Normalization
  • SQL basics
  • SQL functions and operators
  • Restriction and formatting
  • Sorting and aggregating data
  • Transaction management and stored procedures
  • Combining queries with set operators
  • Managing tables and database performance

Skills Needed: Familiarity with general database concepts and ability to install software or databases on a personal computer.

Sections Open for Enrollment:

Open Sections and Schedule
Start / End Date Units Location Cost Instructor
11-12-2019 to 02-11-2020 3.0 ONLINE $910

Michelle C Rosenaur

Enroll

Schedule

Date: Start Time: End Time: Meeting Type: Location:
Tue, 11-12-2019 11:58 p.m. 11:59 p.m. Online ONLINE
Tue, 02-11-2020 11:58 p.m. 11:59 p.m. Online ONLINE
Open Sections and Schedule
Start / End Date Units Location Cost Instructor
01-06-2020 to 03-23-2020 3.0 CLASSROOM $910

Raghav Vinjamuri

Enroll

Schedule

Date: Start Time: End Time: Meeting Type: Location:
Mon, 01-06-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 01-13-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 01-27-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 02-03-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 02-10-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 02-24-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 03-02-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 03-09-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 03-16-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 03-23-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Open Sections and Schedule
Start / End Date Units Location Cost Instructor
01-07-2020 to 04-07-2020 3.0 ONLINE $910

Michelle C Rosenaur

Enroll

Schedule

Date: Start Time: End Time: Meeting Type: Location:
Tue, 01-07-2020 11:58 p.m. 11:59 p.m. Online ONLINE
Tue, 04-07-2020 11:58 p.m. 11:59 p.m. Online ONLINE
Open Sections and Schedule
Start / End Date Units Location Cost Instructor
03-10-2020 to 06-09-2020 3.0 ONLINE $910

Michelle C Rosenaur

Enroll

Schedule

Date: Start Time: End Time: Meeting Type: Location:
Tue, 03-10-2020 11:58 p.m. 11:59 p.m. Online ONLINE
Tue, 06-09-2020 11:58 p.m. 11:59 p.m. Online ONLINE
Open Sections and Schedule
Start / End Date Units Location Cost Instructor
04-06-2020 to 06-15-2020 3.0 CLASSROOM $910

Raghav Vinjamuri

Enroll

Schedule

Date: Start Time: End Time: Meeting Type: Location:
Mon, 04-06-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 04-13-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 04-20-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 04-27-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 05-04-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 05-11-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 05-18-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 06-01-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 06-08-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA
Mon, 06-15-2020 6:30 p.m. 9:30 p.m. Lab with Online Materials SANTA CLARA

Course Inquiry

Ask us any questions you may have about this course.

Contact Us
Speak to a student services representative.

Call (408) 861-3860

Envelope extension@ucsc.edu