Traditional Data Architectures: Relational Databases

Data Architecture 2021
  • 12 Videos | 39m 48s
  • Includes Assessment
  • Earns a Badge
Databases are essential in working with large amounts of data. Managers, leaders, and decision-makers need to choose the right approach when working on a large data project, distinguishing among multiple database types and their use cases. A relational database is a primary traditional data architecture commonly used by most businesses. Working with relational databases has some key advantages but also poses certain limitations. In this course, learn how critically evaluate and work with relational databases. Explore normalization and denormalization of datasets along with specific use cases of these opposite approaches. Examine two main online information processing systems, Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems. Finally, investigate the concepts of data warehousing, data marts, and data mining. Upon completion, you'll be able to identify when and how to use a relational database.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    name and describe common database types used in the industry
    describe key concepts related to the design of relational databases
    describe situations when normalization or denormalization is needed and name the key steps of each process
    name 4 different types of normal forms and compare their use cases
    describe online transaction processing in the context of relational databases and data warehousing
  • describe the process of online analytical processing in the context of reporting and forecasting
    describe common use cases and basic principles of data warehousing
    describe traditional data warehousing technologies such as virtual data warehousing and enterprise data warehousing
    describe the concept of data mart and how it can be used for business decision-making through data mining
    compare vertical and horizontal scaling of databases and their limitations
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 44s
    UP NEXT
  • Playable
    2. 
    Different Types of Databases
    3m 10s
  • Locked
    3. 
    Relational Database Design
    4m 32s
  • Locked
    4. 
    Normalization and Denormalization
    3m 1s
  • Locked
    5. 
    Normal Forms and Their Use Cases
    4m 12s
  • Locked
    6. 
    OLTP Information Systems
    3m 8s
  • Locked
    7. 
    OLAP Information Systems
    2m 23s
  • Locked
    8. 
    Common Use Cases of Data Warehousing
    2m 24s
  • Locked
    9. 
    Traditional Data Architectures
    3m 15s
  • Locked
    10. 
    How Data Mining and Data Marts Are Used
    2m 57s
  • Locked
    11. 
    How to Scale a Database
    2m 59s
  • Locked
    12. 
    Course Summary
    1m 2s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE