The SQL Academy

Let's create our first stored procedure ! | SQL Server

The CROSS APPLY and OUTER APPLY | SQL Server

The global table | SQL server

SQL Server: The 28 hour Masterclass course (9 courses in 1) !

Learn the INCLUDE clause on your index | SQL server

BACKUP WITH COMPRESSION AND WITH MIRROR | SQL server

Let's see a simple CTE and derived table | SQL Server

The different database recovery model in SQL Server | SQL server

How to delete and modify the name of a database ? | SQL Server

How to register on the ELOA FORMATION platform?

Filtered indexes and the cache plan | SQL server

The table SCAN | SQL server

DATEADD and DATEDIFF | SQL Server

DATENAME/DATEPART/GETUTCDATE and GETDATE | SQL Server

CONCAT and CONCAT_WS | SQL Server

The function type table | SQL server

How to restore all the system database ? | SQL server

CAST and CONVERT | SQL Server

How restore a PAGE from a BACKUP in SQL ? | SQL Server

Do you know the covering Index | SQL server

The columns with numeric types INT,SMALLINT,BIGINT,TYNINT | SQL Server

How to RESTORE from a snapshot with SQL server ? | (Simple example)

Let's discover the scalar function | SQL server

How to make a Simple BACKUP and RESTORE | SQL server

TRY_CONVERT and TRY_CAST | SQL Server

The OVER clause with PARTITION BY | SQL Server

Welcome to the ELOA formation website | 200 hours of SQL for 4$ per month

How to make SQL Server BACKUPS go faster ? | SQL Server (with multiple files)

SQL Server 2022: The complete course for beginners (6 hours of class)

Structure of the clustered index with a non clustered index | SQL server

Indexing and column order | SQL server

DROP IF EXISTS | SQL Server

LEFT JOIN VS NOT IN VS NOT EXISTS | SQL Server

The analytical functions FIRST_VALUES and LAST_VALUES | SQL Server

LEN and REPLACE | SQL Server

RESTORE WITH STANDBY | SQL server

Tracking page splits | SQL server

Learn to consolidate your indexes! | SQL server

RESTORE moving the directory files | SQL server

How to create a fantastic database ? | SQL Server

The comments and square brackets utility on SQL | SQL Server

What is a CHECKPOINT on a SQL Server engine ? | SQL Server

Définition and création of a clustered index | SQL server

Avoid an index clustered on a NEWID column ! | SQL server

What is a TAIL LOG BACKUP in SQL ? | SQL Server (simple example)

Do you know the OFFSET FETCH NEXT ROWS ? | SQL Server

CHARINDEX, RESERVE and REPLICATE | SQL Server

How to RESTORE just a single page ! | SQL server

The columns with DATE types DATETIME2,DATETIME,DATE,SMALLDATETIME

STRING SPLIT/STUFF | SQL Server

Comparison operators = != and so on | SQL Server