Installing a Database

• Detailed instructions for installing a database vary widely
• General sequence of steps on how to install a database and test your installation:
  1. Obtain the database program
  2. Read the installation instructions
  3. Install the program (may even need to compile from source code)
  4. Start the database
  5. Set up user accounts
  6. Run a test:

     CREATE TABLE Test (Name CHAR(20))
     INSERT INTO Test VALUES ('Romeo')
     SELECT * FROM Test
     DROP TABLE Test

     Note that you may need a special terminator for each SQL statement (e.g. ';')