Chapter 1. DBMS Specifics

You’ll need a database management system to run SQL programs. You may have your own private copy of a DBMS running on your desktop computer, or you may have access to one over a network. In the latter case, you’ll be using your desktop computer to connect to a DBMS server running on another machine. The computer where the server is running is called a host.

As this book is about SQL and not DBMSes, I won’t rehash the instructions for installing and configuring database software. This evasion may seem like a brush-off at first glance, but setting up a DBMS varies greatly by vendor, product, version, and operating system. All DBMSes come with extensive installation, administration, reference, and tutorial documentation. ...

Get SQL: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.