Training Resources

Owned by Nikki DeMoville (Unlicensed)

Last updated: Sept 25, 2021 by Christina Hennessey (Unlicensed)Version comment

2 min read

Alma Analytics

Ex Libris Knowledge Center main page for Analytics Documentation
Ex Libris Knowledge Center Common Analytics Procedures
- How-to Presentations
CSU Analytics tutorials
Network Zone Training - 2018 Southern California Technical Services Meeting (pptx)
Tips & Tricks for Alma Analytics - 2016 presentation from Mike Rogers (UTenn)
CSU Learn e-Learning Professional Development Courses, Videos, and E-books
- Access through your campus portal or CSYou and use the search box
- Available e-book titles include:
  - Oracle BI 11g: Create Analyses & Dashboards, by Sideris Courseware Corporation, 2012
  - Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting, by Yuli Vasiliev, 2010
  - SQL All-in-One for Dummies, Second Edition, by Allen G. Taylor, 2011

Excel

CSU Learn e-Learning Professional Development Courses, Videos, and E-Books
- Access through your campus portal or CSYou and use the search box
- Courses average 1 hour in length
- Recommended searches:
  - Microsoft Excel 2016 Essentials (5 courses available)
  - Microsoft Excel 2016 Intermediate (6 courses available)
  - Microsoft Excel 2016 Advanced (3 courses available)
- Videos and e-books are also available
  - Available e-book titles include:
    - Excel 2016 For Dummies, by Greg Harvey, 2016
    - Excel 2016 in Easy Steps, by Michael Price, Mike McGrath, 2016
    - Power Excel with MrExcel: 617 Excel Mysteries Solved, 2017 Edition, by Bill Jelen, 2017

Oracle

Oracle User Guide
- Logical SQL Reference
  - This appendix provides syntax and usage information for the Logical SQL statements understood by the Oracle BI Server. Oracle BI Server Logical SQL includes standard SQL, plus special functions (SQL extensions) such as AGO, TODATE, EVALUATE, and others.

Regular Expressions

SQL

W3Schools SQL tutorial and reference
Skillport e-Learning Professional Development Courses, Videos, and E-Books
- Access through your campus portal or CSYou and use the search box
- Courses average 1 hour in length
- Search for "PL/SQL" - Procedural Language/SQL is the flavor used by Oracle while Transact SQL (T-SQL) is used by Windows SQL server.
- Courses
  - Introduction to SQL, By: Aaron Sampson
  - Generic Database Fundamentals: Relation Algebra, SQL, and Concurrency Concepts, By: Aaron Sampson
  - Oracle Database 12c - Introduction to SQL: Working with Joins and Subqueries
- e-books
  - Oracle PL/SQL For Dummies, By: Michael Rosenblum, Paul Dorsey (Includes handy syntax and code example cheat sheets)
  - Introduction to SQL and PL/SQL, By: Sharad Maheshwari, Ruchin Jain
  - Beginning Oracle PL/SQL, Second Edition By: Donald J. Bales
  - Oracle and PL/SQL Recipes: A Problem-Solution Approach, By: Josh Juneau, Matt Arena

Google Charts

Library Analytics via Google Charts and Alma Analytics API (Laura Guy - Ex Libris Developer Network Tech Blog post)