Computing and tech
The SQL sandbox
Write real SQL queries on a cinema's database: films, screens, showings, tickets. Change it, even break it, and see what the constraints let through.
Free, with your Voyelle account.
What leads here.
The decks that help you review what you handle here, and the learning path it belongs to.
The learning pathModelling and querying a databaseIts decks come in the right order, step by step, up to the badge.
The decks
- Entities, attributes, identifiers
- Relationships and cardinalities
- The conceptual data model
- From the conceptual model to the relational model
- Primary and foreign keys
- Integrity constraints
- Data redundancy
- Selection and projection
- The join in relational algebra
- Union, intersection, difference
- Cartesian product and division
- CREATE TABLE and data types
- Constraints in SQL
- ALTER and DROP
- SELECT and WHERE
- Sorting, DISTINCT, LIMIT
- Inner joins
- Outer joins
- Aggregate functions
- GROUP BY and HAVING
- INSERT, UPDATE, DELETE
- NULL in SQL
- Subqueries
- Set operators in SQL
- Views
- Functions and CASE
- Window functions
- The WITH clause
- Relational databases
- Users and roles
- GRANT and REVOKE
- Sample and test data
- Forms and reports
- The CASE tool
In the same subject.
Two sessions
Two transactions, an order to choose
The normalisation workshop
From dependencies to normal forms
Four stores, one dataset
The same data in four stores
Try it, then review what it taught you.
Free: the whole library, unlimited reviews, no ads. See pricing