SQL Interview Questions for ETL Testers & Data Engineers (MUST KNOW!)
DDL for creation of the tables
-- Create the table
CREATE TABLE transactions (
source VARCHAR2(50),
target VARCHAR2(50),
messages NUMBER
);
-- Insert the data
INSERT INTO transactions (source, target, messages) VALUES ('Ravi', 'Ram', 20);
INSERT INTO transactions (source, target, messages) VALUES ('Ram', 'Ravi', 30);
INSERT INTO transactions (source, target, messages) VALUES ('Suri', 'Satti', 5);
INSERT INTO transactions (source, target, messages) VALUES ('charan', 'Satti', 10);
-- Commit the transaction
COMMIT;
SELECT * FROM transactions;
CREATE TABLE CUSTOMERS(CUSTID NUMBER(10),CUST_NAME VARCHAR2(20),TYPE_OF_TRANSACTION VARCHAR2(30),AMOUNT NUMBER(10));
INSERT INTO CUSTOMERS VALUES(111,'Ravindra','DEPOSIT',100000);
INSERT INTO CUSTOMERS VALUES(111,'Ravindra','WITHDRAWAL',10000);
INSERT INTO CUSTOMERS VALUES(112,'Surendra','DEPOSIT',200000);
INSERT INTO CUSTOMERS VALUES(112,'Surendra','WITHDRAWAL',24000);
commit;
SELECT * FROM CUSTOMERS;
#sql #sqlinterview #etl #etltesting #dataengineering #dataengineer #interviewquestions #sqltips #learnsql #database #coding #technology #careeradvice