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