Dec 22, 2024  
2020 - 2021 CNM Catalog, Volume 52 
    
2020 - 2021 CNM Catalog, Volume 52 [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