Traditional Data Architectures: Relational Databases

IN THIS COURSE

• 1.  Course Overview
  1m 44s
  Meet your instructor. In this course, you’ll learn the key concepts related to relational databases. You’ll also explore what Normalization and Denormalization are, and their key differences. Then, you’ll see how a relational database is normalized by explaining the three main normal forms with a practical example. Finally, you’ll explore online transactional processing, OLTP, and online analytical processing, OLAP. FREE ACCESS
• 2.  Different Types of Databases
  3m 10s
  Learn about different types of databases and that relational databases encompass many characteristics. They organize data in tables, made up of rows and columns, or relations. Rows are also called records or tuples, and columns, fields or attributes. Additionally, a language called SQL, Structured Query Language, was developed to work with relational databases. FREE ACCESS
• 3.  Relational Database Design
  4m 32s
  Discover relational database design. A relational database is represented by tables, which contain rows and columns appropriately arranged. The data can be administered without needing to manually rearrange any of the records. You’ll learn the five main advantages of using relational databases, including ease of use. FREE ACCESS
• 4.  Normalization and Denormalization
  3m 1s
  Explore normalization and denormalization. Normalization is the process of efficiently organizing data within a relational database. The objective of normalization is to reduce duplicate information and avoid anomalies related to relationships between tables and duplicate records. Proper normalization minimizes data duplication across tables and allows data in each table to grow organically and independently from other tables. FREE ACCESS
• 5.  Normal Forms and Their Use Cases
  4m 12s
  Learn about the six normal forms of normalization. The most commonly used are primary, composite, candidate, and foreign keys. A primary key is a single-column value used to identify a database record uniquely. A composite key is a primary key composed of two or more columns used to identify a record uniquely. Candidate keys identify each unique record independently. FREE ACCESS
• 6.  OLTP Information Systems
  3m 8s
  Discover online transaction processing, OLTP. This is a concept related to information systems intended to store transaction-oriented data. OLTP involves a relatively small amount of data and supports database queries, such as insert, update, and delete. To avoid single points of failure, OLTP systems are often decentralized. There are many advantages to using OLTP systems. FREE ACCESS
• 7.  OLAP Information Systems
  2m 23s
  Explore online analytical processing, OLAP. This is an important feature in relational databases, as well as in reporting, data mining, and business intelligence. OLAP is a category of software that allows users to analyze information simultaneously from multiple database systems. This technology enables analysts to extract and view business data from different points of view. FREE ACCESS
• 8.  Common Use Cases of Data Warehousing
  2m 24s
  Discover common uses of data warehousing. This system is used to store and report on data, which typically originates in multiple systems. Then it is moved into the data warehouse for long-term storage and analysis. This storage’s structure allows users from many divisions or departments within an organization to access and analyze data according to their needs. FREE ACCESS
• 9.  Traditional Data Architectures
  3m 15s
  Explore traditional data architectures, consisting of enterprise and virtual data warehouses. An Enterprise Data Warehouse, EDW, is a form of corporate repository that stores and manages all the historical business data. Because of their complex structure and size, enterprise data warehouses are often decomposed into smaller databases, so that end users are more comfortable in querying these smaller databases. FREE ACCESS
• 10.  How Data Mining and Data Marts Are Used
  2m 57s
  Learn how data mining and data marts are used. Data Marts are the key to efficiently transforming information into insights. Data warehouses handle large data sets, but data analysis requires easy-to-find and readily available data. A data mart is a subject-oriented database that is often a partitioned segment of an enterprise data warehouse. FREE ACCESS
• 11.  How to Scale a Database
  2m 59s
  Explore database vertical and horizontal scaling. The number of requests an application can effectively support simultaneously measures its scalability. It reaches its limit when it cannot handle additional requests effectively. Then, the critical hardware resource requires different or more machines, bigger hard drives or less live data. Scaling these resources includes any combination of adjustments to CPU and physical memory. FREE ACCESS
• 12.  Course Summary
  1m 2s
  Review what you’ve learned in this course: relational databases and their advantages; normalization and denormalization, and how they differ; the three most important normal forms in normalization; online transaction processing systems and online analytical processing systems; and data warehouses, marts and scalability. FREE ACCESS