TestOut 7.4 & 7.5

ACID

(atomicity, consistency, isolation, and durability) transactions to prevent problems with inconsistent data.

SQL

A computer language that makes relational databases work.

Database dump

to back up a database is to export the data into a format that can be read by another program like a spreadsheet.

Query

Essentially questions we ask a database.

Data Extraction

Before analyzing and interpreting big data, it needs to be gathered and organized.

Big Data Analytics

Big data analytics is the process of asking specific questions to help interpret data.

CRUD

Create, Read, Update, Delete

Programmatic Access

Developers can write code into their software that reads, writes, updates, and deletes database records programmatically.

Big Data Ethics

Since big data is often obtained without the knowledge or consent of users, information can be sold to other organizations in a way that violates user privacy.

Data warehousing.

Sometimes the solution is to combine the two approaches using

Select

The SELECT command lets you view the specific information you want from the database. SELECT * FROM books Returns all records from the books table.

Query Builder

The builder translates the user's choices into SQL commands and runs them. This is helpful when a person may need to interact with a database but doesn't know how to write SQL commands.

Semi-structured Data

These data don't fit into the rigid rows and columns of a table but have some things in common.

Big Data

Vast amount of data collected and stored online based on internet searches, social media, post, etc.

Drop Table

command deletes an entire table, including all the data stored in it.

Grant

command is used to give a user certain permissions to a specific database object.

Where

command lets you narrow down your query to only the results you want.

Alter Tables

is used to add, change, or remove fields on an existing table.