The Pacific Northwest data groups continue to collaborate on bringing you great content. Different teams take turns hosting virtual the monthly meetings. The plan is one “evening” meeting on the 2nd Wednesday of the month at 4 PM PST, and a second meeting on the 4th Wednesday of the month at 12 PM PST.
This week Kevin Feasel presents Perfectly Normal: An Advanced Primer on Normalization.
We are now using Teams. Meeting link provided as part of registering.
Register now for Wednesday, April 13th @ 4pm meeting.
In order to encourage questions during the presentation, we want people to use the raise hands option in Teams. Please be mindful of the other attendees.
Schedule (may be fluid):
4:00 – 4:15 PM – Announcements and other information
4:15 – Presentation
Our sponsors provide gifts each month
Title: Perfectly Normal: An Advanced Primer on Normalization
Most of us have heard of “third normal form” and treat it as a goal to achieve. In this talk, we will treat third normal form as a speedbump. Let’s get deeper into the concepts of database normalization and understand the types of data problems we can solve with more advanced normal forms. This talk will briefly cover first normal form as the foundation and then show how to move from first to Boyce-Codd Normal Form. From there, we will look at 5th and 6th normal forms, as well as intermediate steps along the way. We will conclude with a discussion of where things are generally “good enough.”
Presenter Bio: Kevin Feasel
Kevin Feasel is a Microsoft Data Platform MVP and Engineering Manager of the Predictive Analytics team at ChannelAdvisor, where he specializes in T-SQL and R development, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.