See https://github.com/jpwhite3/northwind-SQLite3
"All the TABLES and VIEWS from the MSSQL-2000 version have been converted to Sqlite3 and included here. Also included are two versions prepopulated with data - a small version and a large version"
Answer from peak on Stack Overflowsql - Where can I download the Northwind sample database for SQLite? - Stack Overflow
Want to download Northwinds sample database, but confused
Import Northwind Sample
Anywhere i can get dummy SQL database for practice?
You can download the Stack Overflow DB: https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/
You can also query it directly from the Web: https://data.stackexchange.com/stackoverflow/query/new
More on reddit.comSee https://github.com/jpwhite3/northwind-SQLite3
"All the TABLES and VIEWS from the MSSQL-2000 version have been converted to Sqlite3 and included here. Also included are two versions prepopulated with data - a small version and a large version"
You can download a version of sqlite3 database from
https://code.google.com/archive/p/northwindextended/downloads
Advantage: It is available immediately. Click and use.
If it's simply to get a sample database for general testing, then just use what's immediately available. If you require an exact copy to match testing results (for instance), then download and convert MS data yourself to ensure exactness since the file's header indicates modifications and added foreign keys and contains no other certification of content. You really need to answer this for yourself based on your own requirements.
Without knowing anything about the conversion process, I would at least guess that the date values are not precisely the same since sqlite has no native DateTime type, rather such values would have needed to be converted to string values and/or Julian numeric values. Of course the values themselves may represent the same dates and times, but processing of query data would certainly require special handling. BLOB values for images should also produce the same images, but retrieving and using those values will likely be different than getting them from other databases. I suppose there could be other data values/types that different handling would apply since sqlite really has no distinct, strict numeric types, rather just type affinities.
I get better at SQL (I am pretty new to it), I heard you could download the MS Northwinds sample database to practice on. I went to this URl: sql-server-samples/samples/databases/northwind-pubs at master · microsoft/sql-server-samples · GitHub
but all I see are 2 fix files, an Azure SQL database, and a readme. I already have SQL Management studio installed, but not sure how to download this and attach it