Databases & Network

Front 1

Databases

Back 1

"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."

Front 2

"Tables"

Back 2

"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."

Front 3

"3 Popular Databases"

Back 3

"Oracle, SQL, MySQL"

Front 4

"SQL"

Back 4

"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!"

Front 5

"Oracle"

Back 5

"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"

Front 6

"MySQL"

Back 6

"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!"

Front 7

"Open Source"

Back 7

"Growing tech library of free code."

Front 8

"Database Architects"

Back 8

"This person builds out the blueprint (or wireframes) for the databases."

Front 9

"Database Engineers & Developers"

Back 9

"This person builds out the database using code.

Determines what information goes where."

Front 10

"DBA - Database Administrator"

Back 10

"This person makes sure that the Database is running efficiently and accurately once it is built"

Front 11

Network

Back 11

Like the air chute in a bank or a highway that allows you to travel places.

This built out of cables and switches and routers, and is set up to efficiently transfer information.

Front 12

3 Things that make up a Network

Back 12

Cables, Switches, Routers

Front 13

Switches

Back 13

Like a service road on a highway that allows you to stop at a store without backing up traffic.

These allow different hardware or devices on the network to talk to each other - like a printer and computer.

Front 14

Router

Back 14

Like a map or GPS that shows you how to get to where you're going.

This acts as a dispatcher, choosing the best path for info or data to travel quickly.

Front 15

2 ways to configure a network

Back 15

WAN (Wide Area Network) & LAN (Local Area Network)

Front 16

WAN

Back 16

Wide Area Network

Front 17

WAN - Wide Area Network

Back 17

Like your extended bank network or ATMs.

These networks are set up to connect multiple locations to the same network of information.

Front 18

LAN - Local Area Network

Back 18

Like a bank drive through.

These networks are set up to stay within one geographic location.

Front 19

Protocols

Back 19

Like the rules that say you must have a PIN and ATM Card to access your money at the bank or ATM.

The set of rules that must be followed for hardware to communicate

Front 20

IP Address

Back 20

Like your PIN# and ATM Card which allow the bank to know that you are you.

This allows the network to know your computer from another computer.

Front 21

Network Architect

Back 21

This person decides how information should flow from one device to another and how large the network needs to be so that there aren’t any traffic jams!

Front 22

Network Engineer

Back 22

This person is familiar with different types of routers and switches (like GPSs and Service Roads) and will understand how to piece them together to build the network.

Front 23

Network Admin

Back 23

This person makes sure everything is running smoothly on the network. They use switches and routers to make sure no traffic jams occur in live time.

Front 24

Cisco Specialist

Back 24

Network Specialist for telephone networks.

Front 25

Firewall & Security Specialist

Back 25

Network specialist focused on security & protocols