Welcome to the April 13th 2022 online meeting! Covid restrictions are lifting and a return to in-person meetings may take shape in the coming months. Until then, we all continue to operate monthly online meetings through the PNW collaborative facilitated by the Oregon Data Community. A number of NW local data user groups are working together to help shoulder the load over covid, hosting regular online monthly meetings for all members. The collaborative will always have the regular OR Data Community “evening” meeting date/time on the 2nd Wednesday of the month at 4 PM PST, and if possible a second meeting on the 4th Wednesday of the month at 12 PM PST!
We are now using Teams! The meeting link will either be revealed via meetup when you RSVP, or be published closer to the meeting date.
In order to encourage questions during the presentation, please use chat which will be monitored and/or use the raise hands option in Teams. Please be mindful of the other attendees and mute your mic!
We will be starting at 4:00 PM
Schedule (may be fluid due to discussions and Q/A):
4:00 – 4:15 PM – Announcements and other information
4:15 PM – Presentation
Our wonderful sponsors are providing 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.”
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.