SQL Test for Data Analyst Job Interview | Intermediate Level

Level up your SQL skills with this in-depth walkthrough of an intermediate SQL test! In this video, we tackle a set of real-world SQL questions designed to test your command of intermediate concepts. Each question is broken down step-by-step, revealing the thought process and logic behind each answer so you can learn to tackle similar challenges on your own. Topics Covered: 1. Data Selection, Aggregation & Ordering - Begin by selecting, aggregating, and ordering data effectively. 2. Conditional Filtering with Multiple JOINs - Handle complex data relationships with multiple JOINs while applying conditions. 3. Advanced Aggregations - Learn to use SUM and other aggregation functions to draw insights from data. 4. Combined Aggregations with JOINs - Apply multiple aggregations alongside JOINs for more comprehensive data analysis. 5. Conditional Aggregation - Explore techniques to filter within aggregations, enabling flexible data insights. 6. Creating New Columns & Complex Logic - Master CASE/IFF statements, identify missing data, and use JOINs and UNIONs to manipulate data dynamically. This video is perfect for those looking to bridge the gap between beginner and advanced SQL skills, preparing for intermediate SQL tests, or enhancing their SQL toolkit for practical applications. By the end of this session, you’ll be ready to approach intermediate SQL tasks with confidence and clarity. 🔔 Don’t forget to like, share, and subscribe for more SQL tutorials, coding strategies, and interview prep tips to take your SQL skills to the next level! 🔗 Chapters: 00:00 – Intro 01:04– Raw Data 02:05 – Question 1: Aggregation and Condition 04:04 – Question 2: Joins, Aggregation and Condition 08:44 - Question 3: Joins, Aggregations, Cleaning and sorting 13:55 – Question 4: Joins, Conditions, Cleaning, NULL values 17:50 - Question 5: Missing Values & Sub-Queries 19:55 – Question 6: Missing Values & Sub-Queries Github Link: https://github.com/Pitsillides91/SQL-Tutorials-/tree/main/SQL_Videos_2024/SQL_Test_Intermediate Connect with me on LinkedIn: https://www.linkedin.com/in/yiannis-pitsillides-8b103271/ Follow me on X: https://x.com/pitsillides91 EXCEL: Excel top 5 Interview Questions: https://youtu.be/lp0NwAIcw_c?si=32mHS-_e7U4eYKc2 Excel top 7 Most Used Formulas: https://youtu.be/VvgQjxsHnMQ?si=2EOabWWRNnCpzBT8 Excel Interview Test – Junior: https://youtu.be/p6I3xXYmn2s?si=4k3U5xlPXFwPtXG2 Excel Interview Test – Intermediate: https://youtu.be/ZrWrxF2doRc?si=r5DtQa7dbrHbEJ9v Excel Interview Test – Difficult: https://youtu.be/QGQCW6s_r7A?si=ZLVka_wEBSq6HYFP Excel Interview Test – Average Part 1: https://youtu.be/FEyV96xE0fU?si=tVobgo9Oh9kCBir_ Excel Interview Test – Average Part 2: https://youtu.be/eCN5PuQBMqk?si=cHMgh0zvugLBPGk6 SQL: SQL Tutorial from scratch part 1: https://youtu.be/Xr2xg_u-wzo?si=od0FCH3u0VeY4QC3 SQL Tutorial from scratch part 2: https://youtu.be/bEeHNeED8zg?si=zhJgRA5qMx7QMZmY SQL Tutorial JOINs: https://youtu.be/V4aMAU9VLNo?si=Jd_yWYOijcAzlf9f SQL Top 5 Interview Questions: https://youtu.be/FTamRSw-sFM?si=C4ob1-Ne_Z5sVzV9 SQL Interview Test – Beginner: https://youtu.be/b4Fx5DfrN14?si=ze6IhkC5-qM1mKhk SQL Interview Test – Junior: https://youtu.be/AcNh0cWGYeM?si=orYDlZpodJ2rokAW SQL Interview Test – Intermediate: https://youtu.be/OjQjHd9CT3o?si=7RkBtWkX8qXKc4Qh SQL Interview Test – Difficult: https://youtu.be/edDrSXdRtmE?si=4mUd1EppJT6MNDpK PYTHON: Python Tutorial from Scratch Part 1 – https://youtu.be/nZyKxP04co4?si=zNzr4qyW_CUGQZFO Python Tutorial from Scratch Part 2 - https://youtu.be/JjFifnK3bVg?si=K34fpCUTH2UiDMpy Python Tutorial from Scratch Part 3 JOINS - https://youtu.be/tMv74JmjZ_Y?si=-14Y9Z3X14rlfGWj Python Tutorial from Scratch Part 4 Visuals - https://youtu.be/SQfEeFNAvdE?si=ifkieyVkylFey-PU Python Tutorial from Scratch Part 5 Visuals - https://youtu.be/CsqCLaLMGn4?si=hXOlixcYk0qBLgnE Python top 5 Interview Questions: https://youtu.be/rI0L8qxydZ0 Python Interview Test – Beginner: https://youtu.be/idANfk_F3NY Python Interview Test – Junior: https://youtu.be/xxrn8Uf_7ZA Python Interview Test – Intermediate: https://youtu.be/e02W-jsMaKU Python Interview Test – Difficult: https://youtu.be/e02W-jsMaKU