About this Course

10,422 recent views
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

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

Offered by

Placeholder

Arizona State University

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.

Syllabus - What you will learn from this course

Week
1

Week 1

1 hour to complete

Big Data and Data Processing

1 hour to complete
3 videos (Total 20 min), 3 readings, 1 quiz
3 videos
Database Management Systems5m
Data Models7m
3 readings
Best Practices for Online Learning5m
Technology Tools10m
PostgresSQL Resources2m
1 practice exercise
Knowledge Check: Database Systems4m
Week
2

Week 2

4 hours to complete

Entity Relationship Model to Relational Model

4 hours to complete
4 videos (Total 43 min), 1 reading, 1 quiz
4 videos
Class Hierarchies and Aggregation within ER Models8m
Creating Relations in SQL14m
ER to Relational Model8m
1 reading
Practice SQL Exercises2m
Week
3

Week 3

4 hours to complete

Relational Model and Relational Algebra

4 hours to complete
11 videos (Total 45 min)
11 videos
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
4

Week 4

2 hours to complete

Data Storage and Indexing

2 hours to complete
7 videos (Total 80 min)
7 videos
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

Reviews

TOP REVIEWS FROM DATA IN DATABASE

View all reviews

Frequently Asked Questions

More questions? Visit the Learner Help Center.