PART 1 - ROAD MAP from Non-Tech to Big Data Testing

I will divide this into 2 parts –

a.???IT – already working in IT companies or some IT-related role.

b.???& Non-IT

?????????i.???I will consider all – from BA, B. Com, BCA & other degree as non-IT)

????????ii.???Even those who are working in non-it-related roles like Support

????????iii.???IT support or HR, or Facility, etc.

It is difficult directly to enter the Big Data space. So, let’s go to the screen & check the ROAD MAP.

I would recommend you all start with ETL/DWH & then the next step should be either cloud or Big Data.

Do not jump! Some may make it & some may slip. It is my humble advice no to jump. Rather learn ETL/DWH Testing first.

FIRST STEP – Learn basic terminologies used in IT. For example – what is a table, what is the frontend, and what is the backend? What is a column, row, metadata, flat file, BI tool, users, DBMS, Database, or RDBMS? Etc. etc.

SECOND STEP – Learn DWH concepts.

1. What is DWH? History?
2. Languages used to deal with Data.
3. Need of DWH?
4. OLTP, OLAP.
5. What is ETL?
6. Characteristics of DWH.
7. Normalization, denormalization.
8. ETL architecture.
9. Types of Data models
10. Types of schemas – star, snowflake
11. ETL Project architecture – I have explained that in the previous video. I will link it in the I button on top.

THIRD STEP – SQL Learn & Practice. I would recommend you to learn oracle.

1. What is SQL?
2. Learn about Datatype, variables, and syntax.
3. Learn about DDL, DML, TCL, and DCL.
4. Create, alter, drop, etc. practice them.
5. DMLs – insert, update, delete, select, truncate.
6. As a tester, we will mostly be working on Select commands, but we should have good knowledge of other DDLs, like create, update delete.
7. Clauses – distinct, order by, where, group by, having.
8. And & or conditions.
9. FUNCTIONS (Character/String functions, Aggregate functions, Analytical functions, Date functions)
10. SET OPERATORS – union, union all, interest, minus, etc.
11. CONSTRAINTS – unique, not null, primary key, foreign key, etc.
12. JOINS – inner, cross, self, outer (left, right, full)
13. SUB-QUERIES
14. VIEWS
15. You do not have to master everything. If you just complete the above-mentioned topics, you are good to crack interviews.
16. I have not mentioned a lot of things, but this all is a good start. There are some more things, I will add them in the coming videos.

FORTH STEP – UNIX – this is one of the most important parts.

1. This is like the lungs of ETL/DWH/Big Data tester.
2. SQL is the heart & UNIX is the lungs.
3. As I mentioned you do not have to be an expert, but you should have good knowledge.
4. I would recommend you to please install the virtual box & install any of the Linux environments & practices.
5. Please comment if you need a tutorial on UNIX commands & setting up the environment.

FIFTH STEP – TESTING CONCEPTS - The video will become lengthy if I discuss this. I would set a target of 50 likes, and comment TESTING in the comments. I will come up with a video on these topics.

LAST BUT MOST IMPORTANT – ETL TESTING CONCEPTS.

1. This is one of the most important for you to crack the interview.
2. As I said in the previous section, the video is already lengthy.
3. Please Comment ETL, I will come up video on this.
4. More the comment, that topic will come first. You all decide.

Watch the Video on Techie Krishna Kayaking - https://www.youtube.com/user/Kayaking22

VIDEO - ROAD MAP - Non-Tech to Big Data Testing | Krishna Kayaking | Video#005 #testing #bigdata #etltesting - https://youtu.be/aK9jWkfS-wM

------

ROAD MAP FROM NON-TECH TO BIG DATA TESTING

--------------------------------------------------------------------------------------

Part 1 - https://www.dhirubhai.net/pulse/road-map-from-non-tech-big-data-testing-krishna-kayaking/?trackingId=%2BfsHVpMkQo2sM8Q6PvEl%2FQ%3D%3D

Video 1 - https://www.youtube.com/watch?v=aK9jWkfS-wM

--------

Part 2 - https://www.dhirubhai.net/pulse/road-map-part-2-from-non-tech-big-data-testing-krishna-kayaking/?trackingId=q2S%2Bw2SXT8ethb5kU8tgrw%3D%3D

Video 2 - https://www.youtube.com/watch?v=sw8gzSqBeqo

--------

Part 3 – https://www.dhirubhai.net/feed/update/urn:li:ugcPost:6996484383201267714?updateEntityUrn=urn%3Ali%3Afs_updateV2%3A%28urn%3Ali%3AugcPost%3A6996484383201267714%2CFEED_DETAIL%2CEMPTY%2CDEFAULT%2Cfalse%29

Video 3 – https://youtu.be/7mgYcvJUkOU

===========================

Follow me on Social Media - Krishna Kayaking -

LinkedIn - https://www.dhirubhai.net/in/krishnakayaking

Instagram - https://www.instagram.com/krishnakayaking/

FB - https://www.facebook.com/krishnakayaking/

Twitter - https://twitter.com/krishnakayaking

#video #youtube #krishnakayaking #techieKrishnaKayaking #techie #techies #ITlife #informationtechnology #engineering #career #careergrowth #education #testing #BigData #ETL #DWH