This course is a study and application of the American National Standards Institute (ANSI) Standard Structured Query Language (SQL) constructs for an advanced level of data definition (create, alter, drop), data manipulation (insert, update, delete), and transaction control (commit, savepoint, and rollback). The course builds on the techniques learned in the introductory course for database design and implementation. It explores the database life cycle through conceptual, logical, and physical design phases. The course examines the correlation between SQL and relational algebra; user access and control; transactional integrity; referential integrity; concurrency control; and database objects such as views, complex views, SQL functions, and sequences. Advanced topics discussed in the course include: database performance tuning, query optimization, distributed database systems, business intelligence, data analytics, data warehousing, cloud computing services, and the administration of database systems. Students must have access to Oracle software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. (Prerequisite: INFO171 or equivalent)
American Public University System, 111 W. Congress Street, Charles Town, WV 25414 | Toll Free: 877-755-2787
American Public University System (APUS) is accredited by the Higher Learning Commission (HLC) and is a wholly owned subsidiary of American Public Education, Inc. (APEI). Pursuant to a contractual arrangement, APEI provides certain services for the benefit of APUS, subject to APUS oversight and ultimate authority. Pursuant to a license, APEI may use APUS’s trademarks and other intellectual property in its performance of those services. American Public University System, American Public University, and American Military University are not affiliated with American University or the U.S. Military.