Most database products ship with some test sample databases you can use for practice. We’ll summaries here the most significant and free example databases from well-known relational database products. Each will be introduced with one or more model diagrams, and a list of tables, with total number of records and the estimated occupied size.
Extensive list of open-source SQL scripts for relational test databases. From open-source code repositories, free databases published by website owners, and book authors.
Connect to most popular database types to extract metadata. Generate flexible and dynamic database diagrams with our free Model Xtractor. Export them as Graphviz DOT files. And render them instantly on Graphviz online applications, by simply pasting the content of the exported files.
Learn how to perform exploratory analysis in Data Xtractor with a simple example. Discover related tables through expandable relationship items. Display conceptual many-to-many relationships for less diagram clutter. Design complex queries without typing SQL, with a generic visual interface. Generate database-specific SQL. Create inline and regular charts directly from your query results, with trivial chart type selections.
It bothered me for a long time there was no data modeling tool to represent, in the conceptual view of a relational database model, many-to-many relationships with just a straight connector between the two tables and nothing more. With no required intersection table, as long as this was a physical level implementation detail.