         Data Analysis with SQL, Python and Spotfire培訓

======== Day 01 ========

Introduction to RDMS (Relational Database Management System)

Oracle RDMS and the SQL language
How Data is Stored in an RDMS

Tables, records and columns
Connecting to an Oracle database

Command line vs GUI
Logging in: server, database, credentials
Data Analysis with SQL

Querying the database using SELECT
Filtering data with WHERE
Sorting data with ORDER BY
Querying multiple tables with Joins
Grouping Data with GROUP BY
Using aggregate functions to perform calculations on resulting data
Filtering groups with HAVING
Introduction to Python

Crash course on Python syntax
Connecting to an Oracle database

Logging in: server, database, credentials
Data Analysis with Python

Querying the database
Filtering, ordering, and counting data
Advanced queries
======== Day 02 ========

Introduction to Data Visualization with TIBCO Spotfire

Connecting to a Spotfire Server

Web client vs installed client
Importing Data

Data Visualization

Bar Chart
Line Charts
Pie Chart
Filtering Data

Presentation Strategies with TIBCO Spotfire

Summary and Conclusion