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

Requirements

  • Familiarity with data analysis concepts

Audience

  • Business analysts
 14 Hours

Number of participants



Price per participant

Testimonials (1)

Related Courses

Data Analysis with Python, Pandas and Numpy

14 Hours

Accelerating Python Pandas Workflows with Modin

14 Hours

Machine Learning with Python and Pandas

14 Hours

Scaling Data Analysis with Python and Dask

14 Hours

FARM (FastAPI, React, and MongoDB) Full Stack Development

14 Hours

Developing APIs with Python and FastAPI

14 Hours

Scientific Computing with Python SciPy

7 Hours

Game Development with PyGame

7 Hours

Web application development with Flask

14 Hours

Advanced Flask

14 Hours

Build REST APIs with Python and Flask

14 Hours

GUI Programming with Python and Tkinter

14 Hours

Kivy: Building Android Apps with Python

7 Hours

GUI Programming with Python and PyQt

21 Hours

Web Development with Web2Py

28 Hours

Related Categories

1