Sql vs tsql vs plsql

  Рет қаралды 92,279

kudvenkat

kudvenkat

Күн бұрын

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
csharp-video-tutorials.blogsp...
SQL Server Tutorial for beginners
• SQL Server tutorial fo...
SQL Server Interview Questions and Answers
• SQL Server Interview Q...
SQL Server Performance Tuning and Query Optimization
• SQL Server Performance...

Пікірлер: 92
@adds-kz3oc
@adds-kz3oc 3 жыл бұрын
This man is the reason I have a job
@marconagel3018
@marconagel3018 3 жыл бұрын
He is really amazing, God bless him and his whole family.
@Melodychoice601
@Melodychoice601 3 жыл бұрын
Very true, same here. Thanks venkat
@googdriveforme4115
@googdriveforme4115 3 жыл бұрын
Great..
@Vaibhavmali_
@Vaibhavmali_ 3 жыл бұрын
Bro . In this which is best for learning SQL- oracle , sql server , mysql etc
@mahmoudsayed9866
@mahmoudsayed9866 2 жыл бұрын
after allah .. everything we have is from allah first
@bezaar7762
@bezaar7762 3 жыл бұрын
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 .
@lazykitten4356
@lazykitten4356 3 жыл бұрын
same here!
@harshitagupta5009
@harshitagupta5009 Жыл бұрын
same here
@cuquat7225
@cuquat7225 Жыл бұрын
Great!
@muraliraj9658
@muraliraj9658 Жыл бұрын
Thanks Guru, with your videos help only I have moved from non-technical to technical...lots of respect..
@abhishekmd3282
@abhishekmd3282 3 жыл бұрын
Thank you for such a Wonderful information :-) Expecting more videos like this.
@sherifezzat4983
@sherifezzat4983 3 жыл бұрын
You are the best, Kenvat!! 😍
@vijaybalraj6913
@vijaybalraj6913 2 жыл бұрын
Was having confusion, now clear.. Thanks Venkat...
@abidzohri3336
@abidzohri3336 3 жыл бұрын
Thnx alot sir to Explain the folks like me who dont even know the basics difference of that thnx alot sir
@user-wu5zo1th5o
@user-wu5zo1th5o 5 ай бұрын
u r explanation clears my long time confusion venkat.thanks now i become ur subscriber.
@ganeshmudkhede6206
@ganeshmudkhede6206 3 жыл бұрын
Good to see you Sir after long time.... I fallow your learnings
@marconagel3018
@marconagel3018 3 жыл бұрын
You are an inspiration for programmers and engineers, thanks for all bro, God bless you!
@praveenkumar-yf5qd
@praveenkumar-yf5qd 3 жыл бұрын
Best explanation.... thanks for clearing my doubt
@namojuvijaykumar
@namojuvijaykumar 2 жыл бұрын
Very useful and easy to understand. Thank you
@israelfxp1809
@israelfxp1809 3 жыл бұрын
Este video es muy bueno para personas que incursionan en el mundo de las Base de Datos... Excelente!
@zongoboy
@zongoboy Жыл бұрын
Man is an impact to the universe, I am teaching for free in Africa, and this has been my teacher
@pramodmaurya6610
@pramodmaurya6610 3 жыл бұрын
Your are the best teacher...i have ever seen..god bless you..
@ATruePatriot
@ATruePatriot 2 жыл бұрын
This video is really clear and easy to understand!
@optimistic_guy313
@optimistic_guy313 2 жыл бұрын
Thanks for clearing this !
@nishantkumar681
@nishantkumar681 2 ай бұрын
Thanks Man, You are here that is why we are doing job as a Developer
@sivanelly6473
@sivanelly6473 Жыл бұрын
My favorite channel..excellent teaching style..superb voice
@mlkhjz
@mlkhjz 6 ай бұрын
The only person who describes T-SQL clear! Thanks 🙏
@roopalsharma1732
@roopalsharma1732 2 жыл бұрын
Thank you so much. You are THE BEST ❤️
@cmjasti
@cmjasti 7 ай бұрын
Super..Nice explanation.I appreciate the way you teach..God bless you..
@victorolivo5168
@victorolivo5168 2 жыл бұрын
Awsome explanation, Thanks!
@digitalbizway9
@digitalbizway9 3 жыл бұрын
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.
@guleenergy3402
@guleenergy3402 3 жыл бұрын
It's very clear and helpful.
@geletawadank8391
@geletawadank8391 3 жыл бұрын
You are more than words. God bless you
@afonsoosorio2099
@afonsoosorio2099 Жыл бұрын
Awesome 👌, Pure Gold. You are a Legend 🙌 👏 ❤
@shanmukhapatil7131
@shanmukhapatil7131 3 жыл бұрын
You are awesome sir .... Thanks ...
@shammo2011romit
@shammo2011romit 3 жыл бұрын
Extremely well explained.
@2784raj
@2784raj 3 жыл бұрын
Hi, venkat sir, I am following you each video series and they are helping me to understand and learn new skills, Here is request you to make tutorial on ASP. NET CORE WEB API AND JWT TOKEN
@basheeral-momani2032
@basheeral-momani2032 2 жыл бұрын
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)
@saitama8506
@saitama8506 Жыл бұрын
This video is very helpful. Thanks
@geletawadank8391
@geletawadank8391 3 жыл бұрын
You are always great!
@saurabhSql
@saurabhSql 3 жыл бұрын
Would love to watch your tutorials on MSBI and Power BI...
@rasmipravasingh5114
@rasmipravasingh5114 3 жыл бұрын
Sir thank you so much for providing such best tutorial.can you please provide msbi tutorials.
@VCKLYTech
@VCKLYTech 3 жыл бұрын
Good info. Thank you.
@SwaroopBhosale
@SwaroopBhosale Жыл бұрын
very nicely explained
@rishiyogil.n.7222
@rishiyogil.n.7222 5 ай бұрын
well explained thanks man
@xxUnd3rtoWxx
@xxUnd3rtoWxx 2 жыл бұрын
He visto la luz, muchas gracias.
@shanmukhapatil7131
@shanmukhapatil7131 3 жыл бұрын
Please do a video on learning programming... What all steps we need to follow to become like you expert in dot net. Please do video series on ajax controls How to use jQuery plugins ... Thanks 😊
@zealtypedcode3119
@zealtypedcode3119 3 жыл бұрын
Would be grateful if you done a tutorial series about micro-service rabbit MQ or Apache kafka
@SheikhMuhammadNawaz
@SheikhMuhammadNawaz 2 жыл бұрын
Very great information.
@rizwanriz7455
@rizwanriz7455 3 жыл бұрын
You are legend mate!!
@chironpallas
@chironpallas 2 жыл бұрын
Brilliant thank you
@itspraveenkp1960
@itspraveenkp1960 3 жыл бұрын
Ohh sir❤️
@AmitSingh-er3lk
@AmitSingh-er3lk 2 жыл бұрын
You are simply amazing....
@Aquoipakoi
@Aquoipakoi 3 жыл бұрын
clear, ty !
@brijenderkumardogra7343
@brijenderkumardogra7343 3 жыл бұрын
Thanks Bro...
@mauriciolaurel2122
@mauriciolaurel2122 10 ай бұрын
Good video!
@husseinhadliye2992
@husseinhadliye2992 Жыл бұрын
Hi @kudvenkat thanks for the video it was really helpful, but I have a question U said the MS SQL server has T/SQL and Oracle has PL/SQL so what kind of variant does MYSQL have?
@minukumariyadav3006
@minukumariyadav3006 Жыл бұрын
SQL
@AspireTechPulse
@AspireTechPulse 2 жыл бұрын
Hi venkat sir, i want SSIS tutorial for biginners
@Pragya3421
@Pragya3421 3 ай бұрын
There is lot of different in your voice when I watch your 10 Yrs old video and this one 🤣🤣
@seshulatha
@seshulatha 5 ай бұрын
Where do u stay Venkat garu….you r awesome 🎉
@Dev-Phantom
@Dev-Phantom 2 жыл бұрын
love this
@mahendrarajahpraveen4515
@mahendrarajahpraveen4515 2 жыл бұрын
PL SQL Is different from SQL but u mentioned we use that to query Oracle DB. PL SQL can be used to any DBs to create functions & triggers so on plz correct me If am wrong
@AmitSingh-jx8rl
@AmitSingh-jx8rl 3 жыл бұрын
sir Ur awesome
@vasaripraveenreddy5268
@vasaripraveenreddy5268 Жыл бұрын
than you
@omkaaaar
@omkaaaar 3 жыл бұрын
Could you please start MSBI / Power BI please ?
@kave_08
@kave_08 3 жыл бұрын
That's awesome
@nithiyaparamaraj5762
@nithiyaparamaraj5762 2 жыл бұрын
Super...
@sairamprabhu9712
@sairamprabhu9712 3 жыл бұрын
Super
@rakeshthakur9403
@rakeshthakur9403 3 жыл бұрын
Nice video
@pragyachauhan5537
@pragyachauhan5537 2 жыл бұрын
Which programming languages should one use with SQL?
@ABHISHEKSINGH-gu8wl
@ABHISHEKSINGH-gu8wl Жыл бұрын
SQL has different usage, it only deals with data sets. Though we can only import and export and use it with sheet tools like Excel, tableau etc.
@FarrukhSaleemSheikh
@FarrukhSaleemSheikh 3 жыл бұрын
👍
@akshay2983
@akshay2983 3 жыл бұрын
Sir plz do videos on ssrs ssis ssms..cube deployment, data warehousing, ETL.
@nireeshagavara8611
@nireeshagavara8611 2 жыл бұрын
if created ,can anyone provide me the PL-SQL videos link .
@pramodhthota5621
@pramodhthota5621 3 жыл бұрын
Hello sir, could you pls start Python programming course pls
@sankalpasarkar3540
@sankalpasarkar3540 3 жыл бұрын
👍🏽👍🏽👍🏽👍🏽
@wellwisher6728
@wellwisher6728 3 жыл бұрын
Sir,could you please start python programming course?
@abdih
@abdih 2 жыл бұрын
hello!! what about pgsql ?
@theMagos
@theMagos 3 жыл бұрын
Why hasn't more effort been put into making a completely standard and uniform sql across all db-systems? Imagine writing a program where the choice of db-system is completely transparent. Way back when we supported both Access and SQL Server, we had to make lots of special cases and exceptions in our code to handle both.
@esayiyasmengistu5516
@esayiyasmengistu5516 3 жыл бұрын
good
@gagandeepsingh6126
@gagandeepsingh6126 3 жыл бұрын
Sir can u pls make videos on SQL server performance turning?
@Csharp-video-tutorialsBlogspot
@Csharp-video-tutorialsBlogspot 3 жыл бұрын
Hello Gagandeep - Absolutely, SQL Server Performance Tuning is on my next to do items. Thank you for the great suggestion.
@NIRMALA-ts6pf
@NIRMALA-ts6pf 3 жыл бұрын
​@@Csharp-video-tutorialsBlogspot Yes sir, I attended few interviews. in that almost they are asking about SQL performance turning with real-time examples? what are the methods have you used for performance turning?
@Csharp-video-tutorialsBlogspot
@Csharp-video-tutorialsBlogspot 3 жыл бұрын
Hi Nirmala & Gagandeep - SQL Server Performance Tuning and Query Optimization discussed in the following playlist. Hope you will find it useful. I will add more videos. If you have specific concepts on mind, please leave them as comments and I will record and upload. All the very best. kzfaq.info/sun/PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0
@gagandeepsingh6126
@gagandeepsingh6126 3 жыл бұрын
Hi@@Csharp-video-tutorialsBlogspot , Please make videos on Physical operators like 1. Physical Joins(e.g. Nested Loop, Merge Join, and Hash Join) 2. Lazy Spool 3. Filtered Index 4. ColumnStored index and its types 5. Diff b/w composite index and Index with Include keyword in Index structure and How logically they are different and work. 6. Stats(histogram) in SQL Server and how they are helpful for the execution plan. 7. Partitioning of SQL Table. 8. Stream Aggregation, Table spool, Compute Scalar, Assert, etc physical operator in SQL Server. 9. Full-Text index 10. XML index and their types. 11. Degree of parallelism(DOP) etc.
@NIRMALA-ts6pf
@NIRMALA-ts6pf 3 жыл бұрын
@@Csharp-video-tutorialsBlogspot ​Thank you, Sir. I watched all your videos (from the above link playlist) but the interviewer is not satisfied. I think only Index is not a solution for this may be. They want more information and they are asking with an example like, Ex: if I have millions of records in the tables, in my query I have joined more tables so when I fire a query it is taking more than 1hour of time. how you will solve it? 1) What are the different methods/ways of query optimization and performance tuning? 2) Which method did you use in real-time projects? 3) Which method did you prefer first and why? How did you solve it? I searched in Google, got a few methods:- Sir can you please make a video with an example of a real-time project using the below ones or any other easy methods you have used in your future. a) Generate an Actual Execution Plan. b) Monitor Resource Usage. c) Use the Database Engine Tuning Advisor. d) Find Slow Queries With SQL DMVs. e) Query Reporting via APM Solutions. f) SQL Server Extended Events. g) SQL Azure Query Performance Insights Thank you...
@msdhoni6419
@msdhoni6419 3 жыл бұрын
Venkat we want node js tutorial please upload and mangodb
@siddharthapandey2711
@siddharthapandey2711 3 жыл бұрын
Hi Sir, I'm a 31 Y.O. undergraduate and unable to get a job because of my graduation status. I'm an OCA with good SQL knowledge. I'm stuck with 20K salary for the past few years. I've learnt alot from you. Please help me.
@ruhollahjafari4012
@ruhollahjafari4012 3 жыл бұрын
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.
@stefanejegod8644
@stefanejegod8644 3 жыл бұрын
This could've been explained in a single slide. SQL is the industry standard language, TSQL is Microsofts take, PL/SQL is Oracles. Look up the actual differences elsewhere? And then they chugged in some basic SQL tutorial because the video was too short I guess?
Sql function to get number from string
8:33
kudvenkat
Рет қаралды 66 М.
Creating A New Assignment - Tutor Assessment Helper Tool
7:20
TeachAllAboutIt
Рет қаралды 2
Gym belt !! 😂😂  @kauermotta
00:10
Tibo InShape
Рет қаралды 18 МЛН
这是王子儿子吗
00:27
落魄的王子
Рет қаралды 20 МЛН
لااا! هذه البرتقالة مزعجة جدًا #قصير
00:15
One More Arabic
Рет қаралды 30 МЛН
Learn SQL In 60 Minutes
56:24
Web Dev Simplified
Рет қаралды 2,1 МЛН
How do SQL Indexes Work
12:12
kudvenkat
Рет қаралды 599 М.
Difference between SQL and PL/SQL | SQL vs PL SQL | Intellipaat
8:08
6 SQL Joins you MUST know! (Animated + Practice)
9:47
Anton Putra
Рет қаралды 133 М.
Stored procedures in sql server   Part 18
20:11
kudvenkat
Рет қаралды 1,5 МЛН
Clustered and nonclustered indexes in sql server   Part 36
16:48
kudvenkat
Рет қаралды 948 М.
SQL "difference between" interview questions (part 1)
8:20
Crack Concepts
Рет қаралды 612 М.
#samsung #retrophone #nostalgia #x100
0:14
mobijunk
Рет қаралды 14 МЛН
Сколько реально стоит ПК Величайшего?
0:37
Хакер взломал компьютер с USB кабеля. Кевин Митник.
0:58
Последний Оплот Безопасности
Рет қаралды 2,4 МЛН
low battery 🪫
0:10
dednahype
Рет қаралды 1,8 МЛН
Vision Pro наконец-то доработали! Но не Apple!
0:40
ÉЖИ АКСЁНОВ
Рет қаралды 765 М.