Take the tour ×  I'm talking about this blog post by Chris
Woodill. He mentions the following advantages of modeling data
via SQL programming instead of SharePoint's lists:    1. Primary
And foreign keys: one of the most basic concepts in a database
is the enforcement of a unique identifier (either system
generated or user supplied) that can identify a record and link
across table in parent child relationships.   2. Transactions:
if two changes are required to go together and the second change
fails you want the first change to be undone (rolled back).   3.
SQL language: complex queries can me written in code using a
standard language. Queries can be saved and repurposed.   4.
Stored procedures: database programmers can write complex
routines that can be called as reusable code blocks.   5.
Indexing and query optimization: used to improve performance,
indexing allows the database designer to pre-index specific
fields     that are frequently used in queries to improve
performance. In     addition, most