SQL.tn training
Choose a complete learning path, a focused micro-course or a business project. Every item is checked before it is published.
Course explorer
20 results
4 resources currently available
From your first query to a complete business analysis: filters, calculations, dates, aggregations, joins and CTEs.
Understand why companies use databases, then write your first query to solve a real problem.
Build revenue indicators from fictional sales across several cities and channels.
Join orders, order lines and products to distinguish revenue, costs and margin by category.
Prepare metrics with aggregations, dates, CTEs and window functions.
Prepare clean, reliable data for your analytical models.
Practise common questions and realistic hands-on cases.
Understand the language, systems and dialects so you can choose the right documentation and write portable SQL with judgement.
Stop invalid data in the right place with types, keys and constraints.
Make several related changes succeed or fail together.
React to a data event without hiding business logic unnecessarily.
Reuse query logic and decide when its result should be materialized.
Read a simple plan and add an index only when it solves a measured problem.
Encapsulate database-side logic while understanding its cost and alternatives.
Grant only the access required and understand row-level security.
Provide Power BI with clean data at the right grain and make it easy to refresh.
Compare, rank and calculate changes without losing row-level detail.
Turn data-quality suspicions into repeatable, prioritised checks.
Prepare stock, rotation and coverage indicators for an operations team.
Turn order history into useful segments for a marketing team.