LuisLlamas Logo

Luis Llamas

  • Home
  • Courses
  • Playgrounds
    • Interactive
    • From scratch
    • CheatSheets
    • Quizs
  • Sections
    • Arduino
    • ESP32
    • Linux
    • 3d printing
    • Electronic
  • Articles
    • Technology
    • Development
    • Computing
    • Portfolio 3D
    • Projects
  • Spanish
  • English
Home
  • Spanish
  • English

Sections

  • Courses
  • Engineering
  • Arduino
  • ESP32
  • Computing
  • Development
  • Raspberry Pi / Linux
  • 3D printing
  • Electronics
  • Design
  • Home
  • Courses
T-SQL course

T-SQL course

Aprende SQL, the language for querying and managing databases

  • sql-from-scratch

    From zero

  • sql-roadmap

    Roadmap

  • cheatsheet-sql

    CheatSheet

Beginner
Intermediate
Advanced

Introduction

2 posts
Nothing to showIntroducción
  • What is T-SQL?
  • Relational Databases

Fundamentals

6 posts
Nothing to showFundamentos
  • Basic T-SQL Syntax
  • Creation and Deletion of Databases
  • Creating and Modifying Tables
  • Relationships Between Tables
  • Data Types
  • Constraints

Basic queries

7 posts
Nothing to showConsultas básicas
  • Querying with SELECT
  • Filtering with WHERE
  • Comparison Operators
  • Sorting with ORDER BY
  • Limiting Results with TOP and OFFSET-FETCH
  • Scalar Functions
  • CAST and CONVERT Conversion Functions

Grouping

5 posts
Nothing to showAgrupamientos
  • Grouping with GROUP BY
  • Filtering Groups with HAVING
  • Aggregate Functions
  • Window Functions ROW_NUMBER, RANK
  • Aggregations with OVER and PARTITION BY

Tables combination

6 posts
Nothing to showCombinación de tablas
  • Combining Tables with JOIN
  • INNER, LEFT, RIGHT, and FULL JOIN
  • Multiple Table Joins
  • Subqueries
  • Common Table Expressions (CTE)
  • The CROSS APPLY and OUTER APPLY

Action queries

4 posts
Nothing to showConsultas de acción
  • INSERT Data
  • UPDATE Data
  • DELETE Data
  • Truncating Tables TRUNCATE TABLE

Programming

6 posts
Nothing to showProgramación
  • Variables
  • Conditional Structures CASE and IF...ELSE
  • The WHILE Loop
  • User-Defined Functions
  • Stored Procedures
  • Triggers

Advanced

5 posts
Nothing to showAvanzado
  • Indexes
  • Temporal structures
  • Transactions
  • TRY...CATCH
  • JSON and XML Data
LuisLlamas Logo

Luis Llamas

Engineering, computing and design

Except where expressly noted, the contents of this site are provided under a Creative Commons License BY-NC-SA.

creative-commons-license
discord-logo
Copyright ©2026, All rights reserved
  • Legal notice