I can not find database for example I know FakeStoreApi, FakeMovieDatabase and so on database. That’s way, I need a lot of database for my project. Why is needed for me? That’s why, I want to create project and working with database API and I want to improve my hard skills and I should change my passive programming language to active language.
Sardor Kamoliddinov is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
For students, teachers, developers, db admins, professionals, companies etc. Microsft releases Sample Databases.
Those sample databases contains fictitous company data.
The databases and its data, structure, objects (tables, views, procedures, functions etc), relations, keys, indexes, could be used as a reference
You can download and use the following sample real, well structured databases for your api and other works, to develope yourself.
First:
Northwind and pubs sample databases for Microsoft SQL Server.
You can download from the following link.
https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
Northwind is a good sample database with customers, employees, orders, products, suppliers etc. data.
Pubs database contains books, authors, publishers, sales, stores, titles etc data.
Northwind and Pubs are mid sized – complexity databases.
Second:
Adventureworks contains an international company data of a fictitious firm. The firm produces and sells bikes. So you can find all supply chain, Inventory, Sales, Receivables, Manufacturing, General Ledger etc module’s data.
If you want to test, learn more up to date, new features of SQL Server, Integration Services, Olap, etc you can choose Adventureworks over Northwind and Pub.
You can download from the following link.
https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms
Link contains normal OLTP and OLAP and Lightwight OLTP downloadable versions.
Adventureworks sample database types and versions.
Third:
Wide World Importers sample databases for Microsoft SQL
You can find detailed info from the following link.
https://learn.microsoft.com/en-us/sql/samples/wide-world-importers-what-is?view=sql-server-ver16
You can download the sample database from the following link.
https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0
Fourth:
You can search the internet for sample database.
-
-
https://www.sqlskills.com/sql-server-resources/sql-server-demos/
-
https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/
Note: Due to my reputation limit i cant add a comment for question. Then i wrote my message as an answer.