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.
Wednesday, January 23, 2019
8:00:00 PM UTC | 3:00:00 PM EST
K. Brian Kelley is a SQL Server author, columnist, and Microsoft MVP focusing primarily on SQL Server and Windows security. In addition to being a database administrator, he has served as an infrastructure and security architect encompassing solutions with Citrix, virtualization, and Active Directory. Brian is also a Certified Information Systems Auditor (CISA) and has been the head of a financial organizationís computer incident response team. Brian is active in the IT community having spoken at DevConnections, SQL Saturdays, code camps, and user groups. He is also the President of the Midlands PASS Chapter, a Professional Association for SQL Server Chapter located in Columbia, SC.
Register for this webinar:
Copyright (c) 2006-2018 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.