SQL | Difference Between Union Vs Union ALL | Delete Vs Truncate | SQL Interview Questions
HTML-код
- Опубликовано: 8 сен 2024
- 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 - learn@knowstar.org
Hope this video is useful. Here are two more similar videos -
SQL - Difference Between NOT IN and NOT EXISTS
ruclips.net/video/e898DxbYDNA/видео.html
SQL - Difference Between AND and WHERE
ruclips.net/video/e898DxbYDNA/видео.html
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.
Simply superb 👍
Thank You!
your videos are so good but if provide notes or document of pdf its so useful for us
Sure. We try to provide notes for most of the videos.
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..
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
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.
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
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.
Tq mam😊