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

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

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