Advanced Database Applications
Y52.3525
Credit:
Management and Information Technology
This intensive, lab-based course focuses on database language. It covers hands-on development in SQL and PL/SQL, as well as Java and XML. The course covers the important features of Oracle, an Internet-oriented, object-relational database. It introduces new Oracle features, and covers PL/SQL program tracing and tuning. SQL*Plus, Oracle?s character-based interface, is introduced and used. Students will learn to create and maintain databases; store, retrieve, and manipulate data; write stored procedures, functions and triggers; create PL/SQL procedures, functions and packages utilizing PL/SQL libraries; manipulate XML contents; write and call Java programs from and within the database; and publish HTML pages using PL/SQL This course is for application developers and system integrators with knowledge of basic relational concepts. The course is heavily lab-based, with approximately 50% allocated to hands-on exercises. Students practice to design, develop, and implement a relational Oracle database and use the database for transaction processing, report generation, and queries. A term assignment is implemented step-wise as part of regular assignments. Upon completion of this course students should be adept at writing SQL and PL/SQL codes for diverse applications in the relational database environment.
To register for this course you must be an admitted student in an NYU credit or degree program or have special student status. Admitted NYU credit or degree students may visit NYUHome to register through ALBERT. To apply to an NYU-SCPS credit or degree program, call (212) 998-7100.
