COSC 2050 Intro to Structured Query Language (SQL)

This course offers the student an introduction to database technology and data analysis using the leading database technology, Structured Query Language (SQL). (3 lect.)

Credits

3 credits

Transfer Status

Transferable to UW

Major Topics

• Components of relational databases
• Operations between client applications and database servers
• SQL command structuring
• Join operations and types
• Modifying dataset via insert, update, and delete operations
• Application of databases
• Report generation

Outcomes

In order to successfully complete this course, the student will:

1. Define relational database terms.

2. Describe the architecture of a typical client-server database system.

3. Retrieve data from a relational table using appropriate SQL options.

4. Retrieve data from two or more relational tables using appropriate SQL options for joining data.

5. Use SQL commands and functions appropriately to aggregate and analyze data.

6. Modify the data in a database using SQL commands, e.g., insert, update, and delete.

7. Use multiple large data sets to answer practical, real-world questions about the data.

8. Import a large dataset related to a topic of their choosing.

9. Create a variety of reports on their dataset.