Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
Databases
|
Like security boxes within a bank.
Organizes data based off of where it came from or where it’s going or its relationship to other data. |
|
Tables
|
Organizational structure within a database that allows for data to be accessed more easily.
Like files in a filing cabinet or tabs in an excel spreadsheet. |
|
3 Popular Databases
|
Oracle, SQL, MySQL
|
|
SQL
|
Similar to a CD Account - money stays in one bank.
Database made by Microsoft - companies that use this type of database generally use other Microsoft products. Has the edge for administration and integration. Ask for Microsoft reqs! |
|
Oracle
|
Similar to a savings account - commitment but can take money out any time.
Database with flexibility. Can use it with other technology made by the same company or with custom tech - ask for reqs! Strong processing power - Expensive |
|
MySQL
|
Similar to a checking account - no commitment, can move your money to wherever or whomever you want.
Open Source database - can be used with just about any other technology. Custom made and super cheap! Companies that use this generally do a lot of custom development work - ask for reqs! |
|
Open Source
|
Growing tech library of free code.
|
|
Database Architects
|
This person builds out the blueprint (or wireframes) for the databases.
|
|
Database Engineers & Developers
|
This person builds out the database using code.
Determines what information goes where. |
|
DBA - Database Administrator
|
This person makes sure that the Database is running efficiently and accurately once it is built
|