-
-
- Transfer Credit
- Online Learning
- Events
- Custom Programs
-
-
-
- Academic Services
- Course and Program Information
- Student Aid
-
-
-
Berkeley Global
Build on foundational database knowledge and explore more complex and specialized areas in database management for application development. Students will study relational and non-relational databases, including design and administration of architectures and con?gurations that support scalability, high-availability and security. Topics include complex SQL and optimization techniques, advanced data modeling and schema design, and optimization and performance techniques for SQL and NoSQL environments. Distributed databases and Big data systems are also explored, including data integration and ETL processes, as well as advanced transactions and consistency models. Emerging database technologies are also explored. This course is designed for students who want to advance their knowledge and expertise in databases in the context of software development.
Prerequisites: Students should understand concepts and topics covered in an introductory databases course including relational database design and overview of NoSQL databases, such as: COMPSCI X409.1 Introduction to Databases.
Learner Outcomes
Upon completion of this course, students will be able to:
- Perform data modeling to design, test, implement, secure and optimize SQL databases for use in web-software applications.
- Use essential SQL techniques to extract, transform and load data for use in web-software applications.
- Perform database administration tasks for performance and security considerations of simple to complex software systems.
- Design, implement and test distributed databases using large, unstructured data sets.
- Conduct data integration and ETL for advanced software systems.
- Implement and test advanced transactions and consistency models for large data sets.
- Understand emerging database technologies that support development of modern software systems.
Loading...
Sections
Fall 2024 enrollment opens on June 17!