May 07, 2024  
2022-2023 CNM Catalog, Volume 54 
    
2022-2023 CNM Catalog, Volume 54 [The CNM Academic Year includes Fall, Spring, Summer Terms]

CIS 2520 - Introduction to SQL (Structured Query Language)

3 credit hour(s)
Prerequisite: BCIS 1110 
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