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
1. Databases
2. Tables
3. Data types
Retrieving data
1. Grouping and summarizing data
Importing and exporting data
Using math and statistical functions
1. Adding, subtracting and multiplying
2. Division and modulus operations
3. Exponents and roots
4. Percentages
5. Averages, median and sum
Table joins
1. Types of JOINs
2. Table relationships
3. Set operators
Designing tables
1. Unique, Null and Foreign key constraints
2. Indexes
Updating and modifying table data

Effective Term:
Fall 2023