Functionalities

Currently LEARN-SQL allows to learn and to evaluate the correctness of the following types of relational database exercices

  • SQL queries
  • SQL insertions, updates and deletes
  • SQL creation of tables, views and sequences
  • Logical design
  • Normalization
  • Relational algebra
  • Stored procedures
  • Triggers
  • JDBC applications
  • Multidimensional operations
  • Optimization - Materialized views
  • Optimization - Indexes
  • Query cost estimation