Database | Insert, Update, Delete, Truncate - SQL Beginners Series p.2

This Basic SQL Tutorial will help you learn step by step Structured Query Language (SQL) with simple examples using SQL Server, which will be helpful if you are a beginner and looking for a career as SQL Developer or if you want to use it in your academic.

In last session we have gone through the SQL basics with the concepts of creating database and tables, select query and different filter criteria using WHERE clause and operators.

Please watch Part1 of this tutorial at    • The Basic Statements & Installation - SQL ...  

Following topics has been covered in this SQL Tutorial Video:
00:00 Introduction
01:00 INSERT Data into a table
01:11 INSERT INTO statement
06:17 INSERT INTO SELECT statement
11:02 SELECT INTO statement
15:31 UPDATE data in a table using UPDATE statement
15:54 UPDATE one column value in a table
17:33 UPDATE multiple column value in a table
19:15 UPDATE FROM statement
20:57 DELETE data in a table using DELETE statement
24:12 TRUNCATE data in a table
25:21 Difference Between DELETE and TRUNCATE
------------------------------------------------------------------------
Train Me Buddy - Links for resources:

SQL Server:
https://www.microsoft.com/en-in/sql-s...

SQL Server Management Studio (SSMS):
https://learn.microsoft.com/en-us/sql...

SQL Scripts used in this training @ Github repository:
https://github.com/trainmebuddy/Basic...

------------------------------------------------------------------------
Thanks for watching! Hope this tutorial is useful for you!

Please like, share and don’t forget to subscribe the channel @trainmebuddy and hit on the bell icon so that you will be notified about the upcoming new videos!

If you have any doubts or suggestions, please feel free to put it on the comment! Thank you! :)

------------------------------------------------------------------------
#SQLInsertUpdateDeleteTruncate #SQLProgramming #BasicSQL #SQLServer #TSQL #LearnSQL
#BasicSQLTutorialForBeginners #SQLServerWithSimpleExamples #SQLServerBasics #SQLCommand #SQLQuery #trainmebuddy
#siddharthpatra #learnsql #sql #sqlprogramming #sqlbasics #sqltraining #sqlinterview #structuredquerylanguage #sqlinterview #sqlinterviewquestions #sqlinterviewquestionsandanswers
------------------------------------------------------------------------