The Storing and Retrieving of Data course unit covers an introduction to SQL and NO SQL Databases, ETL operations, and Data Warehousing. Students will learn the advantages and disadvantages of each database system in order to be able to decide which type of database is the best for their needs. Students will learn the differences of developing databases for Transaction Oriented (OLTP) or Analytical (OLAP) operations. Finally, the course will cover the main concepts and definitions of Data Warehousing, understand the different types of Data Warehousing architecture, the basics of Data Warehousing operations, the administration, and management of Data Warehousing.

Bibliography

• Viescas, John L. Sql queries for mere mortals: a hands-on guide to data manipulation in sql. Pearson Education India, 2018
• Sullivan, Dan. NoSQL for mere mortals. Addison-Wesley Professional, 2015
• Chodorow, Kristina. MongoDB: The Definitive Guide: Powerful and Scalable Data Storage 2nd Edition. “O’Reilly Media, Inc.”, 2014
• Vaisman, Alejandro, and Esteban Zimányi. Data warehouse systems. Data-Centric Systems and Applications (2014)