SQL Server - Integrity, CASE Statements And Case Studies | JanBask Training
**** SQL Server Training: https://www.janbasktraining.com/onlin... ****
In this video, our main agenda is to discuss these following topics:
Data Integrity and Normal Forms ?
✅Tables with Keys & Constraints (BCNF) ?
✅NULL and IDENTITY Properties – Usage?
✅UNIQUE KEY Constraint and NOT NULL?
✅PRIMARY KEY Constraint & Importance?
✅FOREIGN KEY and REFERENCE Attributes?
✅CHECK and DEFAULT Constraints, Usage?
✅Duplicating Identity Property Values?
✅Disabling Constraints & Different types of Keys?
This video of SQL server training session by JanBask Training teaches you about the concepts of-
● SQL Normality- a feature that helps you minimize potential errors when working with data.
● SQL Integrity- consistency and accuracy of the data which is stored in your database.
● SQL Constraints- constraints that you put for the type of data entering your database.
The video then talks about the concept of normalization detail covering the several types of Normalizations such as-
● First normal form
● Second normal form
● Third normal form
● Boyce and Codd normal form
After discussing the types of Normalization with examples the video teaches you about Anomalies that occur when you don’t normalize your data and how you can fix them with elaborate examples.
The video then goes on to discuss the concept of Data Integrity in detail covering the types of Data integrity. The video highlights the following kinds of data integrity-
● Entity Integrity
● Domain Integrity
● Referential Integrity
● User-defined Integrity
The video then talks about the concept of Data constraints which means the rules that you put to maintain data consistency. The following types of constraints are discussed-
● Not Null Constraint
● Default Constraint
● Unique Constraint
● Check Constraint
● Primary Key Constraint
● Foreign Key Constraint
After that, the video discusses the term called SQL Keys, its definition and types. SQL key is a single or combination of multiple files in a table. There are following types of keys-
👉🏻Super Key
👉🏻Candidate Key
👉🏻Primary Key
👉🏻Alternate Key
👉🏻Composite Key
👉🏻Unique Key
👉🏻Foreign Key
Contact Us to Know more about the SQL Server Training, or you can enroll in the SQL Server Testing live classes at our website -
https://www.janbasktraining.com/onlin...
SQL Tutorial Blog – https://www.janbasktraining.com/blog/...
Facebook: / janbasktraining
Twitter: / janbasktraining
LinkedIn: / janbask-training
#SQL_Training #SQL_Tutorials #SQL_Server_Training