The SQL Academy

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

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

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

How to register on the ELOA FORMATION platform?

Tracking page splits | SQL server

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

Improve performance by deactivating the indexes | SQL server

Filtered indexes and the cache plan | SQL server

What is a filtered index ? | SQL server

Learn to consolidate your indexes! | SQL server

Indexing and column order | SQL server

Let's discover the UNIQUE index | SQL server

Learn the INCLUDE clause on your index | SQL server

Be careful about the duplicate index | SQL server

Do you know the covering Index | SQL server

The table SCAN | SQL server

The table SEEK | SQL server

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

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

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

How to restore all the system database ? | SQL server

BACKUP WITH COMPRESSION AND WITH MIRROR | SQL server

BACKUP WITH BUFFERCOUNT and MAXTRANSFERTSIZE | SQL server

Learn how to simply clone your database ! | SQL server

How to RESTORE from a LSN (log sequential number) ? | SQL server

Restore from a SNAPHOT | SQL server

BACKUP WITH COMPRESSION AND WITH MIRROR | SQL server

RESTORE WITH STANDBY | SQL server

RESTORE WITH STOPAT | SQL server

How to RESTORE just a single page ! | SQL server

BACKUP WITH CHECKSUM | SQL server

The different database recovery model in SQL Server | SQL server

RESTORE moving the directory files | SQL server

BACKUP WITH COPY_ONLY | SQL server

BACKUP WITH INIT | SQL server

Differential BACKUP and RESTORE | SQL server

BACKUP and RESTORE LOGS | SQL server

How to make a Simple BACKUP and RESTORE | SQL server

The temporary table | SQL server

The global table | SQL server

The variable table | SQL server

Let's discover the scalar function | SQL server

The function type table | SQL server

Let's see the définition and the création of a schéma | SQL server

Add, modify, delete, rename a column | SQL server

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

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

The columns with string types CHAR and VARCHAR | SQL Server

How to declare a variable in a Stored procedure ? | SQL Server

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