How can I access and use free databases from Murach's book?

[WWGD]

Hi All,
Free databases from Murach's book:
https://www.murach.com/shop/murach-s-sql-server-2016-for-developers-detail
Note these are not a ripoff; these databases are used in the book whose link is above. You can save them as .sql or text files and run them as a query. I just installed them.

 

[fresh_42]

Does it have a shell included, or is it only the server? As in "Here is your new database and there is the link to toad!" And is it better than MySql?

 

[WWGD]

It is in .sql, which is just a text file. You can just open it, copy the full text, paste it and run it as a query. I haven't tried with MySql. I know it runs in SQl Server and I got my new database in less than a minute. EDIT: These are the databases to be run with SQL Server, maybe MySQL; not the full server.

 

[fresh_42]

So it's just a bunch of scripts? At least as far as I could see. I haven't checked the executive, but the name suggests, that is only a self-extracting file for the scripts.

I thought it was a database server, possibly including a shell. Who needs scripts?

 

[WWGD]

So it's just a bunch of scripts? At least as far as I could see. I haven't checked the executive, but the name suggests, that is only a self-extracting file for the scripts.

I thought it was a database server, possibly including a shell. Who needs scripts?

If you want a server download SQL Server or My SQL for free. I need the scripts to practice querying. Specially for reasonably-large databases/tables.

 

[fresh_42]

I have once installed another database (HyperFile) including shell and ERD tool. It was part of a programming IDE for lazybones. You can write programs in hours and the installation doesn't require to set up the system for days, as in VisualC e.g. Unfortunately only the demo version, which runs out in time. But it can handle large files pretty well. If I had to deal with databases more often, I think I would buy toad as a shell. Never seen something better, including the shells that came with the database servers from Oracle to MySql.

 

[WWGD]

I have once installed another database (HyperFile) including shell and ERD tool. It was part of a programming IDE for lazybones. You can write programs in hours and the installation doesn't require to set up the system for days, as in VisualC e.g. Unfortunately only the demo version, which runs out in time. But it can handle large files pretty well. If I had to deal with databases more often, I think I would buy toad as a shell. Never seen something better, including the shells that came with the database servers from Oracle to MySql.

But I don't think scripting a database is simple. Do you script your own?

 

[fresh_42]

Not in the case described above. There you only modell it and let the shell do the job, including all joins. In SQL you only have those create scripts. Once you have one, you can easily build copies of it.

 

[WWGD]

Not in the case described above. There you only modell it and let the shell do the job, including all joins. In SQL you only have those create scripts. Once you have one, you can easily build copies of it.

I think we may be using the term 'script' differently here. The script as I am using it is the code you run to generate the full database.