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

4.1

星

218 個評分

María del Pilar Ángeles

12,773 人已註冊

提供方

数据库系统專項課程墨西哥国立自治大学

您將獲得的技能

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

關於此專項課程

3,577 次近期查看

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

星

420 個評分

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

星

91 個評分

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

星

153 個評分

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

星

35 個評分

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

34,198 個學生

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 天免费试听，在此期间，您可以取消课程，无需支付任何罚金。在此之后，我们不会退款，但您可以随时取消订阅。请阅读我们完整的退款政策。
我可以只注册一门课程吗？
可以！点击您感兴趣的课程卡开始注册即可。注册并完成课程后，您可以获得可共享的证书，或者您也可以旁听该课程免费查看课程资料。如果您订阅的课程是某专项课程的一部分，系统会自动为您订阅完整的专项课程。访问您的学生面板，跟踪您的进度。
有助学金吗？
是的。如果您负担不起学习计划的注册费，则可以在选择学习计划时申请助学金或奖学金。如果您选择的学习计划提供助学金或奖学金，则您将在描述页面上看到一个申请链接。
我可以免费学习课程吗？
完成注册课程后，您可以学习专项课程中的所有课程，并且完成作业后可以获得证书。如果您只想阅读和查看课程内容，可以免费旁听该课程。如果您无法承担课程费用，可以申请助学金。
此课程是 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.

還有其他問題嗎？請訪問學生幫助中心。

数据库系统專項課程