Data Warehouse / ETL Testing

Focused View

Blismos Academy

22:41:25

130 View

1 - Introduction

1 - Introduction.mp4

02:10

2 - History of Computer.mp4

08:36

3 - Components of Computer.mp4

08:33

4 - Functionalities of Computer.mp4

03:27

5 - Software Components.mp4

05:43

2 - Operating System

6 - What is Operating System.mp4

09:25

7 - Types of Operating System.mp4

05:11

3 - Linux and its Conmmand

8 - File Commands.mp4

15:03

9 - Listing Files.mp4

08:06

10 - Copy and Move Commands.mp4

10:26

11 - More Command.mp4

03:45

12 - Cat Command.mp4

08:04

13 - Regular Expression with GREP.mp4

09:22

14 - GREP HandsOn.mp4

05:26

15 - Diff Command Theory and HandsOn.mp4

09:23

16 - Cmp Command Theory and HandsOn.mp4

04:15

17 - Pipes Line Command Theory and HandsOn.mp4

09:59

18 - Man Command Theory and HandsOn.mp4

07:07

19 - Process Monitoring Command Theory.mp4

07:52

20 - Process Monitoring HandsOn.mp4

05:54

21 - File Permission Part 1.mp4

07:58

22 - File Permission Part 2.mp4

10:42

23 - Networking Command Theory and HandsOn.mp4

10:30

24 - Admin Command Theory and HandsOn.mp4

06:48

25 - Compression Command Theory and HandsOn.mp4

08:34

4 - RDBMS

26 - Data vs Information.mp4

04:17

27 - Why do we need Data.mp4

02:28

28 - Different ways of storing the Data.mp4

03:26

29 - Systems to store Data.mp4

02:37

30 - History of RDBMS.mp4

05:43

31 - What is RDBMS.mp4

04:21

32 - What is Database.mp4

04:58

33 - Database Components.mp4

03:11

34 - Database Components HandsOn.mp4

04:43

35 - Datatypes Theory.mp4

08:29

36 - Datatypes HandsOn.mp4

09:28

37 - Database Objects Introduction.mp4

02:47

38 - Database Object Index.mp4

07:13

39 - Database Object Sequence.mp4

04:12

40 - Database Object View.mp4

02:54

41 - Database Object View HandsOn.mp4

06:07

42 - Database Design.mp4

04:52

43 - ER Diagram Part 1.mp4

04:32

44 - ER Diagram Part 2.mp4

06:31

45 - ER Diagram Part 3.mp4

05:26

46 - Keys Introduction.mp4

03:01

47 - Super Key.mp4

04:18

48 - Candidate Key.mp4

03:01

49 - Primary Key.mp4

08:27

50 - Unique Key Surrogate Key Alternate Key Composite Key.mp4

06:52

51 - Foreign Key.mp4

04:04

52 - Data Integrity Introduction.mp4

05:19

53 - Domain Integrity Check Constraint Theory.mp4

06:09

54 - Check Constraint HandsOn.mp4

03:37

55 - Default Constraint.mp4

04:06

56 - Not Null Constraint.mp4

05:08

57 - Unique Constraint.mp4

04:18

58 - Entity Integrity Constraint.mp4

06:39

59 - Entity Integrity Constraint HandsOn.mp4

04:57

60 - Referential Integrity.mp4

06:48

61 - Referential Integrity HandsOn.mp4

06:57

62 - Normalization Introduction.mp4

02:52

63 - Need for Normalization with Example.mp4

06:17

64 - Dependencies.mp4

04:06

65 - Second Normal Form.mp4

03:12

66 - Third Normal Form.mp4

03:04

67 - BCNF Normal Form.mp4

03:32

68 - What is Transactions.mp4

04:30

69 - Transactions ACID Properties.mp4

02:54

70 - What is Atomicity.mp4

03:53

71 - What is Consistency.mp4

02:39

72 - What is Isolation.mp4

04:17

73 - What is Durability.mp4

01:43

5 - Structured Query Language

74 - Introduction to SQL.mp4

04:11

75 - Types of SQL Commands.mp4

02:17

76 - DDL Commands Create Alter.mp4

07:19

77 - DDL Commands Rename.mp4

