數據庫中的數據

Data in Database

Big Data analytics tools are increasingly critical for providing meaningful information for making better business decisions.

亞利桑那州立大學

Coursera

計算機

普通(中級)

13 個月

本課程由Coursera和Linkshare共同提供
  • 英語
  • 313

課程概況

Big Data analytics tools are increasingly critical for providing meaningful information for making better business decisions.

Big data technologies bring significant cost advantages when it comes to storing and managing large amounts of data. Understanding how to query a database to extract data will empower better analysis of large, complex datasets. Knowledge of Indexing mechanisms makes possible high-speed, selective retrieval of large amounts of information.

你將學到什么

Evaluate data models and data processing concepts

Apply relationship algebra to entity relationship models

Compare major indexing schemes in Database Systems

Analyze transaction properties and concurrency control concepts

課程大綱

周1
Big Data and Data Processing
Database management systems are critical to businesses and organizations. They provide an efficient method for handling different types of data in the era of big data. A university database, for example, stores millions of student and course records. The relational database management system ensures that the university can define entity relationships and logically maintain its data over time.

周2
Entity Relationship Model to Relational Model
We live in an era where data is the critical factor in decision-making. To provide that critical factor, we must be able to extract data from database management systems. This week, you will learn how Entity Relationship (ER) models visually show the various entities (tables) and the relationships between them. You are also provided with an introduction to SQL, the standard language for relational database management systems.

周3
Relational Model and Relational Algebra
Databases use relational algebra operators to execute SQL queries; this week, you will learn about relational algebra as the mathematical query language for relations.

周4
Data Storage and Indexing
In the first part of this week, you will learn how indexes are important for looking up information (Imagine searching for your order in Amazon without an index!) and optimizing query performance. As the week continues, we discuss transaction locks and database recovery. Transaction locks are critical to data consistency. All organizations think about recovery mechanisms for databases, and have some in place in the event of a crash. We close out this week with a discussion on database recovery.

Self-Driving Cars. Become an autonomous vehicle engineer.
聲明: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-2019 MOOC.CN 慕課改變你,你改變世界

3d独胆公式规律