Montgomery College 2019-2020 Catalog 
    Dec 07, 2019  
Montgomery College 2019-2020 Catalog
[Add to Favorites]

CMSC 246 - Introduction to SQL Using Oracle

Covers the concept, design, architecture, and components of the Oracle database system and SQL (Standard Query Language). Topics include the database design, the data definition language, the data manipulation language, the data control language, the basics of SQL*PLUS, and the standard SQL. Students create database tables, implement business requirements utilizing constraints, and develop complex queries using features such as join, union, and subqueries. Assessment Level(s): ENGL 101 /ENGL 101A , MATH 050  , READ 120 . Three hours each week. Formerly CS 270.

3 semester hours

May not be taken concurrently withMATH 017  or MATH 020  or MATH 045  without appropriate Math assessment score.

Course Outcomes:
Upon course completion, a student will be able to:

  • Apply commands within Oracle SQL*PLUS.
  • Apply Data Definition, Data Control, and Data Definition Language to create and manipulate database tables, database records, and database functioning.
  • Describe the basic architecture and components of the Oracle system.
  • Describe the major tasks and steps of the database design.
  • Develop queries and SQL scripts using basic record retrieval commands.
  • Execute and test SQL and PL/SQL statements.
  • Use transaction control commands to control database transactions.

Click here for the Fall 2019 Class Schedule

Click here for the Extended Winter 2020 Class Schedule

Click here for the Winter 2020 Class Schedule

Click here for the Spring 2020 Class Schedule

[Add to Favorites]