|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/etl-testing-for-beginners/
课程评论：没有评论
课程名称：今天就学习使用Informatica PowerCenter进行ETL测试 概述： 本课程的主要目标是让您熟悉ETL测试的概念。课程开始于数据仓库的基本概念，这对于测试数据仓库中的数据至关重要。您需要掌握SQL（关系型数据库查询语言），因此本教程简要介绍了SQL和数据规范化，以便在数据库中结构化数据。您将学习如何在ETL过程完成数据转换后，测试加载的数据。完成本教程后，您可以开始为您的ETL映射创建一套测试用例，并构建自己的查询来执行这些用例。课程的所有部分都将包含相关的练习，帮助您实践新技能。 什么是ETL测试？ ETL代表提取-转换-加载（Extract-Transform-Load）。这是一个将数据从源系统加载到数据仓库的过程。ETL测试的目的是确保从源系统加载到数据仓库的数据在经过转换后是准确的。 学习ETL测试的三大好处： 1. ETL测试专业人员在市场上需求旺盛。 2. 如Informatica PowerCenter、IBM Infosphere Information Server、Oracle数据集成器等工具在行业中也备受欢迎，这一趋势还将继续增长。 3. ETL测试工作一般薪酬优厚，并提供许多福利。 常见问题： - 在ETL测试领域找工作难吗？我认为“一般不难”。只要掌握相关知识（如本课程所教）和SQL经验，您应该能够轻松找到合适的ETL测试工作。 - 在选择ETL测试之前需要掌握哪些技能？ETL主要是处理数据库中的大数据，您需要对SQL和数据仓库概念有良好的理解。课程中将提供SQL的简要复习。 保证： 如果您在购买课程后30天内决定该课程不适合您，可以申请全额退款，毫无疑问，只需点击退款按钮，您的所有费用将退还到您的信用卡。 您准备好学习ETL测试了吗？请点击“选修此课程”按钮，2分钟内即可开始学习！
COURSE OBJECTIVEThe Primary objective of this course to make you familiar with ETL testing concepts. The course starts with data warehousing concepts, as that is required before you start testing the data in data warehouse. You should be well versed is SQL (RDBMS query language), hence this tutorial has a brief introduction to SQL and normalization to structure data in a database. You will learn how to test the loaded data by ETL process after transformations. After you finish the tutorial, you can start creating a set of test cases for your ETL mapping and build your own queries to execute them. All sections of the course will have relevant exercises for you to do, so you can practice your new skills. WHAT IS ETL TESTING?ETL stands for Extract-Transform-Load. It is a process of loading data from the source system to the data warehouse.ETL testing is done to ensure that the data loaded from the source system to a data warehouse (after transformations), is accurate. TOP 3 BENEFITS OF LEARNING ETL TESTING ETL testing professionals are in high demand in the market. Tools like Informatica PowerCenter, IBM Infosphere Information Server, Oracle data Integrator,etc. are in huge demand in the Industry and there is no sign of this trend should stop growing anytime soon.ETL testing Jobs are generally well payed and include many benefits.Learning ETL testing will improve your data analytical skills. FREQUENTLY ASKED QUESTIONS Is it easy to get a job in ETL testing?I would say it is "easy". But if you have the right knowledge (like this course) and SQL experience, it should not be much of a problem to get a good ETL testing job in various companies. The future of ETL Testing is very bright. There will always be a need to store data for analysis, for any organizations that has large amount of transactions. What skills are required before I opt for ETL testing?ETL is all about playing with large data in database. You must have good knowledge of database structured query language (SQL), and knowledge of data warehousing concepts. A short refresher to SQL will be given in the course. GUARANTEE If within 30 days of buying the course you decide that it's not for you, please get a Udemy-backed refund. No questions asked - just press the refund button, and all of your money will be returned to your credit card. ARE YOU READY TO LEARN ETL TESTING? Please press the "Take This Course" button and start learning 2 minutes from now!
