Skip to main content
Graph
Search
fr
|
en
Login
Search
All
Categories
Concepts
Courses
Lectures
MOOCs
People
Practice
Publications
Startups
Units
Show all results for
Home
Lecture
Query Fusion, Nested Queries
Graph Chatbot
Related lectures (32)
Previous
Page 1 of 4
Next
Relational Model: Basics
Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
SQL Client-Server Architecture + IDE
Covers the architecture of a typical DBMS and SQL interfaces like SQL Developer and DataGrip.
Data-Intensive Systems: Relational Model and Algebra
Introduces the relational model and algebra, essential for understanding data-intensive systems and effective database management.
SQL Queries and Syntax
Covers the basics of SQL, including components of the language and syntax of SELECT clause.
Conditional Queries: Overview
Covers the functioning of conditional queries based on the WHERE clause.
Querying a database: the SQL language
Covers the SQL language for interacting with databases through structured queries, including selecting, filtering, aggregating, and sorting data.
Views: SQL Queries Simplification
Explores how views simplify query writing and are key in data warehouses.
DDL, DML, Views
Covers SQL data definition, manipulation, and views in databases.
Relational Databases: Fundamentals
Covers relational and spatial databases, including storage, management systems, ACID properties, historical typologies, primary and foreign keys, and spatial functions.
Query Processing: Relational Operations and Models
Discusses query processing models and relational operations, focusing on selections, projections, and joins in data-intensive systems.
