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
 

Testimonials

Related Courses

Scaling Data Analysis with Python and Dask

 14 hours

Dask is a flexible and high-performance Python library for parallel computing. It scales and accelerates big data processing with other Python-based data science libraries, such as Pandas, Numpy, and Scikit-Learn. This instructor-led, live

Data Analysis with Python, Pandas, and Numpy

 14 hours

Pandas is a Python package that provides data structures for working with structured (tabular, multidimensional, potentially heterogeneous) and time series data.

Accelerating Python Pandas Workflows with Modin

 14 hours

Modin is a parallel data frame system designed to speed up Pandas workflows. It can be used to handle large datasets, leveraging Ray or Dask as the backend framework for distributed computing in Python. This instructor-led, live training (online

Machine Learning with Python and Pandas

 14 hours

Pandas is a Python library for data manipulation and analysis. Using Pandas, users can perform predictive analysis through machine learning. This instructor-led, live training (online or onsite) is aimed at data scientists who wish to use Pandas

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

 14 hours

FARM (FastAPI, React, and MongoDB) is similar to MERN, but performs faster with Python and FastAPI replacing Node.js and Express as the backend. FastAPI is a high-performance Python web framework used by top companies, such as Microsoft, Uber, and

Developing APIs with Python and FastAPI

 14 hours

FastAPI is an open source, high-performance web framework for building APIs with Python. It is used by many large companies, such as Uber, Netflix, and Microsoft. This instructor-led, live training (online or onsite) is aimed at developers who

Web application development with Flask

 14 hours

This practical course is addressed to Python developers that want to create and maintain their first web applications. It is also addressed to people who are already familiar with other web frameworks such as Django or Web2py, and want to learn

Advanced Flask

 14 hours

Flask is a micro-framework for developing web applications in Python. Unlike other frameworks, Flask does not have any dependencies on external libraries, making it lightweight and fast. This instructor-led, live training (online or onsite) is

Build REST APIs with Python and Flask

 14 hours

Flask is a micro-framework for developing web services in Python. Flask, unlike other frameworks, does not have any dependencies on external libraries, making it lightweight and fast. This instructor-led, live training (online or onsite) is aimed

Kivy: Building Android Apps with Python

 7 hours

Kivy is an open-source cross-platform graphical user interface library written in Python, which allows multi-touch application development for a wide selection of devices. In this instructor-led, live training participants will learn how to

Game Development with PyGame

 7 hours

PyGame is an open source library of Python modules for developing game applications and programs. It is lightweight, easy to use, and compatible with any operating system or platform. This instructor-led, live training (online or onsite) is aimed

GUI Programming with Python and PyQt

 21 hours

PyQt is a cross-platform library for developing GUIs (graphical user interfaces) for Python applications. It interfaces Python with the Qt GUI toolkit. This instructor-led, live training (online or onsite) is aimed at persons who wish to program

Scientific Computing with Python SciPy

 7 hours

SciPy is an open source Python library for scientific, mathematical, and technical computing. It is built on the NumPy extension, providing a wide range of functionalities for performing complex numerical operations. This instructor-led, live

GUI Programming with Python and Tkinter

 14 hours

Tkinter is the most commonly used Python GUI (Graphical User Interface) programming toolkit and it is the standard GUI package for Python. Tkinter is an object-oriented layer wrapped over the TK GUI toolkit. This instructor-led, live

Web Development with Web2Py

 28 hours

Web2py is a python based free open source full-stack framework for rapid development of fast, scalable, secure and portable database-driven web-based applications. Audience This course is directed at Engineers and Developers using web2py as a