Advanced Databases (saylor.org)

Advanced Databases (saylor.org)
Free Course
Categories
Effort
Certification
Languages
Have access to a relational database management system. Have completed Introduction to Computer Science I and II, C++ Programming, Elementary Data Structures, Discrete Structures, Computer Architecture, Single-Variable Calculus I and II.
Misc

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Advanced Databases (saylor.org)
This course will expand about SQL and introduce various other advanced topics, including query optimization, concurrency, data warehouses, object-oriented extensions, and XML.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

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.



3
Average: 3 ( 1 vote )

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Free Course
Have access to a relational database management system. Have completed Introduction to Computer Science I and II, C++ Programming, Elementary Data Structures, Discrete Structures, Computer Architecture, Single-Variable Calculus I and II.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.