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

  • cheatsheet-sql

    CheatSheet

Beginner
Intermediate
Advanced

Introduction

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

Fundamentals

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

Basic queries

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

Grouping

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

Tables combination

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

Action queries

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

Programming

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

Advanced

5 posts
Nothing to showAvanzado
  • Indexes
    5 min
  • Temporal structures
    5 min
  • Transactions
    4 min
  • TRY...CATCH
    4 min
  • JSON and XML Data
    4 min
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