03:58

78 - DDL Commands Drop Truncate.mp4

05:48

79 - DDL Commands Comment.mp4

05:42

80 - DML Commands.mp4

05:22

81 - DML Commands HandsOn.mp4

04:08

82 - Ways of Inserting Data.mp4

10:35

83 - Ways of Inserting Data HandsOn.mp4

10:15

84 - DCL Commands.mp4

05:24

85 - DCL Commands HandsOn.mp4

09:41

86 - TCL Commands.mp4

06:27

87 - TCL Commands HandsOn.mp4

06:18

88 - DQL Commands.mp4

05:52

89 - DQL Commands HandsOn.mp4

03:56

90 - SQL Statements.mp4

07:17

91 - Alias Theory and HandsOn.mp4

07:10

92 - Distinct Theory and HandsOn.mp4

03:29

93 - What are Operators.mp4

02:33

94 - Arithmetic Operator Theory.mp4

05:19

95 - Arithmetic Operator HandsOn.mp4

07:22

96 - Comparison Operators.mp4

08:51

97 - Logical Operator And Between.mp4

06:50

98 - Logical Operator In Not In.mp4

05:03

99 - Logical Operator Like OR.mp4

05:48

100 - Logical Operator Exists Not Exists.mp4

04:04

101 - Aggregate Functions Theory.mp4

11:57

102 - Aggregate Functions HandsOn.mp4

10:26

103 - SQL Clauses.mp4

03:38

104 - Where Clause Theory.mp4

04:44

105 - Where Clause HandsOn.mp4

04:00

106 - Order By Clause Introduction.mp4

03:09

107 - Order By Ascending Order.mp4

07:54

108 - Order By Descending Order.mp4

07:03

109 - Order By Ascending and Descending Order.mp4

05:23

110 - Order By Ascending with Null Values.mp4

05:08

111 - Order By Descending with Null Values.mp4

03:01

112 - Group By Clause.mp4

08:21

113 - Group By Clause HandsOn.mp4

06:11

114 - Group By Clause HandsOn.mp4

08:38

115 - Having Clause.mp4

07:43

116 - Having Clause HandsOn.mp4

04:33

117 - What is Null.mp4

02:06

118 - Inserting Null values Theory.mp4

04:03

119 - Inserting Null values Handson.mp4

04:14

120 - Null vs Empty SpaceTheory.mp4

03:43

121 - Null vs Empty SpaceHands on.mp4

05:52

122 - How to find Null Values Theory.mp4

04:44

123 - How to find Null Values Handson.mp4

04:26

124 - Null Values in Arithmetic Expressions Theory.mp4

03:38

125 - Null Values in Arithmetic Expressions HandsOn.mp4

02:46

126 - Sub Query Theory.mp4

11:25

127 - Sub Query HandsOn.mp4

12:34

128 - Sub Query Types Theory Part 1.mp4

05:38

129 - Sub Query Types Theory Part 2.mp4

05:09

130 - Sub Query Types HandsOn Part 1.mp4

06:05

131 - Sub Query Types HandsOn Part 2.mp4

04:50

132 - What are Joins.mp4

03:33

133 - How Joins work.mp4

04:23

134 - Inner Joins Theory.mp4

05:31

135 - Inner Joins HandsOn.mp4

06:49

136 - Outer Joins Theory.mp4

08:48

137 - Outer Joins HandsOn.mp4

07:52

138 - Self Joins Theory.mp4

05:25

139 - Self Joins HandOn.mp4

02:27

140 - Cross Joins Theory.mp4

05:13

141 - Cross Joins HandsOn.mp4

04:02

142 - Set Operators Intro.mp4

06:46

143 - Set Operators Union Theory.mp4

07:15

144 - Set Operators Union HandsOn.mp4

10:50

145 - Set Operators Union All Theory.mp4

06:26

146 - Set Operators Union All HandsOn.mp4

05:32

147 - Intersect Theory and Handson.mp4

07:16

148 - Minus Set Operator Theory.mp4

04:59

149 - Minus Set Operator Handson.mp4

07:48

150 - String Function Introduction.mp4

03:08

151 - String Functions Case Manipulation Theory.mp4

07:46

152 - Adding and Removing Spaces Part 1.mp4

