Icon

Solution

This directory contains 5 workflows.

IconExercise 1 

Exercise 1: Read Data From File and Insert Into Database. 1. Read Data From File. 2. Create Table In Database. 3. Manipulate Data and Insert Into Database

IconExercise 2 

Exercise 2: Insert New Data Into Database (Exclude Duplicate Data). 1. Read Data From Database. 2. Read Data From File. 3. Find and Remove Duplicate Data. […]

IconExercise 3 

Exercise 3: Creating New Column and Update Value For Selected Column. 1. Connect to Database and Add New Column named as "Level" into table […]

IconExercise 4 

Exercise 3: Updating Column Value with Condition. Update Column Level in demographic_[your name] to the value of Column Level in advisory_[your name] table […]

IconExercise 5 

Exercise 5: Merge two table. 1. Connect and Read demographic table. 2. Create life table by using data form file life.xlsx. 3. Manipulate Table demographic. […]