SQL | Difference Between Union Vs Union ALL | Delete Vs Truncate | SQL Interview Questions

In this tutorial, we see the difference between the below SQL statements -
Union Vs Union ALL
Delete Vs Truncate
SQL - Difference Between NOT IN and NOT EXISTS
• Avoid this SQL Program...
SQL - Difference Between AND and WHERE
• Avoid this SQL Program...
How to install SQL Server for practice?
• How to install SQL Ser...
Check out the complete list of SQL Query Interview Questions -
• SQL Query Interview Qu...
Must Do Data Analytics Certifications -
Google Data Analytics Professional Certificate
imp.i384100.ne...
Google Advanced Data Analytics Professional Certificate
imp.i384100.ne...
Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization
imp.i384100.ne...
Beginners to Python Programming
skillshare.eqc...
Data Science and Business Analytics with Python
skillshare.eqc...
IBM Data Science Professional Certificate
imp.i384100.ne...
Data Science Fundamentals with Python and SQL Specialization
imp.i384100.ne...
Python for Everybody Specialization
imp.i384100.ne...
Google Data Analytics Professional Certificate
imp.i384100.ne...
Coursera Plus - Data Science Career Skills
imp.i384100.ne...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Instagram - / learn.knowstar
Blog - know-star.blogs...
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - [e-mail]

[@LearnatKnowstar]

Hope this video is useful. Here are two more similar videos - SQL - Difference Between NOT IN and NOT EXISTS kzbin.info/www/bejne/m2mcaXeul753hKM SQL - Difference Between AND and WHERE kzbin.info/www/bejne/m2mcaXeul753hKM

[@madhusudhanreddyt2838]

Delete and Truncate both operations work with tcl commands. We can roll back the data when performing a delete operation and also, we can roll back the data when performing the truncate operation.

[@RassiqueMukkarram]

Simply superb 👍

[@LearnatKnowstar]

Thank You!

[@amanbodele1616]

Ma'am i watched your SQL concepts videos now i jumped into this interview question series so i want to ask you that is this playlist enough for me to getting into it companies or do i need to figure out any other resources plz guide me plzzz

[@LearnatKnowstar]

Practice the queries in the playlist. It will build your concepts. Once you are done with the playlist , you can try solving queries on leetcode as per your skill level.

[@sandhyarani2342]

Hi mam i have been watching your videos which are very helpful for me. Could me please tell me that work from home jobs are there for database developer ordata analyst

[@LearnatKnowstar]

Thank you. Hybrid jobs - few days wfh few days work from office are easier to find. But at the same time remote jobs are getting more popular so be hopeful.

[@sandhyarani2342]

Tq mam😊

[@maheshbabu1455]

your videos are so good but if provide notes or document of pdf its so useful for us

[@LearnatKnowstar]

Sure. We try to provide notes for most of the videos.

[@madhusudhanreddyt2838]

truncate can reset the identity of a column where as delete operation cannot reset the identity of a column delete command can be used in a indexed view where as truncate command cannot be used with indexed view delete is slower than the truncate command triggers can be actived on the table and can be fired when using the delete command where as triggers cannot be activated on the table when using the truncate table command truncate issues a table lock where as delete issues a row lock to perform truncate operation we need to atleast have alter permissions on the table where as to perform the delete operation we need to have the delete permissions on the table truncate is a ddl command which is used to delete all the records from a table whereas delete command can be used to delete all the data or delete the data based on a condition using the where clause delete command is going to delete the records, one row at a time on row by row bases where it is going to record an entry into the transaction log for each of the deleted row where as truncate table deletes the data by deallocating the data pages used to store the table data.. it will record only the deallocation pages to the transaction log.. truncate has less transaction log spaces where as delete has more transaction log spaces..