Acerca de este Curso
33,749 vistas recientes

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Nivel intermedio

Aprox. 12 horas para completar

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

Inglés (English)

Subtítulos: Inglés (English)

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Nivel intermedio

Aprox. 12 horas para completar

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

Inglés (English)

Subtítulos: Inglés (English)

Programa - Qué aprenderás en este curso

Semana
1
2 horas para completar

Getting Started

...
4 videos (Total 21 minutos), 7 readings, 2 quizzes
4 videos
Introduction to Data and Data Processing6m
Database Management Systems5m
Data Models7m
7 lecturas
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 ejercicios de práctica
Knowledge Check: Introduction to Big Data and Data Processing Systems10m
Knowledge Check: Database Systems30m
Semana
2
10 horas para completar

Basic Database Concepts

...
17 videos (Total 109 minutos), 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 lecturas
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 ejercicios de práctica
Knowledge Check 1: Relational Algebra30m
Knowledge Check 2: Relational Algebra30m
Semana
3
2 horas para completar

Data Storage and Indexing

...
4 videos (Total 39 minutos), 4 readings, 2 quizzes
4 videos
Alternative File Organization11m
Hash-based Indexes4m
Index Classification15m
4 lecturas
Lesson Introduction: Major Data Storage Layouts10m
Alternative File Organization10m
Lesson Introduction: Major Indexing Schemes in Database Systems10m
Index Classification10m
2 ejercicios de práctica
Knowledge Check: Data Storage30m
Knowledge Check: Major Indexing Schemes30m
Semana
4
3 horas para completar

Transactions and Recovery

...
4 videos (Total 54 minutos), 4 readings, 3 quizzes
4 videos
Concurrency Control12m
Lock-Based Concurrency Control15m
Database Recovery14m
4 lecturas
Lesson Introduction: ACID Properties10m
Lesson Introduction: Transactions and Concurrency Control Concepts10m
Lesson Introduction: Lock-Based Concurrency Control10m
Database Recovery10m
3 ejercicios de práctica
Knowledge Check: ACID Properties30m
Knowledge Check: Transactions and Concurrency Control30m
Knowledge Check: Lock-Based Concurrency Control30m
4.0
26 revisionesChevron Right

33%

consiguió un beneficio tangible en su carrera profesional gracias a este curso

33%

consiguió un aumento de sueldo o ascenso

Principales revisiones sobre Core Database Concepts

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

por 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

Comienza a trabajar para obtener tu maestría

Este curso es parte del Master of Computer Science completamente en línea de Universidad del Estado de Arizona. Si eres aceptado en el programa completo, tus cursos cuentan para tu título.

Acerca de Universidad del Estado de Arizona

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

Acerca del programa especializado 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

Preguntas Frecuentes

  • Una vez que te inscribes para obtener un Certificado, tendrás acceso a todos los videos, cuestionarios y tareas de programación (si corresponde). Las tareas calificadas por compañeros solo pueden enviarse y revisarse una vez que haya comenzado tu sesión. Si eliges explorar el curso sin comprarlo, es posible que no puedas acceder a determinadas tareas.

  • Cuando te inscribes en un curso, obtienes acceso a todos los cursos que forman parte del Programa especializado y te darán un Certificado cuando completes el trabajo. Se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes auditar el curso sin costo.

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.