Big Data analytics tools are increasingly critical for providing meaningful information for making better business decisions.
Offered By
Data in Database
Arizona State University
About this Course
9,019 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
Subtitles: 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
Subtitles: English
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.
Syllabus - What you will learn from this course
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 readings
Best Practices for Online Learning5m
Technology Tools10m
PostgresSQL Resources2m
1 practice exercise
Knowledge Check: Database Systems4m
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
Class Hierarchies and Aggregation within ER Models8m
Creating Relations in SQL14m
ER to Relational Model8m
1 reading
Practice SQL Exercises2m
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 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
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
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
3.7
TOP REVIEWS FROM DATA IN DATABASE
by ARApr 2, 2020
Great course. One start subtracted because many of the assignment materials were not covered at all in the course. Lots of time googling what might be meant in the exercises.
Frequently Asked Questions
When will I have access to the lectures and assignments?
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.
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.
What is the refund policy?
Is financial aid available?
More questions? Visit the Learner Help Center.