SQL and Postgres

Question 1

SQL

Answer 1

language of relational databases
SQL statements can be categorized into two main groups: 1. Data Definition
2. Data Manipulation

Question 2

SQL data definition

Answer 2

ex. such as creating tables

Question 3

SQL data manipulation

Answer 3

ex. inserting and deleting data from tables

Question 4

PostgreSQL

Answer 4

Relational database management system

Question 5

Database management system (include?)

Answer 5

usually includes:

1. Data Definition Language
2. Data Manipulation Language
3. security system to prevent unauthorized access
4. system to maintain the integrity of the data
5. concurrency control system for allowing shared access to the database
6. recovery control system to restore the database in the event of a hardware or software failure
7. other utilities to facilitate secure, fast, scalable, data access

Question 6

Relational Databases

Answer 6

data and the relationship between them are represented as tables.

Question 7

relationship of sql and postgres sql

Answer 7

sql is the language of postgresql that does data definiteon and data manipulation
sql is the panguage used in postgresql to do data definition and data manipulation

Question 8

What is an XSS attack and do you know any steps to take to prevent them?

Answer 8

Cross-site scripting (XSS)
an embedded piece of JavaScript inside content from an API response. This JavaScript gets into your user’s castle (browser), it then reads their secured data, such as; API tokens, authentication tokens, account details… and then sends them to another malicious server! The malicious server can store the token and use it to do damage to your user’s account.
client side code that could make website to run someone else’s code
prevent XSS attacks by “sanitizing” the content in our response data.

Question 9

What are environmental variables and what might you put in them?

Answer 9

.env file
Which HTTP port to listen on
What path and folder your files are located in, that you want to serve
Pointing to a development, staging, test, or production database

Question 10

Why use env variables?

Answer 10

they externalize all environment specific aspects of your app and keep your app encapsulated. Now you can run your app anywhere by modifying the environment variables without changing your code and without rebuilding it!

Question 11

when use env variables?

Answer 11

any place in your code that will change based on the environment