NRI Subscriber(South Africa)| Bigdata Interview | Part-1 | Spark, HDFS, Hive, Sqoop,Hbase | Feedback

[@butchiraju9582]

How to register for hadoop,spark mock interview

[@cleverstudies]

Pls send your resume to [e-mail]

[@dipteshroy9719]

Interviewer wont allow candidate to explain so much in detail and will be pissed. Answer should be precise and to the point.

[@haquehadoop8088]

true

[@rameshroshan8934]

next interview 1-1 hour 3 interviews but end end concept clear ful biga data , just start basics next part 2--part 3---- full big data concepts interview level finished LOL ITS TRUE CLEVER INTERVIEW FOR CLEVER PROGRAMMERS LOL STISFIED KEEP DOING GOOD WORK

[@rameshroshan8934]

sir humble request please create sql intermediate series a concept and how its asked interview ,this will help as Source Mishra youtube channel Most asked questions Important DBMS & SQL Query Topics For Data Engineering Interview Basic-Medium 1. Relations, Schema Design, E-R Diagrams 2. Primary Key, Foriegn Key, Composite Key, Surrogate Key 3. Normalization & Denormalization 4. ACID Properties 5. Transactions 6. Transaction Concurrency 7. Concurrency Control 8. Indexing 9. Types of Indexing 10. DDL, DML, DCL 11. Integrity Constraints 12. Difference between Delete & Truncate? 13. Which one is faster count(*) or count(1)? 14. All type of joins 15. Queries related to SELF JOIN 16. What is NULL SAFE Join 17. Queries related to Group By & Having clause 18. Use of Where clause along with Group by 19. CASE-WHEN statement 20. Group by aggregation with CASE-WHEN statement 21. Use of WITH Clause 22. Difference between any, all & exists 23. Difference between Union & Union All Advance 1. Difference between Views & Materialized Views 2. When to use Stored procedures & how can we create dynamic Stored procedures 3. Queries related to Window Functions - Difference between Rank(), Row_Number(), Dense_Rank() - Over clause with Partition By & Order By - Aggregation in Window functions like Sum(), AVG(), MIN() MAX(), FIRST_VALUES(), LAST_VALUE() - Use of LAG() window function - Queries for running SUM/AVG etc in Window functions -> Rows Between -> Unbounded preceding

[@rameshroshan8934]

thse 2 should be there in SIR your youtube at any cost 1 sql 2 ds algo trust me if these are 4/5 certainly you can take just candidate takes 2 months beat expereinced developers of 10 years, simple after KT --- 2months inside company task done whereas if you take without this 2 skills some or other time resource will bottleneck if and only if these 2 skills are not good 1 SQL 2 DS ALGO probably java relate with scala and for him python is cakewalk or else please see history who bagged above 40 lacs surely they must be very good at these 2 skills. rest 2 months inside on the job they can learn big data

[@rupeshdeoria1]

I believe parquet is not default support by hive we need to extend jar...

[@ratanUtube1]

Request you to make more such videos.

[@ratanUtube1]

waiting for part 2 :)