Relational Databases with SQL

Overview

Subject area

CS

Catalog Number

103

Course Title

Relational Databases with SQL

Description

Principles of relational databases; data manipulation using SQL queries, as would apply to data science and related mathematical concepts: selection, insertion and deletion, aggregates, joins, views, integrity constraints, triggers; table management; database design. Emphasis is on the writing of SQL queries and PL/SQL scripts in a scalable, cross-platform, and client-server database systems (such as MySQL, PostgreSQL, or Oracle) with an understanding of the mathematical underpinnings.

Typically Offered

Fall, Spring

Academic Career

Undergraduate

Liberal Arts

No

Credits

Minimum Units

4

Maximum Units

4

Academic Progress Units

4

Repeat For Credit

No

Components

Name

Laboratory

Hours

2

Name

Lecture

Hours

3

Requisites

034798

Course Schedule