A comprehensive look at the wide landscape of database systems and how to make a good choice in your next projectThe first time we ask or answer any question regarding databases is when building an application. The next is either when our choice of database becomes a bottleneck or when we need to do large-scale data analytics. This course covers almost all classes of databases or data storage platform there are and when to consider using them. It is a great journey through databases that will be great for software developers, big data engineers, data analysts as well as decision makers. It is not an in-depth look into each of the databases but promises to get you up and running with your first project for each class. In this course, we are going to coverRelational Database Systems, their features, use cases and limitationsWhy NoSQL?CAP TheoremKey-Value store and their use casesDocument-oriented databases and their use casesWide-columnar store and their use casesTime-series databases and their use casesSearch Engines and their use casesGraph databases and their use casesDistributed Logs and real time streaming systemsHadoop and its use casesSQL-on-Hadoop tools and their use casesHow to make informed decisions in building a good data storage platformWhat is the target audience?Chief data officersApplication developerData analystData architectsData engineersStudentsAnyone who wants to understand Hadoop from a database perspective. What this course does not cover?This course does not access any of the databases from the administrative perspective. So we don’t cover administrative tasks like security, backup, recovery, migration and the likes. Very in-depth features in the specific databases in discussion. An example is that we will not go into the different database engines for MySQL or how to write a stored procedures. What are the requirements?The lab for this course can be carried out in any machine (Microsoft Windows, Linux, Mac OX).However, the training on HBase or Hadoop will require you to have a hadoop environment. The suggestion for this will be to to use a pre-installed sandbox, a cloud offering or install your own custom sandbox. What do I need to know to get the best out of this course?This course does not assume any knowledge of NoSQL or data engineering. However a little knowledge of RDBMS (even Microsoft Access) is enough to get you into the best position for this course.
