Where to find the example database used in the SQL course?

Question

Can anyone tell me the name of the database used in the SQL fundamentals course. I am looking to download a copy to import into my MySQL server. The URL to a database dump file would also be welcome. thanks!

Answer 1

Based on how simple the data samples are in the SQL course, I doubt this is based on any published database. That said, you can still apply the lessons learned from the SoloLearn SQL course to other sample databases. Here are a few I just pulled from a Google search:

- -----------------------------------------------
- Recommended based on brief review:
- -----------------------------------------------
- http://www.mysqltutorial.org/mysql-sample-database.aspx
- https://dev.mysql.com/doc/employee/en/employees-introduction.html

- -------------------------------------------
- Other MySQL DB Samples from Quick Search:
- -------------------------------------------
- https://dev.mysql.com/doc/employee/en/employees-introduction.html
- https://github.com/datacharmer/test_db
- https://www.ntu.edu.sg/home/ehchua/programming/sql/SampleDatabases.html
- https://dev.mysql.com/doc/sakila/en/
- https://dev.mysql.com/doc/sakila/en/sakila-installation.html

- -------------------------------------------
- Microsoft SQL Server DB Samples:
- -------------------------------------------
NOTE: These databases have evolved over many years and might be good to refer to.
You might be able to install these databases on SQL Express (a free version).

- https://technet.microsoft.com/en-us/library/bb510407(v=sql.105).aspx
- https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
- https://msftdbprodsamples.codeplex.com/
- https://github.com/Microsoft/sql-server-samples
- http://www.dofactory.com/sql/sample-database
- https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0

Answer 2

I know some sites gives a space for online sql coding to learn, but dump for download...?

Answer 3

thanks David!

I had already downloaded and installed the MySQL employee DB. Now working on a python based (cli) client to query it. I'll post it for comments when it's ready. might take a while because of the busy week ahead.

hadn't heard of SQL express. going to try that later.