Upskly Quizzes

SQL is one of the most in-demand and fundamental skills for any data analyst, business analyst or data scientist role – most interview processes test it directly. Practice covers everything from SELECT and filtering basics through joins, subqueries, CTEs and recursive queries, window functions (ranking, aggregates and offsets), indexing, query performance and execution plans, up to classic SQL interview patterns.

Python is the core programming language behind most data science, analytics and automation work. Practice starts with core language fundamentals – data types, control flow, functions, closures, OOP, decorators and concurrency – then moves into NumPy and pandas for real data handling, and finishes with data visualization using Matplotlib and Seaborn.

Data Structures and Algorithms remain a core part of technical interviews for data and software roles alike. Practice covers time and space complexity, arrays and two pointers, hashing, linked lists, trees and binary search trees, graphs (BFS/DFS), sorting and binary search, recursion and dynamic programming, and heaps.

Excel is still one of the most widely used tools in business, analytics and finance roles, and a common screening round for analyst positions. Practice covers logical and text functions, lookup and reference functions like XLOOKUP, SUMIFS and COUNTIFS, PivotTables, data cleaning and validation, Power Query, financial functions and What-If analysis – plus Google Sheets formulas.