Database Management System and SQL
Database Management System and SQL
  • Database Management System and SQL
  • Database
    • Introduction to Database
      • Definition
      • File System
      • Different types of Database
      • Uses of DBMS
      • Basic Terms in Database
      • Query Language
    • View of Data
      • Data Abstraction
      • Schema & Instance
      • Data Models
    • Database Architecture
      • DBMS Tier Architecture
      • Three Schema Architecture
      • Data Independence
    • Relational Database Management System (RDBMS)
      • Entity-Relationship (ER) Model
      • Attributes
      • Keys
      • Relationship
    • Functional Dependencies
    • Normalization
  • MySQL
    • Terminology
    • Database Statements
    • Table
      • Data Type
      • Create
      • Show
      • Describe
      • Drop
      • Alter
      • Auto Increment
      • Index
    • Insert
    • Select
      • Condition
      • Aggregate Functions
      • Join
    • View
    • Delete
    • Update
    • MySQL Constraints
      • NOT NULL
      • DEFAULT
      • CHECK
      • UNIQUE
      • PRIMARY KEY
      • FOREIGN KEY
Powered by GitBook
On this page
  • Query Language
  • Different Query Language
  • Different SQL Platform
  • MySQL

Was this helpful?

  1. Database
  2. Introduction to Database

Query Language

Query Language

Query language is used to define, manipulate and retrieve data from database.

Data Definition Language: Operation related to database and table create, drop, and update

Data Manipulation Language: Operation related to table to insert, delete and update data

Data Query Language: Operation related to retrieve data from a database

Different Query Language

  • QUEL (QUEry Languages)

  • QBE (Query By Example)

  • SEQUL (Structured English QUery Language)

  • SQL (Structured Query Language)

Different SQL Platform

  • Microsoft SQL Server

  • MySQL

  • Oracle SQL

MySQL

  • MySQL is a free and open-source relational database management system (RDBMS) based on Structured Query Language (SQL)

  • Michael Monty Widenius and David Axmark began writing the first version of the MySQL database in 1995 and released in 1996. "My" is the name of Michael Widenius's daughter and "SQL" is the abbreviation for Structured Query Language.

PreviousBasic Terms in DatabaseNextView of Data

Last updated 1 year ago

Was this helpful?