Database Design Fundamentals / with Melody Zacharias.

Format:

Video

Author/Creator:

Zacharias, Melody, speaker.

Contributor:

linkedin.com (Firm)

Language:

English

Genre:

Instructional films.

Educational films.

Physical Description:

1 online resource

Place of Publication:

Carpenteria, CA : linkedin.com, 2024.

System Details:

Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.

digital

Summary:

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.

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.

Participant:

Presenter: Melody Zacharias

Notes:

10/08/202412:00:00AM

Access Restriction:

Restricted for use by site license.