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

  • Thread starter Thread starter WWGD
  • Start date Start date
Click For Summary

Discussion Overview

The discussion revolves around accessing and using free databases provided in Murach's book on SQL Server 2016. Participants explore the nature of these databases, their installation process, and their compatibility with different database management systems.

Discussion Character

  • Exploratory
  • Technical explanation
  • Debate/contested

Main Points Raised

  • One participant shares a link to the free databases from Murach's book and mentions they can be saved as .sql or text files to run as queries.
  • Another participant inquires whether the databases come with a shell or if they are just scripts, comparing them to MySQL.
  • A participant confirms the databases are in .sql format and can be run in SQL Server, noting they have successfully installed them.
  • Some participants express confusion about whether the provided files are merely scripts or if they include a full database server with a shell.
  • One participant mentions their experience with another database (HyperFile) that included a shell and tools, contrasting it with the Murach databases.
  • There is a discussion about the complexity of scripting databases, with some participants suggesting that the term 'script' may be understood differently among them.

Areas of Agreement / Disagreement

Participants express differing views on the nature of the databases, whether they include a shell or are solely scripts. There is no consensus on the best approach for using these databases or the necessity of a shell.

Contextual Notes

Some participants mention the need for larger databases for practice and express varying levels of familiarity with scripting and database management tools.

WWGD
Science Advisor
Homework Helper
Messages
7,804
Reaction score
13,114
Technology news on Phys.org
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?
 
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.
 
Last edited:
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?
 
fresh_42 said:
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.
 
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.
 
fresh_42 said:
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?
 
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.
 
fresh_42 said:
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.
 

Similar threads

How to get Permission to See Tables Diagram in MSSQL2014
  • · Replies 4 ·
Replies
4
Views
2K
Why can't there be a Database tool that has the best of everything?
  • · Replies 5 ·
Replies
5
Views
3K
Connecting Anaconda with Access Database using Pyodbc
  • · Replies 15 ·
Replies
15
Views
3K
JavaScript How do I save JSON files to off-line database?
  • · Replies 8 ·
Replies
8
Views
2K
Storing program source as relations in a database instead of text file
  • · Replies 65 ·
3
Replies
65
Views
5K
Python I am trying to use alembic in python flask and it is not working
  • · Replies 13 ·
Replies
13
Views
5K
Java Searching & Displaying Items in Android App Using Java & SQL
  • · Replies 5 ·
Replies
5
Views
3K
Python How can I build a database in Python?
  • · Replies 1 ·
Replies
1
Views
3K
Do you want to build a website?
  • · Replies 15 ·
Replies
15
Views
3K
C/C++ Why is Learning C# So Frustrating for C++ Developers?
  • · Replies 13 ·
Replies
13
Views
3K