Loading Events

« All Events

201 – Introductory Data Analysis with Spreadsheets and Databases

The course provides a basic training to develop skills for effective usage of spreadsheets and simple usage of database programs for quick data analysis.

Course Coverage

Representing Data in Table

  • Records
  • Attributes
  • Schema

Relational Algebra – Single Table Operations

  • Projection
  • Selection

Relational Algebra – Multi Table Operations

  • Union
  • Intersection
  • Set Difference
  • Cartesian Product
  • Inner Join
  • Outer Join
  • Left/Right joins

Relational Operations on Databases

  • SQL
  • Writing SQL Queries

Relational Operations on SpreadSheets

  • Filtering
  • Projections

Analytics Functions

  • Computing Statistics
  • Representations of Data for Analytical Queries
  • Pivoting Data
  • Visualizing Results

Window Analytics

  • Windowing Data
  • Window Aggregations
  • Accumulating and Ranking

Request Info

Download Brochure

Details

Date:
-
Time:
-
Event Category:

Other

Duration
1 Day