ETL Testing Training course videos will help you learn SQL, data-warehousing concepts, Informatica, ETL process, Pentaho, Data Integration techniques, Tableau, Business Intelligence Reports, creating dashboards and end to end ETL process scenarios with the help of real-time data.
SQL Concepts
SQL Concepts – Part 2
Use of ROW_NUMBER(),NTILE(),CAST()
String functions:LEN, LTRIM, RTRIM
LOWER, UPPER
REPLICATE, REVERSE, SUBSTRING
How to add blank spaces to column values
LEFT TRIM, RIGHT TRIM in a single command
Stored Procedure and Views
Stored procedure
View code from the back end of stored procedure
Parameterized and non Parameterized
View code from the back end of stored procedure
How to pass values for parameters
How to alter stored procedure
Introduction to Informatica
Installation of Oracle, Informatica
Installation of ETL tool Informatica
Use of Oracle in configuring Informatica Client and Server
Configuration of Server and Client tools
Role of oracle in Informatica
Download and Installation of SQL Developer
Commands in Oracle SQL plus,SQL Developer
Contact Us:
Whizdom Trainings
Call : (91)-8968585110, 8968929255
Email:- seleniumtraining10@gmail. com
Website:- https://www.etltestingtutorial.com/etl-testing-training
