Chandoo - Tech in Telugu

Easily crack your SQL Interview with these Questions [తెలుగు]

SQL interview వుందా? అయితే ఈ వీడియొ మీ కోసమే. ఇందులో నా favourite top 10 questions, వాటి answers చెప్పాను. ఇవి నేర్చుకుని మీ interview లో కుమ్మెయండి 👍 Video timestamps: 0:00 - Why SQL is important 0:50 - Top 10 SQL Interview Questions 1:52 - Q1 3:36 - Q2 6:09 - Q3 8:33 - Q4 10:05 - Q5 12:38 - Q6 15:03 - Q7 16:22 - Q8 18:20 - Q9 20:15 - Q10 23:05 - Closing Remarks & Advanced Concepts 5 Extra SQL Interview Questions (technical) 1) What is the difference between a CTE & a sub-query? Demonstrate with an example. 2) We have 4 sales teams, and each have multiple salespersons. How do I see the total sales by salesperson, their % of entire company sales and % of team sales? Explain the logic and approach. (hint: you can use window functions) 3) Have you used SQL in a programming language like Python? Explain why and how you used it? 4) Give an example of LAG window function in SQL 5) How would you process JSON data with SQL? 50 More SQL Queries: Web page: https://chandoo.org/wp/learn-sql-for-data-analysis/ Video: https://youtu.be/l8DCPaHc5TQ Learn SQL (basics to advanced playlist): Full SQL Course in Telugu - https://youtu.be/IkUTX9WerXA English Videos (on my English YouTube channel): SQL Basics https://youtu.be/Iceaqdy7mEs SQL for Data Analysis in 1 hour https://youtu.be/l8DCPaHc5TQ SQL Joins https://youtu.be/xkYpNfpmbGY 10 Advanced SQL Examples https://youtu.be/Ejxam_CBY9U SQL with Power BI - Live Demo https://youtube.com/live/UQJAHUUFK-o ~ Select candidate, job from candidates join jobs on jobs.job_id = candidates.job_id where candidate="you" #SQL #interview