CIS 2520 - Introduction to SQL (Structured Query Language)

Institution:

Central New Mexico Community College

Subject:

Description:

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.

Credits:

3.00

Credit Hours:

Prerequisites:

BCIS 1110 or CSCI 1108

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture/Lab

Notes:

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

Additional Information:

Historical Version(s):

Institution Website:

www.cnm.edu

Phone Number:

(505) 224-3000

Regional Accreditation:

North Central Association of Colleges and Schools

Calendar System:

Trimester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.