Join Ron Davis for an in-depth discussion in this video Using constraints to enforce integrity, part of SQL Server 2014: Developing Databases.
- Using constraints to enforce integrity.…Now, before I get into that,…I'm going to do a quick word about NULL…on the off chance that you don't really…understand the concept of NULL.…Now, NULL can be in two states, that is,…any single NULL can be, as I just said, in two states,…that being unknown…or not applicable.…So, if we think, for example,…we send out a survey to building owners…and we want to know how many elevators…or, are there elevators in their buildings.…
Some of the building owners,…and we know which ones, do not respond.…So, therefore, when we said…how many elevators are in that building,…we would insert NULL.…By the way, don't get into these tricks…where people think they understand NULL…and they'll start putting in little text strings, et cetera.…You really want to limit the amount of NULLs…that you have within your database…but sometimes you have to have NULLs.…
OK, so it can be in two states:…the unknown I just described,…and other business, people that own these buildings…return the survey, but they have a one-story building.…
Author
Ron Davis
Released
11/12/2015- Working with SQL Server development tools
- Designing database tables
- Utilizing schemas with tables
- Using constraints to enforce integrity
- Understanding how SQL stores and locates data
- Designing database views
- Working with stored procedures
- Using triggers to modify data
- Creating in-memory databases
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome43s
-
-
1. Working with SQL Server Development Tools
-
Managing projects with SSMS7m 30s
-
2. Designing Data Tables
-
Reviewing database normalization11m 23s
-
Introduction to designing tables10m 27s
-
Designing tables9m 12s
-
Altering tables2m 41s
-
-
3. Understanding the Concept of Constraints
-
4. Storage and Indexes
-
How SQL stores data7m 11s
-
5. Designing Views
-
Introducing views7m 28s
-
Creating and managing views2m 38s
-
-
6. Working with Stored Procedures
-
7. Performing Data Modification with Triggers
-
Understanding triggers4m 18s
-
Utilizing triggers4m 1s
-
-
8. In-Memory Databases
-
What is in-memory?9m 45s
-
In-memory: More details7m 5s
-
Creating in-memory tables2m 15s
-
In-memory stored procedures6m 52s
-
Migrating6m 3s
-
-
Conclusion
-
Next steps1m 13s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Using constraints to enforce integrity