53 free lessons on SQL and SQL Server, from your first query to triggers. Many examples run right here in your browser, with nothing to install.
Try it: how much has each customer of the course shop spent?
Seven parts, in order. Each one builds on the previous, but you can jump into whichever you need.
What SQL is, how a relational database is organised and how to install SQL Server to follow the course.
Build the course shop database and learn to insert, update and delete rows.
SELECT, filters, sorting, grouping, JOIN and subqueries. Every lesson has runnable examples.
CTEs, EXISTS, window functions such as ROW_NUMBER and LAG, running totals and PIVOT: the SQL that comes up in interviews.
Variables, operators, IF, WHILE, transactions and error handling in Transact-SQL.
SQL Server built-in functions and how to write your own.
Views, stored procedures and triggers: logic that lives inside the database.
SQL is the language. SQL Server, PostgreSQL and MySQL are databases that speak it, each with its own accent: the core is the same and the details change.
Lesson syntax
Microsoft's database. Widely used by companies built on the Microsoft ecosystem, from Excel and Power BI to Azure.
Editor engine
Open source, very close to the standard and with powerful extensions such as PostGIS. A favourite of many startups and data teams.
Open source and owned by Oracle. For years it was the database of the web: it powers WordPress and much of shared hosting.
A fork of MySQL created in 2009 by its original author. It's compatible with MySQL in almost everything and is the default in several Linux distributions.
A database in a single file, with no server. It's built into phones, browsers and thousands of applications.
Oracle's commercial database, designed for very large and critical systems.
In SQLearning we will learn in a didactic way with replicable examples all the most important concepts of Transact-SQL management, from the simplest to the most advanced ones
In SQLearning we will learn in a didactic way,with replicable examples, the most important concepts of handling Transact-SQL, from the simplest one to the most advanced.
With Transact-SQL we will learn the entire SQL standard, plus the characteristics of said language (Stored Procedures, Triggers,...).
The answer largely depends on the needs of each user. However, from SQLearning we facilitate the learning of Transact-SQL since it is used more in small and medium-sized companies while ORACLE is more frequently used in large organizations.
The use and handling of databases is present in innumerable applications and technologies, which makes SQL one of the most demanded programming languages today.
Any person who wants to work with data management (analysts, data scientists...), backend-fullstack developers, mobile application developers... In addition, SQL should be learned by anyone interested in the use and management of databases.
Yes, SQL is often used externally from other programming languages. C, Java or Python are some examples.
