Primary Key and Foreign Key Constraints | Microsoft SQL Server | Database Design | Data Science
#sqlserver #sqlforbeginners #sqlab #database #databasesystems #sql #sqltips #databaseconcepts #databases #databaseprogramming #databasedevelopment #databaseadmin #ssis #ssms #indexing #backupdata #sqlinterviewquestions #sqltraining
Primary Key and Foreign Key Constraints | Microsoft SQL Server | Database Design | Data Science
In this video, we have discussed about Primary Key Constraints and Foreign Key Constraints. We have talked about restrictions applicable on both types of constraints. We then talked about Indexes on Foreign Key Constraints, talked about referential integrity. We discussed on Cascading Referential Integrity. Finally we contrasted between triggers and cascading referential actions. Finally we covered the following practicals/demos:
DEMO : How to create Primary Key using SQL Server Management Studio?
DEMO : How to create a Primary Key in an existing table using Transact-SQL?
DEMO : How to create a Primary Key in a new table using Transact-SQL?
DEMO : Create a nonclustered Primary Key with separate clustered index in a new table?
DEMO : How to modify a primary key?
DEMO : How to delete a primary key constraint using Object Explorer in SSMS?
DEMO : How to delete a primary key constraint using Table Designer in SSMS?
DEMO : How to delete a primary key constraint using Transact-SQL?
My Channel Page : / @masterdatasciencewithvineet
SQL Server Database Design Playlist : • SQL Server - Database Design Video Li...
Business Continuity Playlist : • SQL Server - Business Continuity
SQL Server Indexing Playlist : • SQL Server - Indexes
SQL Server Performance Tuning Playlist : • SQL Server - Performance Tuning
SQL Server Integration Services Playlist : • SQL Server Integration Services
SQL Server Tables Playlist : • SQL Server - Tables
Database Administrator
SQL Server Database Administrator
Database Developer
SQL Server Database Developer
Data Analyst
SQL Server Data Analyst
BI Developer
SQL Server BI Developer
Data Scientist
SQL Server Data Scientist
Data Science
IT Manager
SQL Server Jobs
Data Engineer
Solution Architect
ETL Developer
