Revature Study Guide (week 2)
What is AWS - ✔✔Amazon Web Services - a secure cloud service platform
What is RDS - ✔✔Relational Database Services - gives the ability to create, operate and
maintain a relational databas
...
Revature Study Guide (week 2)
What is AWS - ✔✔Amazon Web Services - a secure cloud service platform
What is RDS - ✔✔Relational Database Services - gives the ability to create, operate and
maintain a relational database on a cloud
What is a security group? - ✔✔Security groups act as virtual firewalls that regulate
inbound/outbound traffic for service
What is RDMS ? - ✔✔Relational Database Management Systems is a program that allows the
user to create, update, and administer relational databases using SQL.
How does an RDS structure data? How does each part of this structure relate to a Java object
model? - ✔✔RDS organizes data into tables. Each table has columns to categorize the properties
of the data.
What is an ERD? - ✔✔Entity Relational Database - an Entity relational Database describes
entities and the relational that exists between those entities
What does it mean for a database to be 'Relational'? How are relationships defined in a database?
- ✔✔Each table in a database is known as a 'relation' which contains one or more data category
columns
A structure that allows us to identify and access data in relation to another piece of data in the
database
Relationships are establish with the use of primary and foreign keys
What is SQL? - ✔✔Structured Query Language is a programming language that allows us to
communicate with the data within a RDMS
What organization maintains the standardization of SQL? - ✔✔The American National
Standards Institute
What is PostgreSQL? - ✔✔is a general purpose object-relational database management system
What other RDMS are you aware of? - ✔✔MySQL, Oracle DB, SQL server
What features make PostgreSQL special? - ✔✔*PostgreSQL is case sensitive
*Built-in functions (e.g. conditional *expressions)
*Dates and time formats and queries
*Custom functions
*Open Source
What are common datatypes in PostgreSQL? - ✔✔INTEGER,
[Show More]
