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

4.0

星

208 个评分

María del Pilar Ángeles

11,612 人已注册

提供方

数据库系统专项课程墨西哥国立自治大学

您将获得的技能

Business Intelligence
Data Warehousing
Database (DBMS)
NoSQL
Database (DB) Design
Entity
Relational Database
SQL
Expected Return
Sap Hana
Document Warehouse
Super Column

关于此专项课程

4,221 次近期查看

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.

应用的学习项目

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.

可分享的证书

完成后获得证书

100% 在线课程

立即开始，按照自己的计划学习。

灵活的计划

设置并保持灵活的截止日期。

中级

需要一些相关领域经验。需要一些相关经验。

完成课程大约需要 6 个月

建议进度：2 小时/周

英语（English）

字幕：英语（English）, 阿拉伯语（Arabic）, 法语（French）, （欧洲人讲的）葡萄牙语, 意大利语, 越南语, 德语（German）, 俄语（Russian）, 西班牙语（Spanish）

可分享的证书

完成后获得证书

100% 在线课程

立即开始，按照自己的计划学习。

灵活的计划

设置并保持灵活的截止日期。

中级

需要一些相关领域经验。需要一些相关经验。

完成课程大约需要 6 个月

建议进度：2 小时/周

英语（English）

专项课程的运作方式

加入课程

Coursera 专项课程是帮助您掌握一门技能的一系列课程。若要开始学习，请直接注册专项课程，或预览专项课程并选择您要首先开始学习的课程。当您订阅专项课程的部分课程时，您将自动订阅整个专项课程。您可以只完成一门课程，您可以随时暂停学习或结束订阅。访问您的学生面板，跟踪您的课程注册情况和进度。

实践项目

每个专项课程都包括实践项目。您需要成功完成这个（些）项目才能完成专项课程并获得证书。如果专项课程中包括单独的实践项目课程，则需要在开始之前完成其他所有课程。

获得证书

在结束每门课程并完成实践项目之后，您会获得一个证书，您可以向您的潜在雇主展示该证书并在您的职业社交网络中分享。

此专项课程包含 4 门课程

课程1

课程 1

Relational database systems

4.4

星

407 个评分

•

75 条评论

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

课程 2

Business intelligence and data warehousing

3.9

星

87 个评分

•

22 条评论

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

课程 3

NoSQL systems

4.3

星

148 个评分

•

30 条评论

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

课程 4

Designing data-intensive applications

4.5

星

34 个评分

•

3 条评论

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.

授课教师

María del Pilar Ángeles

Full time professor at the Department of Computer Engineering

Department of Computer Engineering

30,958 个学生

4 门课程

提供方

墨西哥国立自治大学

La Universidad Nacional Autónoma de México fue fundada el 21 de septiembre de 1551 con el nombre de la Real y Pontificia Universidad de México. Es la más grande e importante universidad de México e Iberoamérica. Tiene como propósito primordial estar al servicio del país y de la humanidad, formar profesionistas útiles a la sociedad, organizar y realizar investigaciones, principalmente acerca de las condiciones y problemas nacionales, y extender con la mayor amplitud posible, los beneficios de la cultura.

常见问题

退款政策是如何规定的？
如果订阅，您可以获得 7 天免费试听，在此期间，您可以取消课程，无需支付任何罚金。在此之后，我们不会退款，但您可以随时取消订阅。请阅读我们完整的退款政策。
我可以只注册一门课程吗？
可以！点击您感兴趣的课程卡开始注册即可。注册并完成课程后，您可以获得可共享的证书，或者您也可以旁听该课程免费查看课程资料。如果您订阅的课程是某专项课程的一部分，系统会自动为您订阅完整的专项课程。访问您的学生面板，跟踪您的进度。
有助学金吗？
是的，Coursera 可以为无法承担费用的学生提供助学金。通过点击左侧“注册”按钮下的“助学金”链接可以申请助学金。您可以根据屏幕提示完成申请，申请获批后会收到通知。您需要针对专项课程中的每一门课程完成上述步骤，包括毕业项目。了解更多。
我可以免费学习课程吗？
完成注册课程后，您可以学习专项课程中的所有课程，并且完成作业后可以获得证书。如果您只想阅读和查看课程内容，可以免费旁听该课程。如果您无法承担课程费用，可以申请助学金。
此课程是 100% 在线学习吗？是否需要现场参加课程？
此课程完全在线学习，无需到教室现场上课。您可以通过网络或移动设备随时随地访问课程视频、阅读材料和作业。
完成专项课程后我会获得大学学分吗？
此专项课程不提供大学学分，但部分大学可能会选择接受专项课程证书作为学分。查看您的合作院校了解详情。
完成专项课程需要多长时间？
22 weeks (5 and a half months)
Do I need to take the courses in a specific order?
Not necessarily. However, we highly recommend to take it in the specific order to ensure that the learner completes the objectives of the specialization.

还有其他问题吗？请访问学生帮助中心。

数据库系统专项课程