Big Data analytics tools are increasingly critical for providing meaningful information for making better business decisions. Big data technologies bring significant cost advantages when it comes to storing and managing large amounts of data. Understanding how to query a database to extract data will empower better analysis of large, complex datasets. Knowledge of Indexing mechanisms makes possible high-speed, selective retrieval of large amounts of information.
ofrecido por
Data in Database
Universidad del Estado de Arizona
Acerca de este Curso
7,433 vistas recientes
Qué aprenderás
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
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. 13 horas para completar
Sugerido: 9 hours/week
Inglés (English)
Subtítulos: Inglés (English)
Programa - Qué aprenderás en este curso
1 horas para completar
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 horas para completar
3 videos (Total 20 minutos), 3 lecturas, 1 cuestionario
3 lecturas
Best Practices for Online Learning5m
Technology Tools10m
PostgresSQL Resources2m
1 ejercicios de práctica
Knowledge Check: Database Systems4m
4 horas para completar
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 horas para completar
4 videos (Total 43 minutos), 1 lectura, 1 cuestionario
4 videos
Class Hierarchies and Aggregation within ER Models8m
Creating Relations in SQL14m
ER to Relational Model8m
1 lecturas
Practice SQL Exercises2m
4 horas para completar
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 horas para completar
11 videos (Total 45 minutos)
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 ejercicios de práctica
Knowledge Check: Introduction to Data and Data Processing4m
Knowledge Check 1: Relational Algebra6m
Knowledge Check 2: Relational Algebra8m
2 horas para completar
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. As the week continues, we discuss transaction locks and database recovery. Transaction locks are critical to data consistency. All organizations think about recovery mechanisms for databases, and have some in place in the event of a crash. We close out this week with a discussion on database recovery.
2 horas para completar
7 videos (Total 80 minutos)
7 videos
Alternative File Organization11m
Hash-Based Indexes4m
Index Classification15m
Principles of Transactions: ACID Properties11m
Lock-Based Concurrency Control15m
Database Recovery14m
3 ejercicios de práctica
Knowledge Check: ACID Properties8m
Knowledge Check: Transactions and Concurrency Control6m
Knowledge Check: Lock-Based Concurrency Control6m
Instructores
Ming Zhao
Associate Professor ASU School of Computing, Informatics, and Decision Systems 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.
Preguntas Frecuentes
¿Qué es Coursera Plus y su política de reembolso?
¿Cuándo podré acceder a las lecciones y tareas?
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.
¿Qué recibiré si compro el Certificado?
Cuando compras un Certificado, obtienes acceso a todos los materiales del curso, incluidas las tareas calificadas. Una vez que completes el curso, 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 participar del curso como oyente sin costo.
¿Cuál es la política de reembolsos?
¿Hay ayuda económica disponible?
¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.
© 2020 Coursera Inc. Todos los derechos reservados.
