Company: Linkedin Learning Author: Adam Wilbert Full Title: Learning Relational Databases Year: 2017 Language: English Genre: Educational: Databases Skill Level: Beginner Price: €34.99 - Files: MP4 (+ Exercise File .PDF, Subtitles .SRT) Time: 02:43:28 Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 200 kbps Audio: AAC at 128 Kbps, 2 channels, 48.0 KHz Have you ever opened up a database that someone else built and felt a little lost? Or ever thought of designing your own simple database and been unsure of where to start? Or perhaps you need to work with a team of database professionals and don't know how to speak their language? This course can help you overcome these hurdles. Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain. Topics include: 01. Identify the three rules of relations. 02. Summarize the four stages of developing a relational database. 03. Describe a strategy one might use to ensure a database remains flexible in terms of the questions a user can ask. 04. Explain how to avoid scope creep. 05. Recall the characteristics of a Lookup Table. 06. Recognize situations in which denormalization would be beneficial. 07. Understand the types of relationships modeled by junction tables. 08. Define referential integrity. Our members see more. Join us! ------------- Our members see more. Join us!