CIS 261 SQL Programming I (5 credits)
Prerequisite CIS 122 or CIS 260 either with a grade of 2.0 or better; or instructor permission.
Course Description The first of a two-course series on Structured Query Language (SQL). This class introduces SQL, the scripting language used for storing, retrieving, displaying, and updating data in a database, and a preview of SQL for data analytics, data preparation and aggregation.
Course Content A. Structured Query Language (SQL) Basics
B. Queries
C. SQL for Analytics
D. Data Preparation and Aggregation
E. Data Manipulation Language (DML)
F. Data Control Language (DCL)
G. Data Definition Language (DDL)
Student Outcomes 1. Describe Structured Query Language (SQL)
2. Create and analyze schemas for relational databases
3. Create, read, update and delete data using SQL queries
4. Create and query database views
5. Create, use and analyze Data Manipulation Language (DML), Data Definition Language (DDL) and Data Control Language (DCL)
6. Use SQL for Analytics for data preparation
7. Use Aggregate Functions for cleaning data
Degree Outcomes Information Literacy: Graduates will be critical users, creators, and disseminators of information by examining how information is created, valued, and influenced by power and privilege.
Critical, Creative, and Reflective Thinking: Graduates will evaluate, analyze, synthesize, and generate ideas; construct informed, meaningful, and justifiable conclusions; and process feelings, beliefs, biases, strengths, and weaknesses as they relate to their thinking, decisions, and creations.
Program Outcome: Collect, analyze, integrate and query data from disparate sources.
Lecture Contact Hours 50 Lab Contact Hours 0 Clinical Contact Hours 0 Total Contact Hours 50
Potential Methods A. Student Demonstration
B. Individual and Group Projects
C. Practice Exercises
D. Instructor Observation
E. Peer Review
Add to Portfolio (opens a new window)
|