SQL
Learn databases, queries, joins, aggregations, subqueries, window functions, database design, and real-world SQL.
- Fundamentals
- Working With Data
- Functions
- Aggregation
- JOINs
- Intermediate SQL
Free programming education by Laviyx
Laviyx Learn teaches programming through simple explanations, real examples, exercises, and practical projects. Learn SQL, Python, C, C++, Java, HTML, CSS, JavaScript, TypeScript, React, Node.js, data structures, data analysis and machine learning, and go from your first line of code to confident, job-ready skills.
SELECT c.name, SUM(o.amount) AS total_spent
FROM customers c
JOIN orders o ON o.customer_id = c.customer_id
GROUP BY c.name
ORDER BY total_spent DESC;name | total_spent
-----+------------
Ravi | 560
Asha | 370Structured courses that take you from absolute basics to advanced topics, one clear lesson at a time.
Learn databases, queries, joins, aggregations, subqueries, window functions, database design, and real-world SQL.
Learn Python fundamentals, data structures, functions, OOP, files, APIs, projects, automation, and more.
Learn C fundamentals, functions, arrays and strings, pointers, memory management, structs, files, and the preprocessor.
Learn C++ fundamentals, functions, arrays and vectors, pointers and memory, OOP, the STL, templates, and modern C++.
Learn Java fundamentals, methods, arrays and strings, OOP, the Collections Framework, generics, streams, and modern Java.
Learn HTML elements, text, links, images, lists, tables, forms, semantic layout, media, accessibility, and SEO basics.
Learn CSS selectors, the cascade, the box model, colors, typography, Flexbox, Grid, responsive design, transitions, and animations.
Learn JavaScript fundamentals, functions, arrays and objects, the DOM, events, async/await, fetch, classes, modules, and Node.js.
Learn TypeScript types, interfaces, unions, narrowing, generics, classes, utility types, modules, and tsconfig.
Learn Big O, arrays and hashing, linked lists, stacks and queues, sorting, trees, heaps, graphs, greedy algorithms and dynamic programming.
Learn NumPy, pandas, data cleaning, grouping and pivot tables, time series, statistics, hypothesis and A/B testing, and charts with matplotlib and seaborn.
Learn React components, JSX, props, state, events, forms, effects, data fetching, context, custom hooks, performance, TypeScript, routing and testing.
Learn Node.js and Express: modules, npm, files, streams, the event loop, HTTP servers, routing, middleware, validation, REST APIs, databases, authentication, security, testing and deployment.
Learn regression, classification, trees and boosting, model evaluation, clustering and PCA, neural networks with PyTorch, text and embeddings, LLM APIs, and deploying models.
Good places to start, or to fill a gap.
Built for people who want to actually understand what their code does.
Complex programming concepts explained clearly, with jargon defined the moment it appears.
Every major concept includes practical code and the exact output it produces.
Exercises follow lessons, each with a hint and a worked solution.
Structured learning paths instead of random articles, so nothing important is skipped.
Every lesson is free to read. Learn about our approach
Get new tutorials, coding challenges, and cheat sheets.