Скачать с ютуб 11. Transaction Control Language (TCL) in SQL| What is Commit and Rollback in SQL by Pandey Guruji в хорошем качестве

11. Transaction Control Language (TCL) in SQL| What is Commit and Rollback in SQL by Pandey Guruji

Download Complete SQL Training Materials: https://imojo.in/sqlpandeyguruji ------------------------------------------------------------------------------------------------------------------------------------------ This Video contains In-depth coverage of Transaction Control Language (TCL) in SQL. Covers all of the important queries and SQL commands of Commit and Rollback. You'll learn how to read and write complex queries. Handle tricky SQL interview questions. Implement complex SQL queries and answer popular interview questions on SQL. This Video will help to get jobs in SQL Developer, Database Developer, Data Engineer, Reporting Analyst, Data Analyst, Data Scientist, System Analyst, Power BI Developer, Tableau Developer, BI Developer, etc. ----------------------------------------------------------------------------------------------------------------- Are you someone who is looking for Real-time training, visit https://pandeyguruji.graphy.com/ and join for free training materials, Link: https://bit.ly/30vrk1W For any query Contact me on social media: Facebook :   / mpandeyguruji   Instagram:   / pandey_guruji   Linkedin:   / mukesh-pandey-1a151634   ------------------------------------------------------------------------------------------------------------------- SQL Tutorial for Beginners in Hindi: https://bit.ly/3CwfnGB SQL Tutorial for Beginners in English: https://bit.ly/3qVI3GQ SQL Live Training: https://bit.ly/3kXqOl1 Crack SQL Interview: https://bit.ly/3caxIyb SQL Interview Questions: http://bit.ly/2CR6wCZ Advance SQL Interview Questions: https://bit.ly/3HnMrnN Career Guidance: https://bit.ly/3FffkRf IT Technology News & Updates: https://bit.ly/3FeNQvc -------------------------------------------------------------------------------------------------------------------- --TCL --Commit --Rollback --drop table DimCustomerdup Select * into DimCustomerdup from DimCustomer Select * from DimCustomerdup --without BEGIN TRANSACTION update DimCustomerdupnew Set YearlyIncome = 60000 Rollback --with BEGIN TRANSACTION Select * from DimCustomerdup BEGIN TRANSACTION update DimCustomerdup Set YearlyIncome = 50000 Rollback BEGIN TRANSACTION update DimCustomer Set YearlyIncome = 90000, middlename = 'xyz', MaritalStatus = 'M' Where CustomerKey = 14632 Rollback Commit BEGIN TRANSACTION update DimCustomer Set YearlyIncome = 80000 Where CustomerKey = 11000 Rollback Commit #Call_Now_8309569513_Realtime_One_to_One_Training