Big Data analytics tools are increasingly critical for providing meaningful information for making better business decisions.
Offert par
Data in Database
Université d'État de l'ArizonaÀ propos de ce cours
Ce que vous allez apprendre
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
Offert par

Université d'État de l'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.
Commencez à travailler pour obtenir votre master
Programme du cours : ce que vous apprendrez dans ce cours
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.
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.
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.
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.
Avis
Meilleurs avis pour DATA IN DATABASE
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.
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
À quoi ai-je droit si j'achète le Certificat ?
Quelle est la politique de remboursement ?
D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.