Traditional Data Architectures: Relational Databases
Data Architecture 2021
| Beginner
- 12 Videos | 34m 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 coursename and describe common database types used in the industrydescribe key concepts related to the design of relational databasesdescribe situations when normalization or denormalization is needed and name the key steps of each processname 4 different types of normal forms and compare their use casesdescribe 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 forecastingdescribe common use cases and basic principles of data warehousingdescribe traditional data warehousing technologies such as virtual data warehousing and enterprise data warehousingdescribe the concept of data mart and how it can be used for business decision-making through data miningcompare vertical and horizontal scaling of databases and their limitationssummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 44sUP NEXT
-
2.Different Types of Databases3m 10s
-
3.Relational Database Design4m 32s
-
4.Normalization and Denormalization3m 1s
-
5.Normal Forms and Their Use Cases4m 12s
-
6.OLTP Information Systems3m 8s
-
7.OLAP Information Systems2m 23s
-
8.Common Use Cases of Data Warehousing2m 24s
-
9.Traditional Data Architectures3m 15s
-
10.How Data Mining and Data Marts Are Used2m 57s
-
11.How to Scale a Database2m 59s
-
12.Course Summary1m 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.