Главная страница Категория другое (qa) ETL тестирование: От новичка к эксперту

ETL тестирование: От новичка к эксперту

Name: ETL тестирование: От новичка к эксперту
Rating: 5 (8 reviews)

ETL testing: From beginner to expert

udemy

Скачать курс архивом Скачать материалы курса

Продолжительность

18 ч 59 мин

Категория

Другое (QA)

Количество уроков

254 Видео

Дата добавления

23 июл. 2017 г., 15:12

Язык

Английский

Дата обновления

10 февр. 2020 г., 11:36

ETL тестирование: От новичка к эксперту - вступной курс для всех тестировщиков програмного обеспечения. В этом курсе вы пройдетесь по таким вещам, как:

- Концепты складирования данных Business Intelligence;
- Что такое ETL тестирование, жизненный цикл QA и концепты РСУБД;
- Углубленное представление о рабочем процессе хранилища данных и сравнение тестирования базы данных с хранилищем данных;
- Различные сценарии тестирования ETL, такие как тестирование ограничений, тестирование источника, целевое тестирование, тестирование бизнес-правил, тестирование отрицательных сценариев, тестирование зависимостей, тестирование обработки ошибок;
- Выполнение данных используя SQL и понимание масштаба BI-тестирования;
Требования:
Базовое понимание РСУБД (Реляционной системи управления базами данных)

Посмотреть больше

Урок 1. 00:07:21

Welcome! Thank you for learning the ETL Testing Course with me!
Урок 2. 00:04:52

What is Data Testing/ETL Testing and the Challenges in ETL testing?
Урок 3. 00:07:16

What will be the future of ETL tools/testing as big data is getting popular?
Урок 4. 00:04:22

Master Data Warehouse Concepts, Step by Step from Scratch
Урок 5. 00:04:26

Is Data Warehouse still relevant in the age of Big Data?
Урок 6. 00:03:24

What is Data?
Урок 7. 00:04:53

Why Data Warehouse is implemented?
Урок 8. 00:05:44

What is a Data Warehouse?
Урок 9. 00:01:48

What is a Data Mart?
Урок 10. 00:00:37

Fundamental difference between Data Warehouse and Data Mart
Урок 11. 00:02:41

Advantages of a Data Mart
Урок 12. 00:04:01

Characteristics of a Data Mart
Урок 13. 00:03:14

Disadvantages of a Data Mart
Урок 14. 00:02:16

Mistakes and Misconceptions of a Data Mart
Урок 15. 00:04:09

Revised: Enterprise Architecture or Centralized Architecture
Урок 16. 00:02:50

Revised: Federated Data Warehouse Architecture
Урок 17. 00:03:15

Multi Tired Architecture
Урок 18. 00:03:58

Components of a Data Warehouse Architecture
Урок 19. 00:04:44

Purpose of a Staging Area in Data Warehouse Architecture - Part 1
Урок 20. 00:03:36

Purpose of a Staging Area in Data Warehouse Architecture - Part 2
Урок 21. 00:02:14

What is Data Modeling?
Урок 22. 00:04:04

Why should a Tester know Data Modeling?
Урок 23. 00:03:54

Data Modeling Techniques
Урок 24. 00:03:42

ER Data Model
Урок 25. 00:04:40

Dimensional Model
Урок 26. 00:05:52

Differences between ER Model and Dimensional Model
Урок 27. 00:01:02

Different phases required to build a Dimensional Data Model
Урок 28. 00:02:26

Business Requirements
Урок 29. 00:02:42

CDM - Conceptual Data Model
Урок 30. 00:03:08

LDM - Logical Data Model
Урок 31. 00:01:25

Physical Data Model
Урок 32. 00:04:17

Database
Урок 33. 00:02:49

What is a Dimension Table?
Урок 34. 00:02:06

What is a Fact Table?
Урок 35. 00:01:46

Additive Facts
Урок 36. 00:02:29

Semi Additive Facts
Урок 37. 00:01:31

Non-Additive Facts
Урок 38. 00:02:30

Fact less Facts
Урок 39. 00:05:24

What is a Star Schema?
Урок 40. 00:03:26

What is a Snow Flake Schema?
Урок 41. 00:02:21

Galaxy Schema or Fact Constellation Schema
Урок 42. 00:05:28

Snow Flake Vs Star Schema
Урок 43. 00:06:39

Conformed Dimensions
Урок 44. 00:03:07

Junk Dimensions
Урок 45. 00:03:36

Degenerate Dimensions
Урок 46. 00:02:27

Role Playing Dimensions
Урок 47. 00:05:31

Slowly Changing Dimensions - Intro and Example Creation
Урок 48. 00:12:31

Slowly Changing Dimensions (SCD) Type 1, 2, 3
Урок 49. 00:03:34

