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.