SQL #7 - SQL Sub-Languages DDL, ALTER, DROP, TRUNCATE in SQL in Tamil | SQL Tutorials in Tamil
HTML-код
- Опубликовано: 12 мар 2024
- #MSSQL# #ALTER# #DROP# #TRUNCATE#
This tutorial will help you to learn SQL from scratch to advanced level in Tamil. Explained step by step in tamil.
Points are covered in this video:-
How many types of SQL Sub-Languages?
How to user Alter Command?
How to change datatype and also size of the datatype
How to add a new column to the table
How to change a column name
How to drop the unwanted columns from table
ALTER - SUB COMMANDS
- ALTER COLUMN
- ALTER ADD
- SP_RENAME
- ALTER DROP
- TRUNCATE
To delete all rows from table at a time
We can’t delete a specific row from the table
It doesn’t support “Where” Keyword Condition
- Drop Table
To delete the table
The purpose of different sub-Languages?
What is DDL?
What is DMS?
What is DRL?
What is TCL?
What is DCL?
How to create new database in SQL?
How to create new table in SQL?
How to create table in difference interface?
Points are covered in previous video:-
How to connect to server by using Windows Authentication & New Database in Tamil?
Different types of way to connect to SQL Server?
How to work with SQL?
How to connect to SSMS?
What is SSMS?
Different Server Types?
Server Name & Authentication
What is SQL in Tamil?
What is database?
How to create database in SQL?
What's UI interface?
What is GUI interface in Tamil?
What is CUI interface in Tamil?
Why MsSQL is important?
What are SQL commands?
MS Excel Videos - • Ms Excel Step by Step ...
Power BI Tutorials - • Power BI Tutorials in ...
VBA Macros Step by Step Video - • VBA Macro Step by Step...
Source File - meet.google.com/ain-vxwk-uqu
Shorts - • Shorts
Excel Interview Questions and Answers - • Excel Interview Questi...
Thank you for reaching out to my channel. I will also provide weekend support on the below topics
Ms Excel, Ms Word, VBA, Power Point, Power BI
Email ID - Krishsexcelanywhere2020@gmail.com
Please subscribe, like, commend and share it with your friends. - Наука
Very clear and useful 🎉 Thank you for sharing 😊
Thank you👍
Very clear explanation 🎉
Thank you👍
Nice👍
Thank you👍
Once you've finished the SQL video series, could you please create a video on integrating SQL with PowerBI? It would be incredibly helpful. Demonstrating how to build dashboards in PowerBI using SQL, similar to what you've done with Excel, would be fantastic. Thanks again for sharing your knowledge!
Certainly, that's our vision 🏆