sqlg repository for tutorial

This repository contains Dockerfile of apache-airflow for Docker's automated build published to the public Docker Hub Registry.

• 1. The proposed environment
• 2. Envirioment preparation
  • 2.1. Create github repo by fork
  • 2.2. Pull db image
• 3. Database install and run script
  • 3.1 Start container
    • 3.1.1. Windows
    • 3.1.2. Linux
    • 3.1.3. Mac
  • 3.2 Connect by sql client
  • 3.3 Build SQLEXT
    • 3.3.1 Create database and Sehema from sql client tool
    • 3.3.2 Install SQLEXT from sql client tool
  • 3.4 Install tutorial
    • 3.4.1 Build training data
    • 3.4.2 Build studend list
  • 3.5 Install SQLG and ODBC
    • 3.5.1 Install SQLG
    • 3.5.2 config ODBC
    • 3.5.3 Create or Alter [TRNADM]
• 4. Conduct Training
  • 4.1 For instructor
  • 4.2 For student
• 5. SQLG in db to db
• 6. SQLG in web application
• 7. SQLG in Data Vault
• 8. SQLG in dbt
• 9. Wanna help?

Follwing step will assume those tools are installed

• Docker as container tool
• Visual Code as IDE
• sqlg as ETL transformation tools

1. create fork from sqlg-tutor

2. Clone sqlg-tuto from github

• Suggest directory as C:\Proj\saastoolset\sqlg-tutor

. Pull image

    C:> docker pull mcr.microsoft.com/mssql/server

. Start by option and open in browser, e.g. tutorial model

C:> docker run --name mssql-h1 -d -p 1433:1433 -e "MSSQL_SA_PASSWORD=MyPassw0rd" -e "ACCEPT_EULA=Y" mcr.microsoft.com/mssql/server

• Start by option and open in browser, e.g. tutorial model

$ docker run --name mssql-h1 -d -p 1433:1433 -e 'MSSQL_SA_PASSWORD=MyPassw0rd' -e 'ACCEPT_EULA=Y' mcr.microsoft.com/mssql/server

• Start by option and open in browser, e.g. tutorial model

$ docker run --name mssql-h1 -d -p 1433:1433 -e 'MSSQL_SA_PASSWORD=MyPassw0rd' -e 'ACCEPT_EULA=Y' mcr.microsoft.com/mssql/server

• Use SSMS in MSSQL

  ServerName: 127.0.0.1
  Authentication: SQL Server Authentication
  Login: sa
  Password: MyPassw0rd

SQLEXT use for ETL date conversion function when call from stored procedure from scheduler.

• For tutorial, create DB name as Tutor, schema SQLEXT and TRN are requried
• For implementation project setup, schema will mapping to data zone.

• Create schema for all data zone, may create schema.ddl by project
• holiday.ddl, Holiday table for working calendar
• fn_AddBusinessDays.sql, Business day function on working calendar
• etldate.sql, ETL date function for SQLG macro
• sp_drop_if_exists.ddl, Drop if function for MSSQL

• Tutorial PPT
• Tutorial DI

• Verify by sql client
• Verify tutorial excel

• Collect studend list
• Build studend list

• download and run addinstall.bat

• ODBC configuration

    ServerName: 127.0.0.1
    DSN: IBMTRN
    Database: Tutor
    Login: sa
    Password: MyPassw0rd

• TRNADM use ODBC link to fetch studend progress into Excel
• Report display on [pvtProgress]

• {STUD_ID}=ODP00
• Demo
• Track [pvtProgress]

• set {STUD_ID}=ODP?? follow instructor's name list
• Perform exercise follow training material
• Feedback issue on channel

Fork, improve and PR.