SQL Getting Started

Welcome

This book is intended to introduce users to Structured Query Language (SQL) and relational databases. It will:

• Discuss basic concepts of SQL used in the DB2 product.
• Explain how to perform database manipulation tasks.
• Demonstrate tasks through simple examples.

If you are the system administrator, before you try out any of the examples in this book, you should:

• Install and configure the server as outlined in the Quick Beginnings book for your operating system. Create the SAMPLE database using the "First Steps" option. The SAMPLE database can also be created from a command line prompt. See the SQL Reference for details. Note: Do not put your own data into the DB2 SAMPLE database.
• Create the DB2 administrator user ID by following the instructions in the Quick Beginnings book.

If you are not the system administrator, ensure that you have a valid user ID and the appropriate authority and privileges to access the SAMPLE database.