About this Course
25,318 recent views

Course 1 of 5 in the

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Intermediate Level

Approx. 13 hours to complete

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

English

Subtitles: English
Learners taking this Course are
  • Technical Leads
  • Data Engineers
  • Data Scientists
  • Software Engineers
  • Machine Learning Engineers

Course 1 of 5 in the

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Intermediate Level

Approx. 13 hours to complete

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

English

Subtitles: English

Syllabus - What you will learn from this course

Week
1
2 hours to complete

Getting Started

4 videos (Total 21 min), 8 readings, 2 quizzes
4 videos
Introduction to Data and Data Processing6m
Database Management Systems5m
Data Models7m
8 readings
Important Course update2m
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
2 practice exercises
Knowledge Check: Introduction to Big Data and Data Processing Systems10m
Knowledge Check: Database Systems30m
Week
2
10 hours to complete

Basic Database Concepts

17 videos (Total 109 min), 7 readings, 4 quizzes
17 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
7 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
2 practice exercises
Knowledge Check 1: Relational Algebra30m
Knowledge Check 2: Relational Algebra30m
Week
3
2 hours to complete

Data Storage and Indexing

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

Transactions and Recovery

4 videos (Total 54 min), 4 readings, 3 quizzes
4 videos
Concurrency Control12m
Lock-Based Concurrency Control15m
Database Recovery14m
4 readings
Lesson Introduction: ACID Properties10m
Lesson Introduction: Transactions and Concurrency Control Concepts10m
Lesson Introduction: Lock-Based Concurrency Control10m
Database Recovery10m
3 practice exercises
Knowledge Check: ACID Properties30m
Knowledge Check: Transactions and Concurrency Control30m
Knowledge Check: Lock-Based Concurrency Control30m
4.1
33 ReviewsChevron Right

33%

got a tangible career benefit from this course

33%

got a pay increase or promotion

Top reviews from Core Database Concepts

By ABAug 23rd 2018

Great course to learn DB concepts. Lectures are well organized and assignments built up difficulty smoothly. At the end of course, student feels familiar with DB/ tables creation and queries.

By MSApr 5th 2019

The 2 main assignments are very challenging, you will learn a lot. You cannot complete this course without learning basic postgres. Big like, great application

Instructor

Avatar

Mohamed Sarwat

Assistant Professor
Computer Science and Engineering

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.