SQL Commands- Part-5 (TCL and DQL)

1) https://youtu.be/G7W4HTkP534 DCL-Data Control Language-Part-4 2) https://youtu.be/ZlHnubPEQe8 DML- Data Manipulation Language Commands)- Merge 3) https://youtu.be/COcAAySIzP0 DML- Data Manipulation Language Commands(Insert, Update, Delete) 4) https://www.youtube.com/watch?v=GUHItJCbV3U DDL- Data Definition Language Commands(create, alter, drop, truncate, rename) 5) https://www.youtube.com/watch?v=Hr0I4Sn1ABE&t=236s Introduction to Types of SQL Commands This video describes TCL-Transaction Control and DQL-Data Query Language Command DML these two types of commands. Commit, Rollback, Savepoint these TCL commands and Select DQL command. These commands are described with their syntax and examples. This describe following: How to permanently store transactions and their results (single or multiple transactions at a time), how to cancel previously executed transactions, how to temporarily save transactions and their results. Also how to select data from database. All this is explained with syntax and various example like student database, company database, etc.