Your browser is blocking local storage, so your progress will be lost when you close or reload this page.

Store, query and model data in relational databases, and what else exists.

Topics

• Relational Database ConceptsExpected level: Working

  Understand tables, keys, relations, and normalization.

  Not reviewed
• SQL FundamentalsExpected level: Working

  Query, filter, sort, aggregate, and join data.

  Not reviewed
• Data ModelingExpected level: Working

  Design data structures that support business needs.

  Not reviewed
• TransactionsExpected level: Awareness

  Understand consistency and data integrity.

  Not reviewed
• Indexing BasicsExpected level: Awareness

  Learn why database performance matters and what an index does.

  Not reviewed
• NoSQL ConceptsExpected level: Awareness

  Understand alternative data storage approaches.

  Not reviewed

Self-assessment

You should be able to do each of these without help.

• Write a query with filtering, sorting, and a join. Use it to answer a question that needs data from two tables, such as orders with the name of the customer.Related: SQL Fundamentals, Relational Database Concepts
• Read a table schema and point out the primary key, the foreign keys and an index. Say what each one does for the data and for the speed of queries, and which column should get an index.Related: Relational Database Concepts, Indexing Basics
• Sketch the tables, keys and relationships for a small domain, such as books, members and loans. Say where each foreign key goes and name one rule a constraint should enforce.Related: Data Modeling
• Show that a rolled-back change leaves the data untouched. Explain why two related updates, such as a money transfer, belong in one transaction.Related: Transactions