Offered By

Part of the Master of Computer Science degree

Learn More

Data in Database

Arizona State University

About this Course

4,943 recent views

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. Please note that enrollments for this course will close on January 31, 2021. If you are seeking certification, please be aware that you must pay the course fee by January 31, 2021.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Intermediate Level

Approx. 10 hours to complete

English

Subtitles: French, Portuguese (European), Russian, English, Spanish

What you will learn

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

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Intermediate Level

Approx. 10 hours to complete

English

Subtitles: French, Portuguese (European), Russian, English, Spanish

Instructors

Instructor rating

4.42/5 (7 Ratings)

Ming Zhao

Associate Professor

ASU School of Computing, Informatics, and Decision Systems Engineering.

5,673 Learners

2 Courses

Mohamed Sarwat

Assistant Professor

Computer Science and Engineering

13,727 Learners

6 Courses

Offered by

Arizona State University

Arizona State University has developed a new model for the American Research University, creating an institution that is committed to excellence, access and impact. ASU measures itself by those it includes, not by those it excludes. ASU pursues research that contributes to the public good, and ASU assumes major responsibility for the economic, social and cultural vitality of the communities that surround it.

Start working towards your Master's degree

This course is part of the 100% online Master of Computer Science from Arizona State University. If you are admitted to the full program, your courses count towards your degree learning.

Learn More

Syllabus - What you will learn from this course

Week

Week 1

1 hour to complete

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.

1 hour to complete

3 videos (Total 20 min), 3 readings, 1 quiz

3 videos

Introduction to Data and Data Processing6m

Database Management Systems5m

Data Models7m

3 readings

Best Practices for Online Learning5m

Technology Tools10m

PostgresSQL Resources2m

1 practice exercise

Knowledge Check: Database Systems4m

Week

Week 2

4 hours to complete

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.

4 hours to complete

4 videos (Total 43 min), 1 reading, 1 quiz

4 videos

Entity Relationship Model (ER)12m

Class Hierarchies and Aggregation within ER Models8m

Creating Relations in SQL14m

ER to Relational Model8m

1 reading

Practice SQL Exercises2m

Week

Week 3

4 hours to complete

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 hours to complete

11 videos (Total 45 min)

11 videos

Relational Data Model3m

Relational Algebra: Query Language3m

Relational Algebra: Query Language: Union1m

Relational Algebra: Query Language: Difference2m

Relational Algebra: Query Language: Cartesian Product3m

Relational Algebra: Query Language: Selection2m

Relational Algebra: Query Language: Projection2m

Relational Algebra: Query Language: Intersection1m

Relational Algebra: Query Language: θ-Join4m

SQL Query Language: Part 19m

SQL Query Language: Part 210m

3 practice exercises

Knowledge Check: Introduction to Data and Data Processing4m

Knowledge Check 1: Relational Algebra6m

Knowledge Check 2: Relational Algebra8m

Week

Week 4

2 hours to complete

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.

2 hours to complete

7 videos (Total 80 min)

7 videos

Introduction to Data Storage7m

Alternative File Organization11m

Hash-Based Indexes4m

Index Classification15m

Principles of Transactions: ACID Properties11m

Lock-Based Concurrency Control15m

Database Recovery14m

3 practice exercises

Knowledge Check: ACID Properties8m

Knowledge Check: Transactions and Concurrency Control6m

Knowledge Check: Lock-Based Concurrency Control6m

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I purchase the Certificate?
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You’ll be prompted to complete an application and will be notified if you are approved. Learn more.
Will I earn university credit for completing the Course?
This Course doesn't carry university credit, but some universities may choose to accept Course Certificates for credit. Check with your institution to learn more. Online Degrees and Mastertrack™ Certificates on Coursera provide the opportunity to earn university credit.

More questions? Visit the Learner Help Center.

Data in Database

Data in Database