May 05, 2024  
2018 - 2020 CNM Catalog, Volume 50 
    
2018 - 2020 CNM Catalog, Volume 50 [The CNM Academic Year includes Fall, Spring, Summer Terms]

CIS 2520 - Introduction to SQL (Structured Query Language)

3 credit hour(s)
Prerequisite: IT 1010 
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.

Note(s):
  • This course also prepares students for the 1st Oracle Associate Certification Test.
  • 45 theory hours
  • 15 lab hours
  • Course taught in a computer lab