Linkedin - Database Design Fundamentals (2024)

Get an understanding of database design to help you use databases better, make your queries more efficient, and better understand the theory behind what makes joins work.
Course details
Understanding how to design databases effectively can be a game-changer-both for your current work and for your future career. In this course, get an overview of why database design is essential. Instructor Melody Zacharias covers the different types of designs-OLAP and OLTP-then expands on and explains why OLTP is the focus of the course. Melody then details the different normal forms and why they are essential-and when you use them and when you do not.
Then, once you have a solid base, explore entities and attributes, primary keys, and how they are designed. Plus, learn about naming conventions and data types, which are important for design as they can affect the physical size of the structure. Melody also explains how developments in AI affect database design, then guides you through a final project to bring everything you've learned together.
Homepage