Sql vs tsql vs plsql

sql vs pl/sql vs mysql | sql vs tsql | pl sql vs tsql | sql vs pl/sql | ansi sql vs tsql | sql vs mysql vs sql server

Text version of the video and SQL scripts

SQL Server Tutorial for beginners

SQL Server Interview Questions and Answers

SQL Server Performance Tuning and Query Optimization

[bezaar]

Vekant do you know how you are life changer? i was biology major but beacuse of you now iam IT profession . i swear i dont have any word for you. just god gives and maintain your health and peace. bless you and your loved one .

[nishantkumar]

Thanks Man, You are here that is why we are doing job as a Developer

[muraliraj]

Thanks Guru, with your videos help only I have moved from non-technical to technical...lots of respect..

[mlkhjz]

The only person who describes T-SQL clear! Thanks 🙏

[MahammedKareemulla]

u r explanation clears my long time confusion venkat.thanks now i become ur subscriber.

[marconagel]

You are an inspiration for programmers and engineers, thanks for all bro, God bless you!

[abidzohri]

Thnx alot sir to Explain the folks like me who dont even know the basics difference of that thnx alot sir

[zongoboy]

Man is an impact to the universe, I am teaching for free in Africa, and this has been my teacher

[sivanelly]

My favorite channel..excellent teaching style..superb voice

[vijaybalraj]

Was having confusion, now clear.. Thanks Venkat...

[praveenkumar-yfqd]

Best explanation.... thanks for clearing my doubt

[cmjasti]

Super..Nice explanation.I appreciate the way you teach..God bless you..

[ganeshmudkhede]

Good to see you Sir after long time.... I fallow your learnings

[pramodmaurya]

Your are the best teacher...i have ever seen..god bless you..

[abhishekmd]

Thank you for such a Wonderful information :-) Expecting more videos like this.

[ruhollahjafari]

Difference between SQL and PL/SQL

SQL


PL/SQL
SQL is a single query that is used to perform DML and DDL operations.
PL/SQL is a block of codes that used to write the entire program blocks/ procedure/ function, etc.
It is declarative, that defines what need to be done, rather than how things need to be done.
PL/SQL is procedural that defines how the things needs to be done.
Execute as a single statement.
Execute as a whole block.
Mainly used to manipulate data.
Mainly used to create an application.
Interaction with a Database server.
No interaction with the database server.
Cannot contain PL/SQL code in it.
It is an extension of SQL, so that it can contain SQL inside it.
Difference Between T-SQL and PL-SQL
T-SQL
PL-SQL
T-SQL is a Microsoft product.
PL-SQL is developed by Oracle.
Full Form of TL SQL is Transact Structure Query language.
Full Form of PL SQL is Procedural Language Structural Query Language.
T-SQL gives a high degree of control to programmers.
It is a natural programming language that blends easily with the SQL
T-SQL performs best with Microsoft SQL server
PL-SQL performs best with Oracle database server.
It is easy and simple to understand.
PL-SQL is complex to understand.
T-SQL allows inserting multiples rows into a table using the BULK INSERT statement.
PL/SQL supports oops concepts like data encapsulation, function overloading, and information hiding.
SELECT INTO statement used in T-SQL
INSERT INTO statement must be used in PL/SQL
In T-SQL NOT EXISTS clause used along with SELECT statements.
In PL/SQL, there is a MINUS operator, which could be used with SELECT statements
Difference between SQL and T-SQL
SQL
T-SQL
SQL is a programming language which focuses on managing relational databases.
T-SQL is a procedural extension used by SQL Server.
This is used for controlling and manipulating data where large amounts of information are stored about products, clients, etc.
T-SQL has some features that are not available in SQL. Like procedural programming elements and a local variable to provide more flexible control of how the application flows.
SQL queries submitted individually to the database server.
T-SQL writes a program in such a way that all commands are submitted to the server in a single go
The syntax was formalized for many commands; some of these are SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
It also includes special functions like the converted date () and some other functions which are not part of the regular SQL.

[digitalbizway]

Dear venkat, u just made it very clear. Tq. One question: If STANDARD SQL is ANSI is there any standard ANSI DB also . If so what is it please.

[ATruePatriot]

This video is really clear and easy to understand!

[israelfxp]

Este video es muy bueno para personas que incursionan en el mundo de las Base de Datos... Excelente!

[basheeral-momani]

thanks vankat for your channle
I remember me 5 years aga watching and watching
I there any tutorial about Vertica DB (colomn orianted DB, for big date and analytics)