Slowly Changing Dimensions - Summary
Урок 50. 00:06:50

What is Data Integration?
Урок 51. 00:04:20

What is ETL?
Урок 52. 00:04:17

Data Acquisition
Урок 53. 00:05:44

Data Transformation
Урок 54. 00:02:50

Common Questions and Summary
Урок 55. 00:06:42

ETL - Explained
Урок 56. 00:05:58

ELT - Explained
Урок 57. 00:02:24

ETL Vs ELT
Урок 58. 00:03:25

Project Sponsor
Урок 59. 00:01:47

Project Manager
Урок 60. 00:02:54

Functional Analyst or Business Analyst
Урок 61. 00:04:18

SME - Subject Matter Expert
Урок 62. 00:03:08

DW BI Architect and Data Modeler
Урок 63. 00:01:22

DWH Tech Admin
Урок 64. 00:01:57

ETL Developers
Урок 65. 00:01:30

BI OLAP Developers
Урок 66. 00:01:59

ETL Testers / QA Group
Урок 67. 00:00:57

DB UNIX Network Admins
Урок 68. 00:09:58

Data Architect, Data Warehouse Architect, BI Architect and Solution Architect
Урок 69. 00:02:18

Final Note about the Roles
Урок 70. 00:01:52

Different phases in DW/BI/ETL Implementation Approach
Урок 71. 00:03:35

Knowledge Capture Sessions
Урок 72. 00:07:22

Requirements
Урок 73. 00:04:49

Architecture Phase
Урок 74. 00:01:36

Data Model/Database
Урок 75. 00:02:44

ETL Phase
Урок 76. 00:02:12

Data Access Phase
Урок 77. 00:01:38

Data Access Types - Selection
Урок 78. 00:00:59

Data Access Types - Drilling Down
Урок 79. 00:00:38

Data Access Types - Exception Reporting
Урок 80. 00:01:28

Data Access Types - Calculations
Урок 81. 00:00:59

Data Access Types - Graphics and Visualization
Урок 82. 00:02:05

Data Access Types -Data Entry Options
Урок 83. 00:01:01

Data Access Types - Customization
Урок 84. 00:00:57

Data Access Types - WebBased Reporting
Урок 85. 00:01:06

Data Access Types - BroadCasting
Урок 86. 00:01:43

Deploy
Урок 87. 00:03:26

Iterative Approach
Урок 88. 00:01:10

Introduction and Knowledge Capture Sessions
Урок 89. 00:02:49

Test Strategy and Plan
Урок 90. 00:02:26

Define Test Framework
Урок 91. 00:04:13

Assess Source & Target Components
Урок 92. 00:03:13

Test ETL - The Data Centric Method
Урок 93. 00:05:35

System and Integration Testing
Урок 94. 00:03:58

Regression Testing
Урок 95. 00:04:34

Performance Testing
Урок 96. 00:03:46

Acceptance Test
Урок 97. 00:04:02

Different Categories Of DWH Projects
Урок 98. 00:02:28

New DataWarehouse SetUp
Урок 99. 00:01:53

Migration Testing - Includes Data Migration
Урок 100. 00:01:29

Change Requests - For Existing Projects
Урок 101. 00:00:55

OLAP/Dashboard/Report Testing
Урок 102. 00:03:51

Knowledge of the project or the application
Урок 103. 00:02:46

Analysis of the specifications provided by the clients
Урок 104. 00:01:19

Approve requirements and design specifications
Урок 105. 00:01:14

Create and Maintain the test strategy document
Урок 106. 00:01:17

Design the Test Cases as per the Test plan
Урок 107. 00:01:24

Estimate the efforts required to design the test cases and execute the project
Урок 108. 00:01:11

Tracability of requirements to test cases
Урок 109. 00:00:54

Define Exit and Entrance criteria
Урок 110. 00:01:51

Creating Test Plan, Test Scenario, Test Cases & Test Scripts to validate source
Урок 111. 00:04:32

Test data creation
Урок 112. 00:01:21

Creating and Maintaining Reusable Scripts and Execute Test Scripts
Урок 113. 00:01:49

Execute backend data-driven test cases
Урок 114. 00:01:45

Client Co-ordination and Incorporate UAT Test cases and Identify Bugs
Урок 115. 00:03:42

Other Roles and Responsibilites
Урок 116. 00:07:37

Database Testing Vs GUI Testing
Урок 117. 00:16:47

Structural Database Testing
Урок 118. 00:10:52

Functional Database Testing
Урок 119. 00:07:18

Functional Database Testing - Part 2
Урок 120. 00:05:06

Non Functional Database Testing
Урок 121. 00:01:16

Summary of Database Testing
Урок 122. 00:04:52

What is Data Testing/ETL Testing and the Challenges in ETL testing?
Урок 123. 00:07:16

