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 110 or CSD 111

Course Outcomes
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

Program Outcomes
This course teaches to the following program outcomes:

be prepared to obtain an entry-level position in software development
analyze software related problems and design solutions utilizing appropriate software tools
apply data management concepts and use query languages

Global Outcomes
This course teaches to the global outcome of information literacy.

Total Hours: 60 Theory (Lecture) Hours: 40 Guided Practice (Lab or Clinical) Hours: 20