I'm looking for scripts in MySQL to be used as lab materials. 2 types of scripts i'm looking for:
1) Raw scripts to demonstrate use of any of the following:
- hierarchical data
- self join
- case when
- complex join
- complex update/insert/delete
- any scripts that uses clever approach
2) Raw ETL scripts in MySQL (not talend, kettle etc) ETL can be for data migration and/or data integration. example scripts:
- scripts handle hierarchical data.
- transform address_line1, address_line2 -->>> street_num, street_name, unit_num
- simple data integration : extract, cleanse, conform, ... etc transform, load
- contains simple staging area design
I don't need full schema, just related tables, sample data and scripts.