In a typical system data is somewhat normalized – not all of the system's data exists in one large table or list. Instead data exists in sets of tables or lists which have one entry for each entity across multiple tables.
Hands-On Labs
Lists and Schema Lab
In this lab you will work with some of the new capabilities Microsoft added to events in Windows SharePoint Services '14' as well as the new Visual Studio 2010 SharePoint Tools. You will first create a custom list definition, template and instance using Visual Studio 2010. Next, you will implement referential integrity between two SharePoint lists so that items in one list cannot be deleted until referenced items in a child list are first removed so there are no orphans. Finally, you’ll create a synchronous event receiver that is triggered when new sites are created and, when certain criteria are met, you’ll cancel the error and redirect the user to a custom application page for more information on the error.
Videos
Introducing SharePoint Lists and Schemas
Introducing SharePoint Lists and Schemas
New and Improved Events
In SharePoint 2010 SPListEventReceiver allows you to track events, including when a list is added. SPWebEventReceiver allows you to track web events including webs being added and sites and webs being deleted.
List Relationships and Joins
The SharePoint lookup field allows you to connect an identifier of one list and to display a different, friendlier field – such as name – for users to select. SharePoint 2010 adds the ability to create additional columns which display other fields from another list. In the case of a customer, it is possible to create a lookup on the ID of the other list and not only display the customer name but to also bring across multiple other fields.
Large List Support
SharePoint 2010 has support for very large lists of up to 50 million items. With this expanded list size comes the ability to throttle and control how much data is returned to the user and prevent large queries from compromising the SharePoint farm.
Field and List Item Validation
SharePoint supports the ability to create Excel like field validation formulas to validate field data in a list. This greatly reduces the amount of custom code that a developer must create and deploy.