DTSA 5735 Advanced Topics and Future Trends in Database Technologies

  • Specialization: Databases for Data Scientists
  • Instructor: Wu,Di; Paradise,Alan
  • Prior knowledge needed: None

  View on Coursera 

Learning Outcomes

  • In-depth and advanced areas of database technologies
  • The future of database software and where the industry is heading

Course Content

Duration: 6.25h

In this module we will take a deeper look into the internals of DBMS software to better understand how it works.  We will examine the role of the DBA (Database Administrator), the Data Scientist, the Data Architect,  and other career paths in the realm of database technologies.  This module covers DBMS essentials such as concurrency management, backup & recovery, and transaction logging. 

Duration: 3h

We have learned to design a Relational Database around the typical transactions or activities a business might have. However, in case we need to analyze data, rather than collect data, we need to create a database for the subject of interest to support decision making. In this module, we are going to learn a different perspective of organizing the data, Data Warehouse, or Online Analytical Processing.

Duration: 3h

We are in the era of data explosion. While relational databases are still widely used, we are having new problems to deal with data that is different than the one we have been organizing. This new type of data, with 10 V's in the definition, is called Big Data. We are going to explore the definitions, the challenges, and the architecture of the Big Data in this module.

Duration: 5h

Although relational database software has been in use for decades, relational database systems still command a huge share of the database software marketplace.  However, with the more recent explosion of Big Data, relational systems are struggling to keep up.  Big Data has opened the door for non-relational database solutions ("NoSQL") to capture marketshare from relational systems. In this module we will take a deeper look into the most popular NoSQL database technologies. 

Duration: 1.25h

You will complete a peer reviewed final project worth 30% of your grade. You must attempt the final in order to earn a grade in the course. If you've upgraded to the for-credit version of this course, please make sure you review the additional for-credit materials in the Introductory module and anywhere else they may be found.

Note: This page is periodically updated. Course information on the Coursera platform supersedes the information on this page. Click View on Coursera button above for the most up-to-date information.