Catalog 2017-2018 
    Apr 21, 2021  
Catalog 2017-2018 [ARCHIVED CATALOG]

CSD 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: CSD 111  

Students who completed ITAD 111 meet the prerequisite.

Quarters Offered: Fall, Winter

Global Outcomes:
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

Total Hours: 60 Lecture Hours: 40 Lab or Clinical Hours: 20