COMI-263 Structured Query Language (SQL)

Credits 4 / 4 Contact Hours
Placement into RDNG-016 (ACSR-016) Prerequisite: COMS-170 and one of the following: COMS-171 or COMS-175 or COMS 176.
Relational databases are the backbone of organizations and this is where their critical data are stored for their information processing needs. Learning SQL gives students the skills they need to create retrieve or update information from any relational database (Oracle IBM DB2 Sybase Ingress and MS SQL Server). In this course students will learn relational database concepts writing basic SQL statements restricting and sorting data displaying data from multiple tables aggregating data using group functions sub queries creating and managing tables creating views and security.

Course Outcomes
1. Describe relational and object relational database concepts 2. Retrieve, insert, update and delete data 3. Create and maintain database objects 4. Control transactions 5. Control data/user access 6. Use the Oracle9i single row functions 7. Use the Oracle9i extensions to DML and DDL statements 8. Use all the resources of SQL to write solid scripts 9. Analyze the behavior of SQL scripts that are written by others, identify problems, and suggest appropriate correction