وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Data Warehouse / ETL Testing

سرفصل های دوره

ETL Testing


1 - Introduction
  • 1 - Introduction
  • 2 - History of Computer
  • 3 - Components of Computer
  • 4 - Functionalities of Computer
  • 5 - Software Components

  • 2 - Operating System
  • 6 - What is Operating System
  • 7 - Types of Operating System

  • 3 - Linux and its Conmmand
  • 8 - File Commands
  • 9 - Listing Files
  • 10 - Copy and Move Commands
  • 11 - More Command
  • 12 - Cat Command
  • 13 - Regular Expression with GREP
  • 14 - GREP HandsOn
  • 15 - Diff Command Theory and HandsOn
  • 16 - Cmp Command Theory and HandsOn
  • 17 - Pipes Line Command Theory and HandsOn
  • 18 - Man Command Theory and HandsOn
  • 19 - Process Monitoring Command Theory
  • 20 - Process Monitoring HandsOn
  • 21 - File Permission Part 1
  • 22 - File Permission Part 2
  • 23 - Networking Command Theory and HandsOn
  • 24 - Admin Command Theory and HandsOn
  • 25 - Compression Command Theory and HandsOn

  • 4 - RDBMS
  • 26 - Data vs Information
  • 27 - Why do we need Data
  • 28 - Different ways of storing the Data
  • 29 - Systems to store Data
  • 30 - History of RDBMS
  • 31 - What is RDBMS
  • 32 - What is Database
  • 33 - Database Components
  • 34 - Database Components HandsOn
  • 35 - Datatypes Theory
  • 36 - Datatypes HandsOn
  • 37 - Database Objects Introduction
  • 38 - Database Object Index
  • 39 - Database Object Sequence
  • 40 - Database Object View
  • 41 - Database Object View HandsOn
  • 42 - Database Design
  • 43 - ER Diagram Part 1
  • 44 - ER Diagram Part 2
  • 45 - ER Diagram Part 3
  • 46 - Keys Introduction
  • 47 - Super Key
  • 48 - Candidate Key
  • 49 - Primary Key
  • 50 - Unique Key Surrogate Key Alternate Key Composite Key
  • 51 - Foreign Key
  • 52 - Data Integrity Introduction
  • 53 - Domain Integrity Check Constraint Theory
  • 54 - Check Constraint HandsOn
  • 55 - Default Constraint
  • 56 - Not Null Constraint
  • 57 - Unique Constraint
  • 58 - Entity Integrity Constraint
  • 59 - Entity Integrity Constraint HandsOn
  • 60 - Referential Integrity
  • 61 - Referential Integrity HandsOn
  • 62 - Normalization Introduction
  • 63 - Need for Normalization with Example
  • 64 - Dependencies
  • 65 - Second Normal Form
  • 66 - Third Normal Form
  • 67 - BCNF Normal Form
  • 68 - What is Transactions
  • 69 - Transactions ACID Properties
  • 70 - What is Atomicity
  • 71 - What is Consistency
  • 72 - What is Isolation
  • 73 - What is Durability

  • 5 - Structured Query Language
  • 74 - Introduction to SQL
  • 75 - Types of SQL Commands
  • 76 - DDL Commands Create Alter
  • 77 - DDL Commands Rename
  • 78 - DDL Commands Drop Truncate
  • 79 - DDL Commands Comment
  • 80 - DML Commands
  • 81 - DML Commands HandsOn
  • 82 - Ways of Inserting Data
  • 83 - Ways of Inserting Data HandsOn
  • 84 - DCL Commands
  • 85 - DCL Commands HandsOn
  • 86 - TCL Commands
  • 87 - TCL Commands HandsOn
  • 88 - DQL Commands
  • 89 - DQL Commands HandsOn
  • 90 - SQL Statements
  • 91 - Alias Theory and HandsOn
  • 92 - Distinct Theory and HandsOn
  • 93 - What are Operators
  • 94 - Arithmetic Operator Theory
  • 95 - Arithmetic Operator HandsOn
  • 96 - Comparison Operators
  • 97 - Logical Operator And Between
  • 98 - Logical Operator In Not In
  • 99 - Logical Operator Like OR
  • 100 - Logical Operator Exists Not Exists
  • 101 - Aggregate Functions Theory
  • 102 - Aggregate Functions HandsOn
  • 103 - SQL Clauses
  • 104 - Where Clause Theory
  • 105 - Where Clause HandsOn
  • 106 - Order By Clause Introduction
  • 107 - Order By Ascending Order
  • 108 - Order By Descending Order
  • 109 - Order By Ascending and Descending Order
  • 110 - Order By Ascending with Null Values
  • 111 - Order By Descending with Null Values
  • 112 - Group By Clause
  • 113 - Group By Clause HandsOn
  • 114 - Group By Clause HandsOn
  • 115 - Having Clause
  • 116 - Having Clause HandsOn
  • 117 - What is Null
  • 118 - Inserting Null values Theory
  • 119 - Inserting Null values Handson
  • 120 - Null vs Empty SpaceTheory
  • 121 - Null vs Empty SpaceHands on
  • 122 - How to find Null Values Theory
  • 123 - How to find Null Values Handson
  • 124 - Null Values in Arithmetic Expressions Theory
  • 125 - Null Values in Arithmetic Expressions HandsOn
  • 126 - Sub Query Theory
  • 127 - Sub Query HandsOn
  • 128 - Sub Query Types Theory Part 1
  • 129 - Sub Query Types Theory Part 2
  • 130 - Sub Query Types HandsOn Part 1
  • 131 - Sub Query Types HandsOn Part 2
  • 132 - What are Joins
  • 133 - How Joins work
  • 134 - Inner Joins Theory
  • 135 - Inner Joins HandsOn
  • 136 - Outer Joins Theory
  • 137 - Outer Joins HandsOn
  • 138 - Self Joins Theory
  • 139 - Self Joins HandOn
  • 140 - Cross Joins Theory
  • 141 - Cross Joins HandsOn
  • 142 - Set Operators Intro
  • 143 - Set Operators Union Theory
  • 144 - Set Operators Union HandsOn
  • 145 - Set Operators Union All Theory
  • 146 - Set Operators Union All HandsOn
  • 147 - Intersect Theory and Handson
  • 148 - Minus Set Operator Theory
  • 149 - Minus Set Operator Handson
  • 150 - String Function Introduction
  • 151 - String Functions Case Manipulation Theory
  • 152 - Adding and Removing Spaces Part 1
  • 153 - Adding and Removing Spaces Part 2
  • 154 - Adding and Removing Spaces Part 3
  • 155 - Adding and Removing Spaces HandsOn
  • 156 - Substring Theory Part 1
  • 157 - Substring Theory Part 2
  • 158 - Substring HandsOn
  • 159 - Substring Index Theory
  • 160 - Substring Index HandsOn
  • 161 - Instring and Locate Theory
  • 162 - Instring and Locate HandsOn

  • 6 - Data Warehouse
  • 163 - Transactional vs Analytical Processing
  • 164 - What is Data Warehouse
  • 165 - History of Data Warehouse
  • 166 - OLTP OLAP
  • 167 - Introduction to ETL
  • 168 - Extraction in ETL
  • 169 - Transformation Introduction
  • 170 - Types of Transformation
  • 171 - Load Data
  • 172 - Data Warehouse Architectures Introduction
  • 173 - Data Warehouse Architectures based on layers
  • 174 - Data Warehouse Architectures based on Tiers
  • 175 - What is Data Mart
  • 176 - Storing Data in Data Warehouse
  • 177 - Dimension Tables and Fact Tables
  • 178 - Dimension and Fact table with Example
  • 179 - Introduction to DWH Schema
  • 180 - Star Schema
  • 181 - Snowflake Schema
  • 182 - Fact Constellation Schema
  • 183 - SCD Introduction
  • 184 - SCD0 and SCD1
  • 185 - SCD type 2
  • 186 - SCD type 3
  • 187 - SCD type 4
  • 188 - SCD type 6
  • 189 - ETL Tools
  • 190 - Scheduling the Tools
  • 191 - Reporting Tools

  • 7 - Testing
  • 192 - Quality
  • 193 - Good Software Characteristics
  • 194 - What is Software Testing
  • 195 - Role of Software Testing
  • 196 - Introduction to SDLC
  • 197 - SDLC Phases
  • 198 - STLC
  • 199 - STLC Phases
  • 200 - Expectations from Software
  • 201 - Categories of the Requirements
  • 202 - Non Functional Testing
  • 203 - Test Case
  • 204 - Introduction to Test case Design Techniques
  • 205 - High Level Test Case Design Technique
  • 206 - Lower Level Test Case Design Technique Part 1
  • 207 - Lower Level Test Case Design Technique Part 2
  • 208 - Software Testing Phases
  • 209 - Unit Testing
  • 210 - Functional Testing
  • 211 - Integration Testing
  • 212 - System Testing
  • 213 - User Acceptance Testing
  • 214 - Regression Testing
  • 215 - What is Defect
  • 216 - Defect Life Cycle
  • 217 - Defect Parameters

  • 8 - ETL Testing
  • 218 - What is Datawarehouse
  • 219 - ETL
  • 220 - What is ETL Testing
  • 221 - Business Requirements Development in ETL Mapping
  • 222 - ETL testing with example
  • 223 - DataWarehouse Testing Life Cycle
  • 224 - Major Testing Phases
  • 225 - Metadata check
  • 226 - Meta Data Validation Handson
  • 227 - Data Mismatch Check
  • 228 - Data Completeness Validation with Record Count
  • 229 - RecordCountCheckHandson
  • 230 - Data Completeness Validation with Column Data Profiling
  • 231 - Column data Profiling Validation Handson
  • 232 - Data Completeness Validation with Data Duplicate Check
  • 233 - Duplicate Validation Handson
  • 234 - Data Accuracy
  • 235 - Data Accuracy Check Handson1
  • 236 - Data Consistency
  • 237 - Data Consistency Handson
  • 238 - Data Transformations Validation
  • 239 - Data Transformations Validation Example
  • 240 - Data transformation validation Handson
  • 241 - ETL Testing Data Validation Scenarios
  • 242 - Data Validation Approach for Scenario1
  • 243 - Data Validation Approach for Scenario2
  • 244 - Data Validation Approach for Scenario3
  • 245 - Data Validation Approach for Scenario 4 and 5
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 8842
    حجم: 9594 مگابایت
    مدت زمان: 1362 دقیقه
    تاریخ انتشار: 10 فروردین 1402
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید