Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Online Course

Data in Database

Arizona State University via Coursera

62
Found in Databases, Big Data
  • Provider Coursera
  • Cost Free Online Course (Audit)
  • Session Upcoming
  • Language English
  • Certificate Paid Certificate Available
  • Effort 11 hours a week
  • Duration 4 weeks long
  • Learn more about MOOCs

Taken this course? Share your experience with other students. Write review

Overview

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.

Syllabus

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.

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.

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.

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.

Taught by

Ming Zhao and Mohamed Sarwat

Help Center

Most commonly asked questions about Coursera

Reviews for Coursera's Data in Database Based on 0 reviews

  • 5 star 0%
  • 4 star 0%
  • 3 star 0%
  • 2 star 0%
  • 1 star 0%

Did you take this course? Share your experience with other students.

Write a review

Class Central

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free