Home Explore Help
Register Sign In
dsaravanan
/
reference
Watch 1
Star 1
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
reference
/
databases.txt

databases.txt 919 B
Permalink History Raw

1234567891011121314 
  1. Databases:
    2. 

  2. Databases are where serious applications and servers hold all their data. A program that allows databases to be created and modified is called a Database Management System (DBMS).
    3. 

  3. The language to communicate with a DBMS is SQL: Structured Query Language. Most DBMses accept all SQL commands. Some have quirks for SQL commands. Some have non standard SQL commands. But for basic stuff, any DBMS will do.
    4. 

  4. 

  5. There are a number of floss DBMSes:
    6. 

  6. PostgreSQL
    7. 

  7. MariaDB
    8. 

  8. 

  9. You may have also heard of some proprietary ones:
    10. 

  10. Oracle
    11. 

  11. Microsoft SQL "sequel" Server
    12. 

  12. 

  13. Inside a database you will find a number of tables (think spreadsheets, not furniture). Each table has some fields/columns that store different types of data, and a number of entries/rows which hold that data. Tables will also have one or more Primary Keys, which are used to find a unique row. Often the primary key will just be a number, like a customer ID.
    14. 

  14.