The Complete Guide to Relational Databases

database iconRelational databases provide a way to store information in a collection of tables and define links between them. The concept of a relational database has been around since the 70s, and since then they have become the prevailing database standard. A software package that manages relational databases is known as a Relational Database Management System, or RDBMS.

Relational databases are created, modified and queried using SQL, which stands for Structured Query Language. Although there are slight variations between the SQL syntax used by the various RDBMSs available today, SQL can be considered a common standard.

This guide takes a look at some of the more popular RDBMSs, provides tips on to create databases, and covers some of the issues surrounding database security.

Latest Articles on Relational Database
A User's Guide to Building Table Relationships in Access 2007

Building relationships is one of the cornerstones of learning to create relational databases with Access 2007. Learn the basics of building powerful relationships to get the most from...

Microsoft Access: Designing a Relational Database (Part 1)

The most critical aspect of creating a database is excellent design. Without a core set of principles and structure you will be forever chasing your tail, reworking data and tables...

The Differences between Flat and Relational Access Databases

When creating a database, you need to decide whether that database will be flat or relational. Learn about how to set up these two different types of databases with Microsoft Access...

What is Relational Database Security?

Data security has received attention as recently as the 80s, when it was legally acknowledged that misuse of data constitute great losses for victims. There are substantial measures...

Most Popular Articles on Relational Database
  •  
    The Differences between Flat and Relational Access Databases

    When creating a database, you need to decide whether that database will be flat or relational. Learn about how to set up these two different types of databases with Microsoft Access and the advantages...

  •  
    What is Relational Database Security?

    Data security has received attention as recently as the 80s, when it was legally acknowledged that misuse of data constitute great losses for victims. There are substantial measures put into place with...

  •  
    Advantages and Disadvantages of Microsoft Access

    Microsoft Access is a database application that both trumps and, in some ways, falls short when compared to its single-table “cousin” Microsoft Excel. Whether the “pros” outweigh...

  •  
    Microsoft Access: Designing a Relational Database (Part 1)

    The most critical aspect of creating a database is excellent design. Without a core set of principles and structure you will be forever chasing your tail, reworking data and tables in an attempt to capture...

  •  
    A User's Guide to Building Table Relationships in Access 2007

    Building relationships is one of the cornerstones of learning to create relational databases with Access 2007. Learn the basics of building powerful relationships to get the most from your Access 2007...

More About Relational Database
Advantages and Disadvantages of Microsoft Access

Microsoft Access is a database application that both trumps and, in some ways, falls short when compared to its single-table “cousin” Microsoft Excel. Whether the “pros”...

When is it time to move to MS Access?

If you have been keeping large spreadsheet tables of data that have gone wide and deep, it may be time to switch to a database. The power and the flexibility of the database application...



Meet the Guide Editor
Relational Database Contributors



© Copyright 2016 brighthub.com.