<

SQL 101 - What is a Database

Published on
8,254 Points
2,254 Views
Last Modified:
Approved
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.

Excel.png

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.
0
Comment
0 Comments

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Join & Write a Comment

Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month