Sponsors

Follow Us

Upcoming events

Menu
Log in

TECHNICAL COURSES
NCC 229: STRUCTURED QUERY LANGUAGE

COURSE NUMBER

NCC 229

CREDIT / UNIT HOURS

3

PRE-REQUISITES

NCC 225: Introduction to Relational Databases

RECOMMENDED TEXT BOOK

TBD

ISBN

TBD

COURSE LAB

TBD


DESCRIPTION

3 credit/unit hours – Three hours of lecture weekly; one term

This course covers programming in the Structured Query Language. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create blocks of application code that can be shared by multiple forms, reports, and data management applications. Students also learn how to write and apply triggers, procedures, and packages. Demonstrations and hands-on practice reinforce the fundamental concepts.

LEARNING OBJECTIVES

Upon completion of this course the student will be able to:

    • Use SQL commands to create, maintain, and query a relational database;
    • Write SQL scripts that create, maintain, and query relational databases;
    • Develop, maintain, and use triggers, procedures, and packages within a relational database; and
    • Demonstrate appropriate and ethical behavior and good work habits

    MAIN TOPICS

    1.0 Query commands
    2.0 Joining multiple tables
    3.0 Single row and group functions
    4.0 Subqueries
    5.0 Creating and managing tables
    6.0 Constraints
    7.0 Data manipulation
    8.0 Views
    9.0 Other objects: sequences, indexes, and synonyms
    10.0 Creating and managing users
    11.0 Formatting output
    12.0 PL/SQL blocks
    13.0 Procedures
    14.0 Functions packages
    15.0 Triggers
    16.0 Performance tuning




    © 2025 Cyber Ready Professional Consortium  PRIVACY POLICY / TERMS OF USE

    Powered by Wild Apricot Membership Software