Skip to content

SQL 101 – What is a Database

2005 June 1
tags: ,
by Shannon Lowder

The term database is used for many different meanings.  But if you compared them all, I think you would find that databases are all collections of data that are organized in some way.  I usually like to refer to an Excel document when I try to explain databases.

An example Excel 2003 file.

An example Excel 2003 file.

An excel file has a collection of worksheets. At a very basic level you can consider a database a collection of tables.  There are other objects in a database, but tables will be what you work with most often.

Usually each of those worksheets represents a single collection of data.  Let’s say in our Excel file we were collecting data on sales.  We’d create a worksheet for customers, a worksheet of products, and a worksheet of sales (relating the customer to a product sold, with quantities, dates sold, and sales prices.  Each of these worksheets would represent tables in our database.

Each of those worksheets have rows and columns.  Each row in our sheet would represent one record in a table.  The record is a set of data all describing a single entity to the table.  If we were to discuss the customer table, each row would hold information on a single customer.  That customer’s first name, last name, address, etc.

Each column in our worksheet would represent an attribute.  The first name, last name, etc. we just mentioned is an attribute that describes a customer.

Tips

  • Think of the database as a container.  It contains organized data.
  • Don’t confuse the term database with database management systems (DBMS).  A database is your container, MS SQL 2000 is the management system.  It’s Microsoft’s method for organizing your data into usable elements.

You should now have a basic understanding of what a database is, and few of the items you will find inside a database.  If you have any questions, please, send them in!  I look forward to helping any way I can.

Previous: Introduction Next: What is SQL?
6 Responses leave one →
  1. mabrewer permalink
    July 30, 2005

    This was very helpful for a beginner level understanding of the topics.

  2. mjkaz permalink
    July 30, 2005

    A nice gentle introduction to SQL Server.Excellent. I’m looking forward to the rest of the series.

  3. mjb1980 permalink
    July 30, 2005

    Excellent introduction into a new language for beginners. This is EXACTLY what I was looking for!Thanks much!

  4. pambatman permalink
    July 30, 2005

    make good impression i think its better than a book!

Trackbacks and Pingbacks

  1. SQL 101 | Shannon Lowder
  2. SQL 101 – What is SQL? | Shannon Lowder

Leave a Reply

Note: You can use basic XHTML in your comments. Your email address will never be published.

Subscribe to this comment feed via RSS