课程信息
33,050 次近期查看

第 1 门课程(共 5 门)

100% 在线

立即开始,按照自己的计划学习。

可灵活调整截止日期

根据您的日程表重置截止日期。

中级

完成时间大约为12 小时

建议:Approximately 2-5 hours per week...

英语(English)

字幕:英语(English)

第 1 门课程(共 5 门)

100% 在线

立即开始,按照自己的计划学习。

可灵活调整截止日期

根据您的日程表重置截止日期。

中级

完成时间大约为12 小时

建议:Approximately 2-5 hours per week...

英语(English)

字幕:英语(English)

教学大纲 - 您将从这门课程中学到什么

1
完成时间为 2 小时

Getting Started

...
4 个视频 (总计 21 分钟), 7 个阅读材料, 2 个测验
4 个视频
Introduction to Data and Data Processing6分钟
Database Management Systems5分钟
Data Models7分钟
7 个阅读材料
Best Practices for Online Learning10分钟
What will I be able to do when I complete this course?10分钟
Technology Tools10分钟
Learning Journey Syllabus10分钟
Lesson Introduction: Big Data and Data Processing10分钟
Database Management10分钟
Data Models10分钟
2 个练习
Knowledge Check: Introduction to Big Data and Data Processing Systems10分钟
Knowledge Check: Database Systems30分钟
2
完成时间为 10 小时

Basic Database Concepts

...
17 个视频 (总计 109 分钟), 7 个阅读材料, 4 个测验
17 个视频
Database Design: ER to Relational Model22分钟
Assignment Directions: Create a Movie Database3分钟
Assignment: Create Movie Recommendation Database6分钟
Relational Data Model3分钟
Relational Algebra: Query Language3分钟
Relational Algebra: Query Language: Union1分钟
Relational Algebra: Query Language: Difference2分钟
Relational Algebra: Query Language: Cartesian Product3分钟
Relational Algebra: Query Language: Selection2分钟
Relational Algebra: Query Language: Projection2分钟
Relational Algebra: Query Language: Intersection1分钟
Relational Algebra: Query Language: θ-Join4分钟
Part 1: SQL Query Language9分钟
Part 2: SQL Query Language10分钟
Assignment Directions: SQL Query for Movie Recomendation5分钟
Assignment Solution: SQL Query for Movie Recommendation4分钟
7 个阅读材料
Introduction to Entity Relational Model10分钟
ER to Relational Model10分钟
Next Steps: Application of Skills in the Assignment10分钟
Lesson Introduction: Relational Models and Relational Algebra10分钟
Relational Algebra: Query Language10分钟
Lesson Introduction: SQL Query Language10分钟
Part 2: SQL Language10分钟
2 个练习
Knowledge Check 1: Relational Algebra30分钟
Knowledge Check 2: Relational Algebra30分钟
3
完成时间为 2 小时

Data Storage and Indexing

...
4 个视频 (总计 39 分钟), 4 个阅读材料, 2 个测验
4 个视频
Alternative File Organization11分钟
Hash-based Indexes4分钟
Index Classification15分钟
4 个阅读材料
Lesson Introduction: Major Data Storage Layouts10分钟
Alternative File Organization10分钟
Lesson Introduction: Major Indexing Schemes in Database Systems10分钟
Index Classification10分钟
2 个练习
Knowledge Check: Data Storage30分钟
Knowledge Check: Major Indexing Schemes30分钟
4
完成时间为 3 小时

Transactions and Recovery

...
4 个视频 (总计 54 分钟), 4 个阅读材料, 3 个测验
4 个视频
Concurrency Control12分钟
Lock-Based Concurrency Control15分钟
Database Recovery14分钟
4 个阅读材料
Lesson Introduction: ACID Properties10分钟
Lesson Introduction: Transactions and Concurrency Control Concepts10分钟
Lesson Introduction: Lock-Based Concurrency Control10分钟
Database Recovery10分钟
3 个练习
Knowledge Check: ACID Properties30分钟
Knowledge Check: Transactions and Concurrency Control30分钟
Knowledge Check: Lock-Based Concurrency Control30分钟
4.0
26 个审阅Chevron Right

33%

通过此课程获得实实在在的工作福利

33%

加薪或升职

来自Core Database Concepts的热门评论

创建者 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.

创建者 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

讲师

Avatar

Mohamed Sarwat

Assistant Professor
Computer Science and Engineering

立即开始攻读硕士学位

此 课程 隶属于 亚利桑那州立大学 提供的 100% 在线 Master of Computer Science。如果您被录取参加全部课程,您的课程将计入您的学位学习进程。

关于 亚利桑那州立大学

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

关于 Data Systems 专项课程

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

常见问题

  • 注册以便获得证书后,您将有权访问所有视频、测验和编程作业(如果适用)。只有在您的班次开课之后,才可以提交和审阅同学互评作业。如果您选择在不购买的情况下浏览课程,可能无法访问某些作业。

  • 您注册课程后,将有权访问专项课程中的所有课程,并且会在完成课程后获得证书。您的电子课程证书将添加到您的成就页中,您可以通过该页打印您的课程证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容,可以免费旁听课程。

还有其他问题吗?请访问 学生帮助中心