May 25, 2018
CSD 138 Structured Query Language (SQL)
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
This course teaches to the global outcome of Information Literacy.
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