Jul 19, 2024  
2023-2024 Catalog 
    
2023-2024 Catalog Archived

CPT 202 - SQL Programming I


Lecture Hours: 3 Credits: 3

Description: This course is an introduction to the writing of basic Structured Query Language (SQL) used in creating tables, inserting data, retrieving data, and manipulating data from database.

Prerequisite(s): Take CPT 242  with a minimum grade of C.
Course Topics:
  • Learning how to work with SQL-Server
  • Building a Database and Creating Tables
  • Writing simple and advanced queries
  • Creating Advanced Queries and Enhancing Table Design

Textbooks:
Textbook information can be found on the Book Inn website
Required Materials:
  • USB Flash Drive (min. capacity 8 Gb.)
  • Skills Assessment Manager Office 2013 (SAM 2013) - Assessment, Projects, and Training Microsoft
  • Office 2013 and Microsoft Office 2013 Professional Edition (Word, Excel, Access, PowerPoint.

Grading System:
An overall grade of C or higher is required for transferability.

A = 90 - 100
B = 80 - 89
C = 70 - 79
D = 60 - 69
F =   0 - 59


Student Learning Outcomes:
  1. Illustrate components of SQL-Server.
  2. Design and create databases and tables using queries.
  3. Write SQL Statements.
  4. Create simple and complex SELECT statements.
  5. Use AGGREGATE functions in a query.
  6. Design and create reports.
  7. Create Stored Procedures and Triggers.

For SCC Online Courses:
If the course you are taking is online, please review the SCC Online Course Policies  that include:

  • Identity Verification
  • Required materials for all online courses
  • Mandatory Attendance Requirement
  • Orientation and Support
  • Proctored Exams

Standard SCC Course Policies:
Please review the Standard Course Policies  on the following topics:

  • Academic Integrity
  • Add/Drop period
  • Attendance
  • Classroom Conduct
  • Equal Access
  • IT Access
  • Online Behavior
  • Online Confidentiality
  • Services For Students with Disabilities
  • Student Concerns
  • Student Help Services
  • Withdrawals


SCC Logo
Official Course Syllabus
2023-2024