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
Testimonials
I genuinely enjoyed the lots of labs and practices.
Vivian Feng - Destination Canada
The exercises/labs were tailored to our own organizational needs.
- Destination Canada
I generally liked the subject matter.
- Destination Canada
Related Courses
Scaling Data Analysis with Python and Dask
14 hoursDask 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 hoursPandas 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 hoursModin 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 hoursPandas 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 hoursFARM (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 hoursFastAPI 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 hoursThis 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 hoursFlask 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 hoursFlask 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 hoursKivy 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 hoursPyGame 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 hoursPyQt 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 hoursSciPy 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 hoursTkinter 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 hoursWeb2py 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