数据库系统

Database systems

Start your career on Data Science!. Apply strategies and tools to develop any kind of information system

8106 次查看
墨西哥国立自治大学
Coursera
  • 完成时间大约为 4 个月
  • 中级
  • 英语
注:本课程由Coursera和Linkshare共同提供,因开课平台的各种因素变化,以上开课日期仅供参考

你将学到什么

Business Intelligence

Data Warehousing

Database (DBMS)

NoSQL

Expected Return

Sap Hana

课程概况

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.

千万首歌曲。全无广告干扰。
此外,您还能在所有设备上欣赏您的整个音乐资料库。免费畅听 3 个月,之后每月只需 ¥10.00。
Apple 广告
声明:MOOC中国十分重视知识产权问题,我们发布之课程均源自下列机构,版权均归其所有,本站仅作报道收录并尊重其著作权益。感谢他们对MOOC事业做出的贡献!
  • Coursera
  • edX
  • OpenLearning
  • FutureLearn
  • iversity
  • Udacity
  • NovoEd
  • Canvas
  • Open2Study
  • Google
  • ewant
  • FUN
  • IOC-Athlete-MOOC
  • World-Science-U
  • Codecademy
  • CourseSites
  • opencourseworld
  • ShareCourse
  • gacco
  • MiriadaX
  • JANUX
  • openhpi
  • Stanford-Open-Edx
  • 网易云课堂
  • 中国大学MOOC
  • 学堂在线
  • 顶你学堂
  • 华文慕课
  • 好大学在线CnMooc
  • (部分课程由Coursera、Udemy、Linkshare共同提供)

© 2008-2020 MOOC.CN 慕课改变你,你改变世界