About this Course
3.9
59 ratings
17 reviews
Specialization

Course 1 of 5 in the

100% online

100% online

Start instantly and learn at your own schedule.
Flexible deadlines

Flexible deadlines

Reset deadlines in accordance to your schedule.
Intermediate Level

Intermediate Level

Hours to complete

Approx. 13 hours to complete

Suggested: Approximately 2-5 hours per week...
Available languages

English

Subtitles: English
Specialization

Course 1 of 5 in the

100% online

100% online

Start instantly and learn at your own schedule.
Flexible deadlines

Flexible deadlines

Reset deadlines in accordance to your schedule.
Intermediate Level

Intermediate Level

Hours to complete

Approx. 13 hours to complete

Suggested: Approximately 2-5 hours per week...
Available languages

English

Subtitles: English

Syllabus - What you will learn from this course

Week
1
Hours to complete
2 hours to complete

Getting Started

...
Reading
4 videos (Total 21 min), 7 readings, 2 quizzes
Video4 videos
Introduction to Data and Data Processing6m
Database Management Systems5m
Data Models7m
Reading7 readings
Best Practices for Online Learning10m
What will I be able to do when I complete this course?10m
Technology Tools10m
Learning Journey Syllabus10m
Lesson Introduction: Big Data and Data Processing10m
Database Management10m
Data Models10m
Quiz2 practice exercises
Knowledge Check: Introduction to Big Data and Data Processing Systems10m
Knowledge Check: Database Systems30m
Week
2
Hours to complete
10 hours to complete

Basic Database Concepts

...
Reading
17 videos (Total 109 min), 7 readings, 4 quizzes
Video17 videos
Database Design: ER to Relational Model22m
Assignment Directions: Create a Movie Database3m
Assignment: Create Movie Recommendation Database6m
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
Part 1: SQL Query Language9m
Part 2: SQL Query Language10m
Assignment Directions: SQL Query for Movie Recomendation5m
Assignment Solution: SQL Query for Movie Recommendation4m
Reading7 readings
Introduction to Entity Relational Model10m
ER to Relational Model10m
Next Steps: Application of Skills in the Assignment10m
Lesson Introduction: Relational Models and Relational Algebra10m
Relational Algebra: Query Language10m
Lesson Introduction: SQL Query Language10m
Part 2: SQL Language10m
Quiz2 practice exercises
Knowledge Check 1: Relational Algebra30m
Knowledge Check 2: Relational Algebra30m
Week
3
Hours to complete
2 hours to complete

Data Storage and Indexing

...
Reading
4 videos (Total 39 min), 4 readings, 2 quizzes
Video4 videos
Alternative File Organization11m
Hash-based Indexes4m
Index Classification15m
Reading4 readings
Lesson Introduction: Major Data Storage Layouts10m
Alternative File Organization10m
Lesson Introduction: Major Indexing Schemes in Database Systems10m
Index Classification10m
Quiz2 practice exercises
Knowledge Check: Data Storage30m
Knowledge Check: Major Indexing Schemes30m
Week
4
Hours to complete
3 hours to complete

Transactions and Recovery

...
Reading
4 videos (Total 54 min), 4 readings, 3 quizzes
Video4 videos
Concurrency Control12m
Lock-Based Concurrency Control15m
Database Recovery14m
Reading4 readings
Lesson Introduction: ACID Properties10m
Lesson Introduction: Transactions and Concurrency Control Concepts10m
Lesson Introduction: Lock-Based Concurrency Control10m
Database Recovery10m
Quiz3 practice exercises
Knowledge Check: ACID Properties30m
Knowledge Check: Transactions and Concurrency Control30m
Knowledge Check: Lock-Based Concurrency Control30m
3.9
17 ReviewsChevron Right
Career Benefit

33%

got a tangible career benefit from this course
Career promotion

33%

got a pay increase or promotion

Top Reviews

By JDJun 24th 2018

Good introduction to databases. Got a deeper understanding of storage and retrieval, indexing,... Enjoyed the postgres assignments.

By GMNov 12th 2018

I want to say specially about Professor of this course is best fit personality for core data.I love her.

Instructor

Avatar

Mohamed Sarwat

Assistant Professor
Computer Science and Engineering
Graduation Cap

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.

About 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....

About the Data Systems Specialization

Database systems are used to provide convenient access to disk-resident data through efficient query processing, indexing structures, concurrency control, and recovery. This specialization delves into new frameworks for processing and generating large-scale datasets with parallel and distributed algorithms. Courses cover the design, deployment and use of state-of-the-art data processing systems, which provide scalable access to data. All courses in this Specialization form the lecture and skill practice component of a corresponding course in ASU’s online Master of Computer Science Degree. You can apply to the degree program either before or after you begin the Specialization....
Data Systems

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. 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.

More questions? Visit the Learner Help Center.