Nov 07, 2024  
2023-2024 Catalog 
    
2023-2024 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.

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)