CIS 2520 - Introduction to SQL (Structured Query Language)
3credit hour(s)(Prerequisites: CIS 1513 or department approval)
Introduction to Structured Query Language (SQL) within the context of an Oracle database. Students will create basic and complex queries (joining, sub-queries, aggregate functions, grouping data), and learn to manipulate data using insert, update and delete statements. Students will create tables, views, constraints, indexes and sequences and benefit by learning the industry standards while utilizing the latest database software and online training materials. This course also prepares students for the 1st Oracle Associate Certification Test. Note(s) 30 theory + 45 lab hours