Data Modeling Scenarios and Best Practices


(this is an on-demand video)

Sponsored by - IDERA

Webcast Abstract

In this session we'll look at typical data models used for relational databases whether for transactional systems or warehousing solutions. We'll also consider cases where non-relational solutions provide a better option and how we ultimately bring that back into a relational model for reporting and analysis. As a result, we'll look at the power of the Entity-Relationship model along with best practices for normalization. We'll also cover when denormalization makes sense, which is often the case in warehousing models like with star and snowflake schema.

Speaker - K. Brian Kelley

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.




More SQL Server Solutions












download





get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools