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, machine learning, Git, Linux, Docker and system design, 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.
Learn commits, branches, merging and conflicts, GitHub, pull requests, team workflows, GitHub Actions, rebase, reset and the reflog, and how Git works inside.
Learn the Linux command line, files, grep, sed and awk, permissions, processes, systemd, SSH, cron and Bash scripting, from your first command to safe automation.
Learn containers, images, Dockerfiles, volumes, networks, Docker Compose, security and CI/CD, then Kubernetes pods, deployments and services.
Learn how large systems are built: estimation, scaling, load balancing, caching, databases, sharding, queues, reliability, and worked designs for popular interview questions.
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.