What are SQL, PL/SQL, and T-SQL?

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.

Selenium (Selenium, Java, TestNG, and Live Project) Online Training by G C Reddy

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.

SQL Step by Step Video Tutorial – Full Course 

SQL Videos

SQL Syllabus

SQL Tutorial for Beginners

SQL Queries Examples

SQL Online Test/Quiz

SQL Interview Questions for Fresher

Introduction to NoSQL

Follow me on social media: