Duration
3 days
Day 1/2: Data Pre-Processing
Installing MySQL and the Workbench
Server and client architecture
Normalization of Database
- Normalization concept
- Table Relationships
MYSQL Data Types
- Text
- Numbers
- Time, Date and time
- Booleans
Data Manipulation
- Creating Database and Tables
- Primary Key and auto increment
- Forint key constrains
- Table structure modification (Alter)
- Insert data
- Update data
- Delete data
- Exercises
Select statement
- Simple select
- Column and table aliases
- Using Operators in select
- Data filtering using “where”
- Different Operators in “where”
- Order By
- Limiting Results
- The distinct keyword
- Aggregate Functions
- Group By
- Having
- Table Join
- Inner Joins
- Left and Right Outer Joins
- Cross join
- Functions
- Text Functions
- Data and time Functions
- Numeric function
- Select into statement
- Merge statement
- Union statement
- Sub queries
- Exporting and Importing Data
- Import data from Excel file to MYSQL database
- Export Data from MYSQL into Excel file
Day 2/3: Automation
ETL Using Oracle Data Integrator
- Installation
- Exercise of ETL Data migration
ETL Using Microsoft SSIS
- Installation
- Exercise of ETL Data migration
Windows PowerShell for task Automation (Free built-in windows tool)
- Introduction to PowerShell
- Exercise for task automation.
- Exercise ETL Data migration
Programme scope, delivery arrangements and suitability are confirmed during enquiry.