数据库系统

你将学到什么

课程概况

This specialized program is aimed at computer people who want
to enter the field of information systems and learn their different types of
requirements, architectures, performance, techniques and tools so you can know
when to use business intelligence, data mining, data science, databases ,
databases in memory or big data in order to have reliable, maintainable and
scalable data intensive systems. Through 4 courses, you will cover [transactional relational databases, business intelligence and Data warehousing, NoSQL technologies, and reliable, scalable and maintainable data intensive applications that will prepare you for a specialized information system consultant or data scientist.

包含课程

课程1
Relational database systems

Welcome to the specialization course Relational Database Systems. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how several types of information systems and databases are available to solve different problems and needs of the companies.

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).

课程2
Business intelligence and data warehousing

Welcome to the specialization course Business Intelligence and Data Warehousing. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how to identify, design and develop analytical information systems, such as Business Intelligence with a descriptive analysis on data warehouses. You will be able to understand the problem of integration and predictive analysis of high volume of unstructured data (big data) with data mining and the Hadoop framework.

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).

课程3
NoSQL systems

Welcome to the specialization course of NoSQL Systems. 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).

课程4
Designing data-intensive applications

Welcome to the specialization course of Designing data-intensive applications.

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.

课程项目

Course 1, project a Book Store.

For this project, you will design, implement and query a transactional database system for a Book Store. The database system will contain books, authors, stores, and sales detail.

Course 2, project On-Line Analytical Processing of a Book Store

For this project, you will design and implement an analytical database. You will be able to program and execute OLAP queries to the data-warehouse

Course 3: NoSQL Systems

Project: Analysis of book sales on a NoSQL database

For this project you will design, implement and query a NoSQL Database system for a Book Store using MongoDB

Course 4: Recommendation system

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