Data Architecture Getting Started

Data Architecture    |    Intermediate
  • 13 videos | 1h 2m 52s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 667 users Rating 4.5 of 667 users (667)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 1m 54s
  • 3m 31s
    During this video, you will learn how to identify the relationship between data, information, and analytics. FREE ACCESS
  • Locked
    3.  Data Privacy
    6m 30s
    After completing this video, you will be able to recognize PII, PHI, and common data privacy regulations. FREE ACCESS
  • Locked
    4.  The Data Lifecycle
    9m 6s
    Upon completion of this video, you will be able to list the six phases of the data life cycle. FREE ACCESS
  • Locked
    5.  SQL vs. NoSQL
    5m 5s
    In this video, find out how to compare and contrast SQL and NoSQL database solutions. FREE ACCESS
  • Locked
    6.  Create an Entity Relationship Diagram
    5m 35s
    In this video, you will learn how to use Visual Paradigm to create a relational database entity-relationship diagram. FREE ACCESS
  • Locked
    7.  Implement a SQL Solution
    4m 20s
    In this video, you will learn how to deploy Microsoft SQL Server on Amazon Web Services. FREE ACCESS
  • Locked
    8.  Implement a NoSQL Solution
    3m 1s
    Learn how to deploy DynamoDB in the Amazon Web Services cloud. FREE ACCESS
  • Locked
    9.  Big Data
    5m 16s
    In this video, you will learn what big data is and how it is managed. FREE ACCESS
  • Locked
    10.  Data Architecture and Governance
    4m 46s
    Upon completion of this video, you will be able to recognize the relationship between data and how it is governed. FREE ACCESS
  • Locked
    11.  IT Data System Architecture Types
    4m 16s
    In this video, you will learn about the different types of data architectures, including the TOGAF enterprise architecture. FREE ACCESS
  • Locked
    12.  Data Analytics and Reporting
    4m 46s
    Upon completion of this video, you will be able to describe how organizations can derive value from data they already have. FREE ACCESS
  • Locked
    13.  Exercise: Implement Data Architecture Best Practices
    4m 46s
    Find out how to implement effective data management solutions. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Job Ready SQL
Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Exploration using R
Rating 4.5 of 195 users Rating 4.5 of 195 users (195)
Course Traditional Data Architectures: Data Warehousing and ETL Systems
Rating 4.5 of 364 users Rating 4.5 of 364 users (364)
Course CompTIA Data+: Understanding Databases
Rating 4.8 of 44 users Rating 4.8 of 44 users (44)