| |
May 13, 2024
|
|
|
|
|
2023-2024 College Catalog [ARCHIVED CATALOG]
|
CIS 105 - Introduction to SQL 3 Credits, 4 Contact Hours
2 lecture periods 2 lab periods
An introduction to relational databases and Structured Query Language (SQL). Includes Entity-Relationship (ER modeling), sql basics, data types, queries, mathematical and statistical functions, multi-table joins, importing and exporting data, grouping and summarizing, referential integrity and constraints.
Recommendation: Basic computer skills including installing programs, navigating the computer file system, and downloading files from the internet.
Course Learning Outcomes
- Understand the design and structure of relational databases
- Develop SQL statements using mathematical and statistical functions
- Develop SQL statements that create and update database objects
- Demonstrate queries that use SQL joins
Outline:
- Introduction to SQL
- Databases
- Tables
- Data types
- Retrieving data
- Grouping and summarizing data
- Importing and exporting data
- Using math and statistical functions
- Adding, subtracting and multiplying
- Division and modulus operations
- Exponents and roots
- Percentages
- Averages, median and sum
- Table joins
- Types of JOINs
- Table relationships
- Set operators
- Designing tables
- Unique, Null and Foreign key constraints
- Indexes
- Updating and modifying table data
Effective Term:
Fall 2023
|
|