DATA 130 - Introduction to SQL

Credits: 5
Variable Credit Course: No

Lecture Hours: 55
Lab Hours: 0
Worksite/Clinical Hours: 0
Other Hours (LIA/Internships): 0

Course Description: Learn the foundational skills needed to effectively retrieve, manipulate, and analyze data using Structured Query Language (SQL), including working with relational models, cardinality, SQL statements, operators, and joins. Gain practical experience writing SQL queries to retrieve data from a relational database, join data from multiple tables, and aggregate data to answer analysis questions.

Prerequisite: None.
Meets FQE Requirement: No
Integrative Experience Requirement: No

Student Learning Outcomes

Explain the key characteristics and components of a relational database.
Construct SQL queries that retrieve data from a relational database using the SELECT, FROM, WHERE, GROUP BY, LIMIT, and HAVING clauses.
Construct SQL queries involving multiple tables using the appropriate join type(s).
Construct SQL queries to answer ad-hoc business analysis questions using simple aggregation functions.

Course Contents

Relational models.
Cardinality.
SQL statements.
SQL operators.
SQL joins.

Instructional Units: 5