Use Cases

SQL Database Schema

There are different ways to store database, and generally multiple tables and multiple database types are used based on the strength and weaknesses of each database and the use case. Schema needs to be defined for the purpose.

Here is a very interesting database I came across, how website like Stack Overflow is using multiple tables to store data, and the schema for each table; how different tables are connected and can be queried:

Query Stack Overflow - Stack Exchange Data Explorer

Queries for SQL Database

Retrieval of information is an important aspect of designing a database, queries are written based on the schema for the purpose. Once you understand the schema of the Stack Overflow database, looking at different queries to retrieve the data can be understood after going through different queries:

Browse Queries - Stack Exchange Data Explorer