What is SQL ?
- SQL is an acronym for Structured Query Language
- SQL is used to communicate with relational databases
- Some common relational database management systems that use SQL include Microsoft SQL Server, MySQL, PostgreSQL, MariaDB, and Oracle
- SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
What Can SQL do?
- Standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database.
- SQL can execute queries against a database using the above commands
- SQL can create new tables, stored procedures, views, and set permissions on tables, procedures, and views in a database
What is RDBMS ?
- RDBMS stands for Relational Database Management System.
- RDBMS data is structured in database tables, fields and records.
- Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields.
- RDBMS store the data into collection of tables, which might be related by common fields (table columns).
- Most RDBMS use SQL as database query language.
- The most popular RDBMS are MS SQL Server, DB2, Oracle and MySQL
Tags:
SQL