CS 65 - Oracle Programming

    Recent Professors
    Not yet assigned
    Recent Semesters
    No scheduled sections on record
    Class Size
    Not published
    Credits
    3
    Transfers To
    CSU
    Description
    This course is a practical, hands-on overview of the Oracle Database Management System to store, retrieve, and manipulate data. Oracle is a widely used database that runs on PC’s, minicomputers, and mainframes, and Oracle programmers and developers are very much in demand. Oracle’s SQL is used to create and alter tables with various constraints. Data is retrieved and manipulated by using SELECTS that can group data and retrieve data from several tables by joining them or by using set operations. Views are created. PL/SQL, with its variables, symbolic constants, IF statements, and loops is used to program stored functions, stored procedures, and triggers. Cursors and error handling (exceptions) are introduced.