Skip to main content
Graph
Search
fr
en
Login
Search
All
Categories
Concepts
Courses
Lectures
MOOCs
People
Quizes
Exercises
Publications
Startups
Units
Show all results for
Home
Lecture
Views: Simplifying SQL Queries
Graph Chatbot
Related lectures (43)
DDL, DML, Views
MOOC: Geographical Information Systems 1
Covers SQL data definition, manipulation, and views in databases.
Data modeling: Geographic Information Systems
MOOC: Geographical Information Systems 1
Introduces data modeling in the context of Geographic Information Systems, covering the added value and methods used.
Data Modeling: Concepts and Applications
Explores data modeling concepts, SQL implementations, and practical applications in handling missing data.
Handling Data: Data Models and Wrangling
Explores data handling fundamentals, including models, sources, and wrangling, emphasizing the importance of understanding and addressing data problems.
Query Fusion, Nested Queries
MOOC: Geographical Information Systems 1
Covers query fusion, nested queries, and SQL operators in a geographical context.
Data, big data, clouds and IoT
Explores data representation, databases, cloud computing, and challenges in the cloud environment.
Data Warehouses and Decision Support Systems
Log in to Mediaspace to watch this video
Explores views in data warehouses, materialization tradeoffs, top-k queries optimizations, and the impact of column stores.
Views: SQL Queries Simplification
Log in to Mediaspace to watch this video
Explores how views simplify query writing and are key in data warehouses.
Data Warehouses and Decision Support Systems
Log in to Mediaspace to watch this video
Explores data warehouses, decision support systems, OLAP, data lakes, multidimensional data models, and query optimizations.
OLAP Queries and Optimizations
Log in to Mediaspace to watch this video
Covers OLAP queries, examples of comparisons, ranking, and optimizations for query performance.
Introduction to Database Systems
Log in to Mediaspace to watch this video
Covers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.
Relational Model: Basics
Log in to Mediaspace to watch this video
Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
OLAP Data Model: Multidimensional and Relational Approaches
Log in to Mediaspace to watch this video
Explains OLAP data models, focusing on multidimensional and relational approaches.
OLAP: Overview and Queries
Log in to Mediaspace to watch this video
Introduces OLAP concepts, schemas, queries, and optimizations for efficient data analysis.
Data-Intensive Systems: Relational Model and Algebra
Log in to Mediaspace to watch this video
Introduces the relational model and algebra, essential for understanding data-intensive systems and effective database management.
Introduction to Database Systems
Log in to Mediaspace to watch this video
Covers the basics of database systems, including data modeling, DBMS, data independence, and the course overview.
Efficient GPU Join Optimization
Log in to Mediaspace to watch this video
Covers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.
Adaptive Sharing in Analytical Databases
Log in to Mediaspace to watch this video
Explores adaptive sharing in analytical databases to reduce costs and improve efficiency through novel execution paradigms.
Data Warehouses: Introduction and Challenges
Log in to Mediaspace to watch this video
Covers the introduction and challenges of data warehouses, including integrating data, managing metadata, and optimizing query performance.
Data Ingestion Layer: SmartDataLake
Log in to Mediaspace to watch this video
Explores the data ingestion process in SmartDataLake, including datasets and the RAW platform.
Previous
Page 1 of 3
Next
