Customer Reviews

SQL Server Fundamentals for the Accidental DBA LiveLessons (Video Training)

5 star:		(0)
4 star:		(1)
3 star:		(0)
2 star:		(0)
1 star:		(0)

 

 

The video lessons are concise and useful in helping you get a quick overview of managing a SQL Server database. Of necessity, you should also have at least 1 full text on the subject, as the videos do not attempt to cover all the low level details of administration.

Of the various lessons, one of the most cogent was #8, about understanding relationships, that you then use to make tables and dependencies between tables. It argues a point that is often not sufficiently emphasised in some texts. A spreadsheet, like Excel, but really it could be any spreadsheet, can be used to enter simple tabular information, with connections between cells that define interrelationships. But at some point these connections become too intricate for the data to be usefully expressed as one spreadsheet [=table]. Here is where a transition to a fully fledged relational database is often needed. Especially to tie different tables together. It is how to understand when to make this transition, and then how to design the related tables, that SQL Server can be used.