Skills you'll gain

Specialization - 4 course series

For this project you will design a recommendation system for book reading and sales stored in a distributed parallel database.

Objective: A learner will be able to design, test, and implement analytical, transactional or NoSQL database systems according to business requirements by programming reliable, scalable and maintainable applications and resources using SQL and Hadoop ecosystem. Programming languages: For course 1 you will use the MYSQL language. Software to download: MySQL Workbench In case you have a Mac / IOS operating system you will need to use a virtual Machine (VirtualBox, Vmware).

After completing this course, a learner will be able to ● Create a Star o Snowflake data model Diagram through the Multidimensional Design from analytical business requirements and OLTP system ● Create a physical database system ● Extract, Transform and load data to a data-warehouse. ● Program analytical queries with SQL using MySQL ● Predictive analysis with RapidMiner ● Load relational or unstructured data to Hortonworks HDFS ● Execute Map-Reduce jobs to query data on HDFS for analytical purposes Programming languages: For course 2 you will use the MYSQL language. Software to download: Rapidminer MYSQL Excel Hortonworks Hadoop framework In case you have a Mac / IOS operating system you will need to use a virtual Machine (VirtualBox, Vmware).

This course will be completed on six weeks, it will be supported with videos and exercises that will allow you to identify the differences between the relational and NoSQL databases. As part of these alternative technologies the student will learn the main characteristics and how to implement the typical NoSQL databases, such as Key-value, columnar, document and graph. Let's start! After completing this course, a learner will be able to ● Identify what type of NoSQL database to implement based on business requirements (key-value, document, full text, graph, etc.) ● Apply NoSQL data modeling from application specific queries ● Use Atomic Aggregates and denormalization as data modelling techniques to optimize query processing Software to download: MongoDB Neo4j SAPIQ Cassandra In case you have a Mac / IOS operating system you will need to use a virtual Machine (VirtualBox, Vmware).

This course will be completed on four weeks, it will be supported with videos and exercises. By the end of this specialization, learners will be able to propose, design, justify and develop high reliable information systems according to type of data and volume of information, response time, type of processing and queries in order to support scalability, maintainability, security and reliability considering the last information technologies. Software to download: MySQL Workbench Rapidminer Hadoop framework Hortonworks MongoDB In case you have a Mac / IOS operating system you need to perform an action called VirtualBox.

Business intelligence and data warehousing

NoSQL systems

Designing data-intensive applications