This course will expand about SQL and introduce various other advanced topics, including query optimization, concurrency, data warehouses, object-oriented extensions, and XML.
While CS403: Introduction to Modern Database Systems covered many of the core concepts behind database management systems, there are many other considerations that should be addressed if you intend to pursue a career in this field. This course will expand upon what you learned about SQL in CS403 and introduce various other advanced topics, including query optimization, concurrency, data warehouses, object-oriented extensions, and XML. While CS403 introduced the basics of database management systems, the additional topics covered in this course will help you become more proficient in writing queries and will expand your knowledge base so that you have a better understanding of the field. By the end of this course, you should have a solid grasp on data warehouses and XML, which will prove to be invaluable as you progress further in your Computer Science studies.
Upon successful completion of this course, the student will be able to:
Write complex queries, including full outer joins, self-joins, sub queries, and set theoretic queries.
Write stored procedures and triggers.
Apply the principles of query optimization to a database schema.
Explain the various types of locking mechanisms utilized within database management systems.
Explain the different types of database failures as well as the methods used to recover from these failures.
Design queries against a distributed database management system.
Perform queries against database designed with object-relational extensions.
Develop and query XML files.
