Recent Tutorials

Financial IT Notes – Equity Markets






You need to login to view this content. Please Login. Not a Member? Join Us

Continue Reading →

Financial IT Notes – Introduction to the Financial Services Industry






You need to login to view this content. Please Login. Not a Member? Join Us

Continue Reading →

Financial IT – Course Introduction






You need to login to view this content. Please Login. Not a Member? Join Us

Continue Reading →

Getting Started with Bloomberg Market Concepts (BMC) on the Bloomberg Terminal






Introduction Bloomberg Market Concepts (BMC) is an on-line course that introduces basic market concepts such as economic indicators, currencies (foreign exchange), fixed income (bonds) and equity markets. Examples of Bloomberg screens and functions are used throughout the course. After successfully completing all of the modules (which include periodic quizzes), a Certificate of Completion will be […]

Continue Reading →

Data Warehousing for Analytics – Team Projects






Baruch College School of Business – City University of New York CIS 4400 Data Warehousing for Analytics Projects Semester Projects The purpose of the semester-long project is to give students the experience of developing a working data warehouse using a commercial database management system and development tools. Students should form groups of 3 to 4 […]

Continue Reading →

CIS 4620 Financial Information Technologies Syllabus






Zicklin School of Business – Baruch College – City University of New York CIS 4620 Financial Information Technologies Syllabus – Spring, 2016 Professor Dr. Richard Holowczak Office Number: Wasserman Trading Floor / Subotnick Center Phone: 646 – 312 – 1544 E-Mail: richard.holowczak@baruch.cuny.edu (Preferred) Course WWW : http://holowczak.com/financial-it-course-notes/ Office Hours: Monday and Wednesday 9:45 to 10:45 […]

Continue Reading →

Database Security and Administration






What You’ll Learn Database Security and Authorization Authorization Subsystem The SQL GRANT and REVOKE Statements System Administration Database Administration – the role of the DBA Data Administration – the role of the DA or CDO Database Security and Authorization Three very broad issues in DB security: Legal and Ethical considerations – Who has the right […]

Continue Reading →

Building ETL Transformations in Pentaho Data Integration (Kettle)






Introduction The purpose of this tutorial is to provide a comprehensive set of examples for transforming an operational (OLTP) database into a dimensional model (OLAP) for a data warehouse. While there are a bunch of short tutorials available elsewhere that demonstrate one or two aspects of ETL transformations, my goal here is to provide you […]

Continue Reading →

Introduction to Web Services and Web API’s






Introduction In this set of notes we will learn about Web Services using SOAP, UDDI, WSDL and other XML-based technologies and then cover light-weight web services using web protocols and JSON documents. Several popular web application programming interfaces (Web API’s) will be used as examples. Evolution of Web Services historically, each web site created custom […]

Continue Reading →

Connecting to Oracle 12c Database from Pentaho Data Integration (Kettle) Community Edition






Introduction Pentaho Data Integration (DI) tools (also known as Kettle) contain a powerful assortment of data filtering and transformation tools that can be used to carry out Extraction, Transformation and Load processes. The Pentaho DI Community Edition comes with a collection of database drivers that can access many different database systems as either a data […]

Continue Reading →