Database Normalization Tutorial - Modeling 3NF for OLTP
Let's take a hand's on look at modeling an OLTP, or transactional, database into third normal form (3NF). This design can take a business process and create a relational database from it, including some best practices and general concepts for normalization. Hope you enjoy this data modeling tutorial!
⏯RELATED VIDEOS⏯
Dimensional Data Model: • Dimensional Data Model Tutorial - A Kimbal...
Data Vault Model Tutorial: • Data Vault Model Tutorial - An Alternative...
------------------------------------------------------------------------------
Data Podcast ►► https://open.spotify.com/show/4PWmW2g...
Website ►► https://www.nullqueries.com/
------------------------------------------------------------------------------
🎓Data courses (Not Produced by nullQueries)🎓
Azure Data Engineering: https://click.linksynergy.com/deeplin...
DE Essentials, hands on: https://click.linksynergy.com/deeplin...
------------------------------------------------------------------------------
📷VIDEO GEAR📷
Programming Mouse: https://amzn.to/3zEom7f
Lighting: https://amzn.to/3o8tXAM
RGB light: https://amzn.to/3o8AQBS
USB Microphone: https://amzn.to/3m3hjAt
Mixer: https://amzn.to/2ZyqMIk
XLR Microphone: https://amzn.to/3AHPZ0L
💻VIDEO SOFTWARE💻
music/stock: https://1.envato.market/rnX70y
------------------------------------------------------------------------------
For business inquiries please contact nullQueries@gmail.com
Some of the links in this description are affiliate links and support the channel. Thanks for the support!
------------------------------------------------------------------------------
00:00 Intro
00:45 Business Process
01:40 Raw Data
01:53 1st NF
02:42 2nd NF
03:45 3rd NF
04:20 ER diagram
06:40 Queries
On this page of the site you can watch the video online Database Normalization Tutorial - Modeling 3NF for OLTP with a duration of hours minute second in good quality, which was uploaded by the user nullQueries 01 June 2021, share the link with friends and acquaintances, this video has already been watched 14,512 times on youtube and it was liked by 423 viewers. Enjoy your viewing!
