Data Analysis with SQL, Python and Spotfire Training Course

Course Code

sqlpythonspotfire

Duration

14 hours (usually 2 days including breaks)

Requirements

  • Familiarity with data analysis concepts

Audience

  • Business analysts

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

Testimonials

★★★★★
★★★★★

Related Categories

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in India!

As a Business Development Manager you will:

  • expand business in India
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!