CPT 166 01 - Fund of Structured Query Language

Help

Course Information

Fund of Structured Query Language (CPT 166)

Term: 2022-2023 Fall Semester

Schedule

Tue, 2:00 PM - 4:55 PM (8/29/2022 - 12/16/2022) Location: CMCC JAL 504

Description

CPT 166 Fundamentals of Structured Query Language
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 hands-on 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 la