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 architecturescompare various Data Warehousing schemas such as Star, Snowflake etc.compare vertical and horizontal scaling of databases and their limitationsdefine concepts essential to Data Science like Dataset, Database, Data Analytics, Data Aggregation, Time Seriesdefine the functionality behind common Data processing languages such as SQL and name main commands used in these languagesdescribe common use cases and basic principles of data warehousingdescribe how Data Warehouse is different from a database and how Data Warehouses are used for Business Intelligencedescribe situations when normalization or denormalization is needed and name key steps of each processdescribe the changing perspectives with respect to analytics and the evolution of Data Analytics and briefly explain Descriptive, Diagnostic, Predictive and Prescriptive analyticsdescribe 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 Databasedistinguish between raw data, information, applicable knowledge, and general wisdomidentify examples of semi-structured datalist the most commonly used Data Sources and formatsname and define three main tiers of a Data Warehousename and describe common database types used in the industryname and describe most commonly used ETL tools and softwarename most common data backup strategies and tools and describe disaster recovery plansspecify how to organize and design your Extraction, Transformation, and Loading (ETL) capabilities to keep your data warehouse up to datespecify why real-time processing is advantageous when dealing with a large amount of data
IN THIS COURSE
1.Data Primer33sUP 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 platformDigital badges are yours to keep, forever.