SQL Databases Flashcards
SQL Databases
used to store and manage the data objects that are related to one another
Tables
database objects used to collect data in Row and Column format.
Rows
Rows are horizontal elements in a table and users can add data or retrieve by executing SQL queries.
Columns
Columns are vertical elements in a table. Each column in a table holds specific attribute information, and column properties such as column name and data types (Integer, Char, String, etc).
MySQL
open source SQL database. Is case sensitive.
Features
- High Performance.
- High Availability.
- Scalability and Flexibility Run anything.
- Robust Transactional Support.
- Web and Data Warehouse Strengths.
- Strong Data Protection.
- Comprehensive Application Development.
- Management Ease.
- Open Source Freedom and 24 x 7 Support.
- Lowest Total Cost of Ownership.
MS SQL Server
developed by Microsoft Inc.
ORACLE
- very large multi-user based database management system.
-excellent database server choice for client/server computing. - Developed by Oracle corporation
MS ACCESS
- one of the most popular Microsoft products. It is an entry-level database management software. It is not only inexpensive but also a powerful database for small-scale projects.
- uses the Jet database engine, which utilizes a specific SQL language dialect
PostgreSQL
Object relational database management system (ORDBMS) that supports both relational (SQL) and non-relational (JSON) query. It is a highly stable database that is developed based on the POSTGRES, version 4.2 released by the Computer Science Department in University of Berkeley, California. This database is a popular database or data warehouse for many applications.
SQLite
It is referred to as a lightweight database as it is not more than 500kB in size, which is way less than other relational databases. This database is an in-memory open source library; which is why it can access the files stored in it directly and the source code for it is available in the public domain.