What will be the future of ETL tools/testing as big data is getting popular?
Урок 124. 00:04:22

Database Testing and ETL Testing
Урок 125. 00:01:14

Differences between Database Testing and ETL Testing
Урок 126. 00:04:58

Database testing during ETL Testing - Explained with a project setup
Урок 127. 00:01:42

Bug Reports
Урок 128. 00:02:50

After Finding the Defect
Урок 129. 00:01:26

Writing the Bug Summary
Урок 130. 00:03:02

Using Appropriate Language/Phrases
Урок 131. 00:02:12

Steps to Reproduce the Defect
Урок 132. 00:00:40

Including Test Data
Урок 133. 00:01:35

Including Screen Shots
Урок 134. 00:00:59

Severity / Priority
Урок 135. 00:00:29

Logs
Урок 136. 00:03:10

Other Information
Урок 137. 00:01:00

Introduction to the common causes for defects
Урок 138. 00:03:31

Insufficient/Incorrect Requirements
Урок 139. 00:01:59

Assumptions/Mis-Understanding
Урок 140. 00:02:13

Wrong Decision During The Design
Урок 141. 00:02:12

Good Programmers With Wrong Goals
Урок 142. 00:05:05

Complexity
Урок 143. 00:04:20

Time Constriants
Урок 144. 00:02:14

Frequently Changing Business Requirements
Урок 145. 00:06:52

Reporting the discrepancy
Урок 146. 00:02:36

Communicating the discrepancy
Урок 147. 00:01:34

Escalating the discrepancy
Урок 148. 00:01:47

Generating Metrics
Урок 149. 00:02:45

Critical Issue Severity
Урок 150. 00:01:27

High Severity Issues
Урок 151. 00:00:45

Medium Severity Issues
Урок 152. 00:01:01

Low Severity Issues
Урок 153. 00:08:26

Defect Status Category Labels
Урок 154. 00:04:21

Metadata Testing
Урок 155. 00:05:12

Data Completeness Testing
Урок 156. 00:07:17

Data Quality Testing - Data Duplicates
Урок 157. 00:06:08

Data Quality Testing - Business Validation and Rules
Урок 158. 00:05:55

Data Transformation - White Box Testing
Урок 159. 00:04:01

Data Transformation - Black Box Testing
Урок 160. 00:03:01

ETL Regression Testing
Урок 161. 00:05:42

Reference Data Testing
Урок 162. 00:04:05

Incremental ETL Testing
Урок 163. 00:01:27

ETL Integration Testing
Урок 164. 00:02:44

ETL Performance Testing
Урок 165. 00:04:47

Different Types of Enterprise Databases
Урок 166. 00:06:50

Different ETL tools available in the Market
Урок 167. 00:03:14

Which ETL tool should you learn, if you are starting with ETL testing now?
Урок 168. 00:19:34

Informatica Power Center Architecture
Урок 169. 00:19:04

Pre Installation Steps & System Pre-Requisites
Урок 170. 00:08:03

Quick Tip: Product Availability Matrix - PAM
Урок 171. 00:09:16

Download Software
Урок 172. 00:13:29

Oracle 11g Installation and SQL Developer Configuration
Урок 173. 00:01:46

Too Many Files!! Which one should I download?
Урок 174. 00:03:20

Extract the Informatica Downloaded files
Урок 175. 00:17:01

Power Center Server Installation
Урок 176. 00:02:31

Power Center Client Installation
Урок 177. 00:12:52

Administration Console Introduction
Урок 178. 00:19:19

List of Services Available
Урок 179. 00:18:15

Repository Service Creation
Урок 180. 00:18:03

Setting up Integration Service
Урок 181. 00:13:17

Repository Configuration and Folder Creation
Урок 182. 00:12:22

Basic File directory structures
Урок 183. 00:12:55

Client Tools and Components
Урок 184. 00:04:06

Setting up the Database Connection at Mapping Designer and Workflow Manager
Урок 185. 00:09:43

Let's start with the Mapping Designer
Урок 186. 00:03:03

Mapping Designer - Finding Object Dependencies
Урок 187. 00:12:04

The Complete Cycle - Lets build the first Mapping, Session and the Workflow
Урок 188. 00:19:57

Transformations Overview
Урок 189. 00:00:49

Different Categories of Transformations
Урок 190. 00:02:46

Active Transformations
Урок 191. 00:02:59

Passive Transformations
Урок 192. 00:01:33

Connected Transformations and Unconnected Transformations
Урок 193. 00:01:50

Multi Group Transformations
Урок 194. 00:01:26

Restricted Process Transformations
Урок 195. 00:05:19

Data Flow Rules
Урок 196. 00:01:21

Brief introduction to Transformations and it's functions
Урок 197. 00:02:13

