Databases and SQL

Databases and SQL

Database

A database is a large collection of related data, which models the relationships between various entities

Schema

• The description of a collection of data is called a schema.

• A schema may have many tables

• Each table has rows (records) and columns(fields) and represents a relation.

• The tables maybe related through common columns (keys).

Database management system (DBMS)

A database management system is software to store and manage databases

Relational Database management system (RDBMS)

A database management system is software to store and manage databases

Examples :
i) MySQL
ii) MS SQL
iii) Oracle

MYSQL

• MySQL is an open source SQl database management system supported by Oracle Corporations.

• It was created by MySQL AB and Michael Widenius.

• It was released on 23rd May 1995.

• Written in C and C++

• Used by Facebook, Twitter, Youtube
  

SQL

• SQL stands for Structured Query Language.

• It's a standard language used for managing and manipulating relational databases.

• SQL allows users to perform various operations on databases, such as querying data, updating data, inserting new data, deleting data, creating databases and tables, defining permissions, and much more.
  

Match

Match the following

• ARPANET

• Python 0.9

• HTTP was developed in the year

• MySQL

1969

1991

1989

1995

• 1969

• 1991

• 1989

• 1995