What are SQL, PL/SQL, T-SQL, Jet SQL, and SQL/PSM?, Data, Data Typee, Types of Database Management Systems, and SQL vs. NoSQL Databases.
What are SQL, PL/SQL, T-SQL, Jet SQL, and SQL/PSM?.
SQL is a Database Management Languages, PL/SQL, T-SQL, Jet SQL, and SQL/PSM are SQL dialects or extensions.
Two Types of Database Management Systems
We have several types of Database Management Systems, Hierarchical databases, Network databases, Relational databases, Object-oriented databases, etc,
Two Important Database Management Systems are,
1. SQL Databases/Relational Databases
2. NoSQL Databases/Non-Relational Databases
SQL Databases or Relational Databases
A relational database is a collection of information that organizes data points with defined relationships for easy access. In the relational database model, the data structures — including data tables, indexes and views.
SQL is an ANSI (American National Standards Institute) standard language to manage relational databases; it includes database creation, deletion, fetching rows, modifying rows, etc.
Popular SQL Databases or Relational Databases are:
Oracle, MS Acess, MS SQL Server, MySQL, PostgresSQL, IBM-DB2, etc,
NoSQL or Non-Relational Databases
Non-relational databases (often called NoSQL databases) are different from traditional relational databases in that they store their data in a non-tabular form. Non-relational databases might be based on data structures like documents.
Popular NoSQL or non-relational databases are,
MongoDB, Apache Cassandra, Redis, Couchbase, Apache HBase, etc,
What is PL/SQL?
PL/SQL (Procedural Language for SQL) is Oracle Corporation’s procedural extension for SQL and the Oracle relational database.
PL/SQL includes procedural language elements such as conditions and loops.
What is T-SQL?
Transact-SQL (T-SQL) is Microsoft’s and Sybase’s proprietary extension to the SQL (Structured Query Language) used to interact with relational databases.
T-SQL provides all the functionality of SQL but with some added extras.
What is Jet SQL?
The version of SQL created by Microsoft is called Jet SQL and it is the database engine behind Microsoft’s Access.
What is SQL/PSM?
SQL/PSM is used in MySQL, SQL/Persistent Stored Modules(PSM) is an ISO standard mainly defining an extension of SQL with a procedural language.