CPT 166 - Fundamentals of Structured Query Language

Institution:

Central Maine Community College

Subject:

Description:

3 Credits (3 Lecture 0 Lab 0 Shop) 3 Hrs/Wk (3 Hrs. Lecture) *15 wks A broad based introduction course that will teach all the fundamentals of relational database access using structured query language (SQL). The course will cover the way to effectively retrieve and manipulate data in a database to meet an employer's or client's needs. The class will cover the basics of SQL, its strengths and weaknesses. It will focus on presenting implementation- independent SQL coding and use while highlighting several vendor specific implementations. The students will be required to become proficient in managing a small relational database under MS SQL Server, hosted on campus. Taking a handson approach, students will become skilled in designing and using SQL language to retrieve, organize, present, update and delete data. These competencies include a basic understanding of relational database, MS SQL Server and SQL. All learning will be in a lab environment where students will directly apply instructions using individual computers.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.cmcc.edu

Phone Number:

(207) 755-5100

Regional Accreditation:

New England Association of Schools and Colleges

Calendar System:

Semester

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.