Course details

Data Architecture Primer

Data Architecture Primer


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

In this 12-video course, learners explore how to define data, its lifecycle, the importance of privacy, and SQL and NoSQL database solutions and key data management concepts as they relate to big data. First, look at the relationship between data, information, and analysis. Learn to recognize personally identifiable information (PII), protected health information (PHI), and common data privacy regulations. Then, study the data lifecycle's six phases. Compare and contrast SQL and NoSQL database solutions and look at using Visual Paradigm to create a relational database ERD (entity-relationship diagram). To implement an SQL solution, Microsoft SQL Server is deployed in the Amazon Web Services (AWS) cloud, and a NoSQL solution by deploying DynamoDB in the AWS cloud. Explore definitions of big data and governance. Learners will examine various types of data architecture, including TOGAF (The Open Group Architecture Framework) enterprise architecture. Finally, learners study data analytics and reporting, how organizations can derive value from data they have. The concluding exercise looks at implementing effective data management solutions.



Expected Duration (hours)
1.1

Lesson Objectives

Data Architecture Primer

  • Course Overview
  • identify the relationship between data, information, and analytics
  • recognize PII, PHI, and common data privacy regulations
  • list the six phases of the data lifecycle
  • compare and contrast SQL and NoSQL database solutions
  • use Visual Paradigm to create a relational database ERD
  • deploy Microsoft SQL Server in the Amazon Web Services cloud
  • deploy DynamoDB in the Amazon Web Services cloud
  • define what big data is and how it is managed
  • recognize the relationship between data and how it is governed
  • distinguish among the various types of data architectures, including the TOGAF enterprise architecture
  • describe how organizations can derive value from data they already have
  • implement effective data management solutions
  • Course Number:
    it_dsdagsdj_01_enus

    Expertise Level
    Intermediate