06:13

153 - Adding and Removing Spaces Part 2.mp4

04:13

154 - Adding and Removing Spaces Part 3.mp4

04:07

155 - Adding and Removing Spaces HandsOn.mp4

10:00

156 - Substring Theory Part 1.mp4

06:23

157 - Substring Theory Part 2.mp4

06:02

158 - Substring HandsOn.mp4

11:04

159 - Substring Index Theory.mp4

04:33

160 - Substring Index HandsOn.mp4

06:13

161 - Instring and Locate Theory.mp4

10:08

162 - Instring and Locate HandsOn.mp4

09:23

6 - Data Warehouse

163 - Transactional vs Analytical Processing.mp4

10:31

164 - What is Data Warehouse.mp4

08:15

165 - History of Data Warehouse.mp4

05:30

166 - OLTP OLAP.mp4

06:33

167 - Introduction to ETL.mp4

03:38

168 - Extraction in ETL.mp4

05:46

169 - Transformation Introduction.mp4

03:51

170 - Types of Transformation.mp4

05:30

171 - Load Data.mp4

01:47

172 - Data Warehouse Architectures Introduction.mp4

02:18

173 - Data Warehouse Architectures based on layers.mp4

02:55

174 - Data Warehouse Architectures based on Tiers.mp4

06:14

175 - What is Data Mart.mp4

06:50

176 - Storing Data in Data Warehouse.mp4

01:48

177 - Dimension Tables and Fact Tables.mp4

03:04

178 - Dimension and Fact table with Example.mp4

07:01

179 - Introduction to DWH Schema.mp4

02:51

180 - Star Schema.mp4

03:01

181 - Snowflake Schema.mp4

04:08

182 - Fact Constellation Schema.mp4

03:36

183 - SCD Introduction.mp4

05:19

184 - SCD0 and SCD1.mp4

05:03

185 - SCD type 2.mp4

04:08

186 - SCD type 3.mp4

03:04

187 - SCD type 4.mp4

02:42

188 - SCD type 6.mp4

03:14

189 - ETL Tools.mp4

03:45

190 - Scheduling the Tools.mp4

03:23

191 - Reporting Tools.mp4

04:35

7 - Testing

192 - Quality.mp4

02:38

193 - Good Software Characteristics.mp4

03:56

194 - What is Software Testing.mp4

03:05

195 - Role of Software Testing.mp4

05:10

196 - Introduction to SDLC.mp4

03:27

197 - SDLC Phases.mp4

04:59

198 - STLC.mp4

03:09

199 - STLC Phases.mp4

06:55

200 - Expectations from Software.mp4

06:43

201 - Categories of the Requirements.mp4

06:50

202 - Non Functional Testing.mp4

05:43

203 - Test Case.mp4

06:08

204 - Introduction to Test case Design Techniques.mp4

02:34

205 - High Level Test Case Design Technique.mp4

05:35

206 - Lower Level Test Case Design Technique Part 1.mp4

07:41

207 - Lower Level Test Case Design Technique Part 2.mp4

05:26

208 - Software Testing Phases.mp4

02:19

209 - Unit Testing.mp4

05:57

210 - Functional Testing.mp4

02:11

211 - Integration Testing.mp4

02:59

212 - System Testing.mp4

05:09

213 - User Acceptance Testing.mp4

03:40

214 - Regression Testing.mp4

04:22

215 - What is Defect.mp4

03:32

216 - Defect Life Cycle.mp4

06:16

217 - Defect Parameters.mp4

05:49

8 - ETL Testing

218 - What is Datawarehouse.mp4

05:55

219 - ETL.mp4

03:44

220 - What is ETL Testing.mp4

05:04

221 - Business Requirements Development in ETL Mapping.mp4

05:17

222 - ETL testing with example.mp4

04:40

223 - DataWarehouse Testing Life Cycle.mp4

07:18

224 - Major Testing Phases.mp4

07:55

225 - Metadata check.mp4

08:15

226 - Meta Data Validation Handson.mp4

05:26

227 - Data Mismatch Check.mp4

03:12

228 - Data Completeness Validation with Record Count.mp4

05:41

229 - RecordCountCheckHandson.mp4

