Feb 25, 2024  
2021-2022 Catalog 
2021-2022 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

SDEV 201 - SQL for Data Analytics

Credits: 5
Structured Query Language (SQL) is used to extract and analyze data stored in databases. Hands-on experience with extracting data and organizing it into meaningful information in realistic scenarios.

Enrollment Requirement: CS 108  or CS 109  or CS /ENGR 120  with grades of 2.0 or higher; or instructor consent.

Course Outcomes:

Students who successfully complete this class will be able to:

  1. Explain the structure of tables and the function of keys in a relational database.
  2. Use diagrams to show how tables in a relational database relate to one another.
  3. Interpret business information requests to produce accurate SQL statements.
  4. Construct SQL queries to retrieve data from one or more tables in a database.
  5. Produce SQL queries using logical operators, expressions, and filters.

Program Outcomes
  1. Extract data from a database using a relational database language.
  2. Perform basic data analysis techniques such as filtering, aggregation, and joins.
  3. Understand and demonstrate basic programming and database constructs.

College-wide Outcomes
  • Quantitative and Symbolic Reasoning - Quantitative Reasoning encompasses abilities necessary for a student to become literate in today’s technological world. Quantitative reasoning begins with basic skills and extends to problem solving.

Add to Portfolio (opens a new window)