SQL DATABASES INFORMATION BASIC

in #sql7 years ago

TYPES
One type SQL database with minor variations

HISTROY
Developedin 1970s to deal with first wave of data storage applications

TYPES
MySQL, Postgres, Oracles, Database

SCHEMAS
To store information about a new data item the entire database must be altered during which time the database must be taken offlibe

DEVELOPMENT MODEL
Mix of open source (Postgres, MYSQL) and close source (Oracle Database)

Support Transactions
Yes updates can be configured to complete entriley not at all

DATA MANIPULATION
Specific language using Select, Insert and Updates statement SELECT fields FROM table WHERE

965dc069-b39a-4831-9d9d-b717e592d816.png