久久综合色88_欧美激情国产日韩精品一区18_午夜精品一区二区三区在线观看 _自拍日韩亚洲一区在线

         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