Data Analysis with SQL, Python and Spotfire Training Course

Data Analysis with SQL, Python and Spotfire Training Course

Saigon Tower, 29 Lê Duẩn, Bến Nghé, District 1, Ho Chi Minh City, Vietnam

Description

Overview

In this instructor-led, live training, participants will learn three different approaches for accessing, analyzing and visualizing data. We start with an introduction to RDMS databases; the focus will be on accessing and querying an Oracle database using the SQL language. Then we look at strategies for accessing an RDMS database programmatically using the Python language. Finally, we look at how to visualize and present data graphically using TIBCO Spotfire. 

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Details :

Course Code : sqlpythonspotfire
Duration: 14 hours (usually 2 days including breaks)
Workday courses take place between 09:30 and 16:30
Requirements
– Familiarity with data analysis concepts
Audience
– Business analysts
Fees : 203240236 VND(Price per participant)
Venue : Ho Chi Minh City, Saigon Tower, Vietnam

Course Outline

======== 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

REGISTER FOR THE COURSE

Add A Review


Please enter input field

sanu
NobleProg Limited
Training Service

Book your course now

Enquiry

Your enquiry submitted successfully

Enquiry Submission failed

Please enter input field(s)

Claim this course

To manage this course details kindly claim this course.