Aggregator Trasformation
Урок 198. 00:01:58

Expression Transformation
Урок 199. 00:01:38

Filter Transformation
Урок 200. 00:02:39

Joiner Transformation
Урок 201. 00:03:21

Lookup Transformation
Урок 202. 00:01:29

Normalizer Transformation
Урок 203. 00:01:09

Rank Transformation
Урок 204. 00:03:33

Router Transformation
Урок 205. 00:02:00

Sequence Generator Transformation
Урок 206. 00:02:49

Stored Procedure Transformation
Урок 207. 00:01:11

Sorter Transformation
Урок 208. 00:02:05

Source Qualifier Transformation
Урок 209. 00:02:03

Update Strategy Transformation
Урок 210. 00:01:13

XML Source Qualifier Transformation
Урок 211. 00:01:25

XML Parser Transformation
Урок 212. 00:01:03

XML Generator Transformation
Урок 213. 00:00:47

Union Transformation
Урок 214. 00:01:01

HTTP Transformation
Урок 215. 00:01:20

Transaction Control Transformation
Урок 216. 00:00:58

Identity Resolution Transformation
Урок 217. 00:00:43

Custom Transformation
Урок 218. 00:00:50

Data Masking Transformation
Урок 219. 00:00:54

Additional Information about Informatica Power Center Transformations
Урок 220. 00:05:07

Power Center's Native Data Types and Data Type Conversion
Урок 221. 00:05:14

Ports in Informatica
Урок 222. 00:03:21

Different Types of Functions
Урок 223. 00:04:30

Best ways to get around functions
Урок 224. 00:08:00

Components of Workflow Manager
Урок 225. 00:11:57

Workflow Monitor
Урок 226. 00:17:30

Monitor Tool's functionality & Available Options
Урок 227. 00:06:57

Session Log
Урок 228. 00:07:26

Repository Manager Activities
Урок 229. 00:17:11

Mapplet
Урок 230. 00:17:30

Usage of Debugger
Урок 231. 00:01:29

Requirements for Flat File Source to Flat File and Relational Target
Урок 232. 00:04:22

Required Target Attributes based on the requirement
Урок 233. 00:01:26

Target Table creation based on the requirement
Урок 234. 00:02:26

Source Flat File Creation with the test data
Урок 235. 00:03:23

Source File directory for the source to be placed
Урок 236. 00:21:40

Let's create the mapping with the requirements at hand
Урок 237. 00:04:36

Workflow Creation for the mapping created with the requirements
Урок 238. 00:06:02

Different aspects/areas which needs to be verified during a workflow run
Урок 239. 00:07:07

What is S2T document and what should this document contain?
Урок 240. 00:05:28

Source to Target Mapping - Sample 1
Урок 241. 00:03:30

Source to Target Mapping - Sample 2
Урок 242. 00:09:07

Source to Target Mapping - For the requirements we are using
Урок 243. 00:12:31

Technical Test Cases
Урок 244. 00:03:56

Verifying the workflow run and the source to target records
Урок 245. 00:11:59

Test Cases for Business and Data Validations
Урок 246. 00:01:48

Restarting the Workflow for further testing
Урок 247. 00:06:19

Duplicate Records Check and Record Count Verification
Урок 248. 00:12:43

Data Validation Checks - Using SQL queries (Create, Delete, Drop, Select, Minus)
Урок 249. 00:05:51

Test Case for verifying the Unique Sequence numbers
Урок 250. 00:03:24

Fix and Retest of the Active Flag scenario
Урок 251. 00:04:47

Enterprise Architecture or Centralized Architecture
Урок 252. 00:03:06

Federated Architecture
Урок 253. 00:12:50

How do you validate file to table with 1 million records?
Урок 254. 00:01:38

Direct links to other courses

Автор - udemy

udemy

Udemy - одна из самых больших площадок в мире по доставке обучающего контента от разных авторов всего мира. Присутсвуют курсы практически на любую тему.

+192

Категории

Комментарии

Команда внимательно читает ваши комментарии и оперативно на них реагирует. Вы можете спокойно оставлять запросы на обновления или задавать любые вопросы о курсе здесь.

Другие материалы в этой категории

Изображение курса Контейнеризация ETL c AWS, TDengine и Grafana

Andreas Kretz

29 мая 2025 г., 23:15

Обработка и анализ данных

Контейнеризация ETL c AWS, TDengine и Grafana

Dockerized ETL With AWS, TDengine & Grafana

Инженерам данных часто нужно быстро настроить простой ETL-скрипт, который просто выполняет свою задачу. В этом проекте вы узнаете, как легко реализовать такой ETL на AWS: подключить живые данные из погодного API и записывать их во временную базу данных TDengine.

0 ч 29 мин

Английский

Посмотреть