Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Come and challenge the Transact SQL with these 50 exercises

Video Introducing this tutorial

Introduction :
Introduction
Small explanation on the subtitles

First of all set up your working environment :
What are we going to cover up to section 4?
Tools for working
Installation of SQL Server
Installation of Management Studio
First use of Management Studio
Exercise Create database and table
Exercise on database
Exercise on table.

Correction exercise Create database and table :
Correction exercise on database
Correction exercise on table

Exercise 1 to 5 on SELECT,UPDATE,INSERT,DELETE :
What are we going to cover up to section 8 ?
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Exercise 5

Correction Exercise 1 to 5 on SELECT,UPDATE,INSERT,DELETE :
Correction Exercise 1
Correction Exercise 2
Correction Exercise 3
Correction Exercise 4
Correction Exercise 5

Exercise 6 to 16 on Transact SQL Part 1 (DISTINCT,LIKE ...) :
Exercise 6
Exercise 7
Exercise 8
Exercise 9
Exercise 10
Exercise 11
Exercise 12
Exercise 13
Exercise 14
Exercise 15
Exercise 16

Correction Exercise 6 to 16 on part 1 (DISTINCT,LIKE.....) :
Correction of exercise 6 to 16

Exercise 17 to 25 on Part 2 (AND,OR, MIN,MAX...) :
What are we going to cover up to section 11 ?
Exercise 17
Exercise 18
Exercise 19
Exercise 20
Exercise 21
Exercise 22
Exercise 23
Exercise 24
Exercise 25

Correction Exercise 17 to 25 on part 2 (AND,OR, MIN,MAX...) :
Correction Exercise 17 to 25

Exercise 26 to 33 with the JOIN :
Set up exercises on the joins
Exercise 26
Exercise 27
Exercise 28
Exercise 29
Exercise 30
Exercise 31
Exercise 32
Exercise 33
Correction of exercise 26 to 33 for the joins.
Correction of exercise 26 to 33

Exercise 34 to 41 (SUBSTRING,CHOOSE,LEN,REPLACE...) :
Exercise 34
Exercise 35
Exercise 36
Exercise 37
Exercise 38
Exercise 39
Exercise 40
Exercise 41

Corrected exercise 34 to 41 :
Corrected exercise 34 to 41

Exercise 42 to 47 (Stored procedure and view) :
Exercise 42
Exercise 43
Exercise 44
Exercise 45
Exercise 46
Exercise 47
Corrected exercise 42 to 47
Corrected exercise 42 to 47