Final Exam: Data Primer

Data 2021    |    Beginner
  • 1 Video | 32s
  • Includes Assessment
  • Earns a Badge
Final Exam: Data Primer will test your knowledge and application of the topics presented throughout the Data Primer track of the Skillsoft Aspire Data for Leaders and Decision Makers Journey.

WHAT YOU WILL LEARN

  • compare key differences in ETL (Extract Transform Load) and ELT (Extract Load Transform) systems and describe how ETL is used with traditional and ELT with modern data architectures
    compare various Data Warehousing schemas such as Star, Snowflake etc.
    compare vertical and horizontal scaling of databases and their limitations
    define concepts essential to Data Science like Dataset, Database, Data Analytics, Data Aggregation, Time Series
    define the functionality behind common Data processing languages such as SQL and name main commands used in these languages
    describe common use cases and basic principles of data warehousing
    describe how Data Warehouse is different from a database and how Data Warehouses are used for Business Intelligence
    describe situations when normalization or denormalization is needed and name key steps of each process
    describe the changing perspectives with respect to analytics and the evolution of Data Analytics and briefly explain Descriptive, Diagnostic, Predictive and Prescriptive analytics
    describe the concept of Data Mart and how it can be used for business decision making through Data Mining
  • describe the system and principles of work for a Multi-model Database
    distinguish between raw data, information, applicable knowledge, and general wisdom
    identify examples of semi-structured data
    list the most commonly used Data Sources and formats
    name and define three main tiers of a Data Warehouse
    name and describe common database types used in the industry
    name and describe most commonly used ETL tools and software
    name most common data backup strategies and tools and describe disaster recovery plans
    specify how to organize and design your Extraction, Transformation, and Loading (ETL) capabilities to keep your data warehouse up to date
    specify why real-time processing is advantageous when dealing with a large amount of data

IN THIS COURSE

  • Playable
    1. 
    Data Primer
    33s
    UP NEXT

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.