SQL #11- Primary Key & Foreign Key Function in SQL in Tamil | SQL Tutorials in Tamil

#MSSQL# #PRIMARYKEY# #FOREIGNKEY#

This tutorial will help you to learn How to create primary key & foreign key in SQL from scratch to advanced level in Tamil. Explained step by step in tamil.

Points are covered in this video:-

How to create primary key?
How to create foreign key?
How to use primary and foreign key?
The purpose of primary key & foreign key in sql?

Covered these points in the previous 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

How to user insert command?
How to use update command?
How to use delete command?

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 Videos in Tamil  

Power BI Tutorials -    • Power BI Tutorials in Tamil  

VBA Macros Step by Step Video -    • VBA Macro Step by Step Videos  

Source File - https://meet.google.com/ain-vxwk-uqu

Shorts -    • Shorts  

Excel Interview Questions and Answers -    • Excel Interview Questions and Answers  

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 - [email protected]

Please subscribe, like, commend and share it with your friends.