Part 1: ETL Testing

ETL Testing
--------
1) What is Data ware housing
2) Features of data warehouse
3) OLTP & OLAP Systems
4) Database V/s Data warehouse
5) ETL V/S Database Testing
6) What is Data model
7) Types of Data models
8) Star schema & Snowflake schema
9) SCD (Slowly Changing Dimensions )
10) ETL V/S BI Tools

#########################
Udemy Courses:
#########################

Manual Testing+Agile with Jira Tool
************************************

Selenium with Java+Cucumber
********************************

Selenium with Python & PyTest
********************************

Selenium with python using Robot framework
****************************************

API Testing(Postman, RestAssured & SoapUI)
*****************************************

Web & API Automation using Cypress with Javascript
********************************************

Playwright with Javascript
**************************

Jmeter-Performance Testing
************************

SDET Essencials(Full Stack QA)
*************************

Appium-Mobile Automation Testing
************************************

Java Collections
*****************

Python Programming
*********************

Cucumber BDD Framework
***************************

Protractor with Javascript
***************************

####################################
Youtube Playlists:
####################################

Manual Testing & Agile
***********************

SQL
****

linux & Shell Scripting
**********************

Java
*****

Selenium With Java+Cucumber
********************************

Python
***************************

Selenium With Python,Pytest&Behave
***************************************

Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************

API Testing (Postman,SoapUi,&Rest Assured)
**********************************************

Mobile App Testing Appium
****************************

Performance Testing Jmeter
*******************************

Maven,Jenkins,Git,Github,CI/CD
*******************************

SQL,DB Testing&ETL,Bigdata
*******************************

JavaScript Based Automation Tools
********************************

Selector Hub Tools
********************

GraphQL
******************

Cypress API Testing
********************

Cypress Web Testing
**********************

Playwright with Javascipt
**************************

#ETLTesting
#DataQuality
#DataIntegration
#DataValidation
#ETLValidation
#DataWarehouse
#DataETL
#ETLProcess
#ETLTools
#ETLBestPractices
#ETLAutomation
#ETLChallenges
#DataTransformation
#DataExtraction
#ETLFramework
#ETLPerformance
#ETLArchitecture
#DataMigration
#ETLStrategy
#DataLoad
#ETLApproach
#ETLAnalysis
#ETLValidationFramework
#DataCleansing
#ETLTestingMethodology
#ETLToolset
#ETLTestingLifecycle
#DataETLProcess
#ETLTestScenarios
#ETLTestingStrategies
#DataWarehouseTesting
#ETLTestingAutomation
#ETLDataFlow
#ETLTestingChallenges
#ETLPerformanceTesting
#DataMigrationTesting
#ETLQualityAssurance
#ETLTestingApproach
#ETLValidationProcess
#DataTransformationTesting
#ETLRegressionTesting
#ETLReportTesting
#ETLDocumentation
#ETLDataValidation

[mdislam]

1) What is Data ware housing
2) Features of data warehouse
3) OLTP & OLAP Systems
4) Database V/s Data warehouse
5) ETL V/S Database Testing
6) What is Data model
7) Types of Data models
8) Star schema & Snowflake schema
9) SCD (Slowly Changing Dimensions )
10) ETL V/S BI Tools

[kishorshitole]

Thank you Sir, Your are my one of the favourite Teacher. Your teaching style and language is very nice and understandable.Thank you again.also thankfull to Youtube platform because of them we have exellent teachers like you.(in marathi-ek divas tumchya paaya padayala yeyil sir)

[dbz]

I am new to this but still i understood 100% what he said. thank you so much for explaining so lucidly.

[ANIMABAIN]

Star schema resembles a star with points radiating from a center table(fact table) which has primary keys from dimension tables whereas snowflake schema is an extension to star and the dimensional table is normalized into multiple lookup tables. And Fact constellation Schema has more than one fact table and looks like a network.

[nishakhan]

My all time fav teacher.. You are very good in teaching, As a non tech person even I could understand easily.. Thank you so much !!

[Friendsforever-rgbq]

Great Sir..! Very Informative sessions

[jhansijhanu]

Thank you so much for your valuable explanation sir .your explanation is Cristal clear.

[shraddhatandale]

Very Informative & knowledgeable content...Thanks !

[hgucclp]

Good course and well explained. There is some lag between the screen display and the voice over. From 1:20:30 duration, displayed screen and the explained topic is not syncing, may be some part of the screenshare is not visible.

[upendrachary]

Correction (1:11:56)In the fact table every column Is a foreign key which Is having a relationship with dimensions table primary key ( need correction)
And also the table can hold only one primary key or composite key
Please make a correction

[manishashaw]

Thank you so much for this session, cleared all my doubts related to ETL

[BondWith]

Eey opener, thanks for the intentions of explaining the theme of technolgies in details sir.

[telugintisampradhayam]

Tnq so much sir
Very informative topic sir.

[SURESHREDDY-cmvt]

Excellent presentation, so could you please do the "REAL TIME- ETL Project"

[jambannapoojar]

Could you please add intermediate and advanced concepts of ETL testing?

[singhji]

I just love your way of teaching, I'm happy that I got a mentor on YouTube who does his job with whole dedication❤Thanks a lot Sir!

[ManishKumar-niyw]

🙏🙏🙏🙏🙏🙏 Thanks alot for this crystal clear

[ganeshgodase]

Fact table contains the foreign keys that are associated with diamensional table . And diamensional table contains primery keys . Each table has only one primary key .

[Fishing_brothers-twwj]

Sir is good way for manual tester skip to ETL tester could you please give me information ASAP Sir

[daryn]

I love that during recording he only has 2 people watch but I am the 250, 000th person to watch this on YT. lol