Skip to content

Ensias TP about data warehouses using SQL Server and Docker

Notifications You must be signed in to change notification settings

Ignema/MSSQL-DTW-TP

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Microsoft SQL Server Datawarehouse TP

This repository is an attempt to solve the series of assignments presented during an ensias's course about datawarehouses. However, I will be using docker which means it will be slightly harder to implement, but I think it's worth it because containers are much more flexible and portable than establishing a local database.

Answers

Atelier Location
Installation et Exploration des bases de données AdventureWorks2019 et AdventureWorksDW2019 Atelier 1
Mise en place d’un Datawarehouse Atelier 2
Loading Data and Using Data Compression and Indexes Atelier 3
Extraction de données à partir d’un fichier plat Atelier 4
Slowly Changing Dimensions Atelier 5
Analyse et édition de rapports des données OLAP Atelier 6
Création et Mise en œuvre d’un DTW pour l’analyse des données de vente sur internet Projet

How to setup the environment

1. Make sure you have Docker downloaded

2. Clone this repository

git clone https://github.com/Ignema/MSSQL-DTW-TP.git

3. Navigate inside the folder and then build the docker image by using the provided Dockerfile

docker build . -t <IMAGE-NAME> --build-arg SERVER=<SERVER-NAME> --build-arg MSSQL_SA_PASSWORD=<YOUR-PASSWORD>

For your server name, the default if left unspecified is localhost.

If unspecified, the default password will be myPassword30.

4. Run your SQL Server database container

docker run --name <CONTAINER-NAME> -p 1433:1433 -d <IMAGE-NAME>

If you don't specify a value for your container name then docker will generate a random name for you.

5. Restore the backup files in your container

Windows

scripts/windows/mount.bat <CONTAINER-NAME> <YOUR-PASSWORD>

Linux

source scripts/linux/mount.sh <CONTAINER-NAME> <YOUR-PASSWORD>

6. Download an IDE (Choose One)

7. Install these extenstions (For VScode only)

Tips

Generate Database SQL Scripts with Python

Install Python first

Windows

scripts/windows/schema.bat <SERVER-NAME> <DATABASE-NAME> <USER-NAME> <YOUR-PASSWORD>

Linux

source scripts/linux/schma.sh <SERVER-NAME> <DATABASE-NAME> <USER-NAME> <YOUR-PASSWORD>

About

Ensias TP about data warehouses using SQL Server and Docker

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published