|
|
|
May 04, 2024
|
|
CS 119 - Introduction to Database Data Processing
3.0 Credits
An introduction to retrieving data from a database with a query language and processing it with a spreadsheet program. Topics include designing queries that sort, filter and aggregate data and using spreadsheets to clean, calculate, summarize and chartdata.
Prerequisite Admission into the Data Analytics Certificate (Beginner/Early Career) program or permission from the instructor.
Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:
- Recognize and be able to describe how a database stores information via tables.
- Compose database queries to retrieve data stored in multiple tables/collections from a database.
- Compose and troubleshoot database queries that join, sort, filter and aggregate data across multiple tables/collections.
- Construct formulas in spreadsheet softwares, including the use of built-in functions, and relative and absolute references (e.g. VLookUp, Find)
- Developand modify charts.
- Explore datasets and apply consolidation andde-duplication strategies.
- Use pivot tables to calculate, summarize and analyze data.
Course Typically Offered
FALL
Add to Personal Catalog (opens a new window)
|
|
|
