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

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 دقیقه
    تاریخ انتشار: ۱۰ فروردین ۱۴۰۲
    طراحی سایت و خدمات سئو

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