ITAD 138 Structured Query Language (SQL)

5 credits

Students will learn how to use Structured Query Language (SQL) to retrieve information from a relational database, filter, modify, group and summarize data, and retrieve joint information from multiple tables in a database.

Prerequisites: ITAD 111.

Quarters Offered: Fall, Winter, Spring

Global Outcome(s)
This course teaches to the global outcome of Information Literacy.

Student Outcomes/Competencies:
Upon successful completion of this course students will be able to:

Demonstrate understanding of the purpose, design, and terminology of a relational database
Explain and use relational schema
Use a relational database management system to enter, edit, and run SQL statements
Access multiple tables and work with unions, subqueries, self joins, inner joins, and outer joins
Use aggregation functions
Build SQL queries to retrieve, store, and modify data
Create and edit tables and enforce data integrity on them
Evaluate and synthesize information in a database
Gather and organize information needed for database creation and maintenance