05:00

230 - Data Completeness Validation with Column Data Profiling.mp4

02:53

231 - Column data Profiling Validation Handson.mp4

07:56

232 - Data Completeness Validation with Data Duplicate Check.mp4

03:09

233 - Duplicate Validation Handson.mp4

04:31

234 - Data Accuracy.mp4

06:45

235 - Data Accuracy Check Handson1.mp4

05:14

236 - Data Consistency.mp4

04:32

237 - Data Consistency Handson.mp4

06:56

238 - Data Transformations Validation.mp4

06:28

239 - Data Transformations Validation Example.mp4

04:05

240 - Data transformation validation Handson.mp4

08:02

241 - ETL Testing Data Validation Scenarios.mp4

07:34

242 - Data Validation Approach for Scenario1.mp4

02:05

243 - Data Validation Approach for Scenario2.mp4

04:02

244 - Data Validation Approach for Scenario3.mp4

02:16

245 - Data Validation Approach for Scenario 4 and 5.mp4

03:34

Description

ETL Testing

What You'll Learn?

Master the Command Line and Dozens of Commands
Become an Independent User of the Linux Operating System
Creating, renaming, moving, and deleting files and directories
Understand the basic and Intermediate concepts of databases and MySQL
Learn how to create database tables using SQL commands
Learn SQL operators to write complex SQL queries
Learn about different SQL functions and constraints including NULL values
Foundational Data warehousing concepts
Learning all the concepts and terminologies related to the Data warehouse , such as the OLTP, OLAP, Dimensions, Facts, Star Schema, Snowflake Schema
Data Warehouse Architecture, Data Mart, Data Warehouse Schema and SCDs
You would also learn the basics of Data Modelling Data design
Gain an in-depth understanding of Data Warehouse WorkFlow and comparison between Database Testing and Data Warehouse Testing
Get to know what is ETL Testing and RDBMS Concepts
Understand different ETL Testing scenarios like Constraint Testing, Source to Target Testing, Metadata check,Data Mismatch Check,Data Completeness Validation

Who is this for?

Beginners who want to learn the complete concepts of ETL from very Beginning

Database developers and database administrators.

Students who wish to learn a new skill to develop their career.

Professionals who wish to learn a new skill to develop their career.

More details

Description
Data Warehouse / ETL Testing is a testing method in which the data inside a data warehouse is tested for integrity, reliability, accuracy and consistency in order to comply with the companyâ€™s data framework. The main purpose ofÂ testing is to ensure that the integrated data inside the data warehouse is reliable enough for a company to make decisions on.
The Data Warehouse/ETL testing course videos contain Data warehouse Testing, ETL Testing Scenarios, Data checks and many more complex topics explained in a detailed manner which will be helpful to compete with other Organizations. Usually ETL Testing verifies whether the ETL process is working properly.
ETL Testing is a crucial part of ETL because ETL is typically performed on mission critical data.

23+ hours of on demand videos
Clarifications through community
Right blend of concepts and hands-on
In this course, you will:
The difference between Data and Information
Why do we need Data?
Learn the ins and outs of SQL syntax
What is RDBMS and its History?
Database Objects and Database Design
Learning about the Keys and Constraints
Explaining the Normalization and its types
Understanding the Transactions and its types
How to write SQL queries to Manipulate data
How to write SQL queries to insert, update and delete data into database
Analyze data using Aggregate Functions
Testing
Life Cycle of STLC
Types of Testing
What is ETL?
Data Checks
What is Validation?
Validation Checks
Types of Checks

Who this course is for:
Beginners who want to learn the complete concepts of ETL from very Beginning
Database developers and database administrators.
Students who wish to learn a new skill to develop their career.
Professionals who wish to learn a new skill to develop their career.

User Reviews

Rating

average 0

Total votes0

Focused display

Data Warehouse

Blismos Academy

Instructor's Courses

Practitioners of Big Data and related technologiesTeam has over two decades of experience in the industryPassionate in dealing with data and providing IT solutionsWe believe in continuous learningEnjoy spreading the knowledge through Training, Workshops, Internships and Projects assignmentsOur Solution provides support and expertise advice that is presented for consideration and decision-making in Big Data Technologies

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.