Catalog 2016-2017 
    
    Mar 29, 2024  
Catalog 2016-2017 [ARCHIVED CATALOG]

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