Database Design and Management with PL/SQL (Oracle) 6662

Suggested Grade Levels: 10 or 11 or 12 (36 weeks)

Prerequisite:  Database Design and Management (Oracle) (6660/36 weeks)

Web-based technologies used throughout industry, including interactive Web sites, accounting programs, research tools, search engines, e-learning environments, e-mail managers, and numerous other applications, depend upon relational databases. PL/SQL, an extension of the SQL programming language, provides additional database functionality through variables, constants, conditional statements, and iterative controls. Students enhance their relational database design and management skills by learning to write PL/SQL code that includes anonymous blocks, sub programs, built-in functions, control structures, procedures, and triggers, all within a browser-based programming environment. In addition, fully functional Web-based applications are created through the use of HTML DB. The cooperative education method is available for this course. Students combine classroom instruction and supervised on-the-job training in an approved position with continuing supervision throughout the year.
Recommended prerequisite(s): Advanced Database Design and Management (Oracle) 6661