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.