Data Management & SQL for Business Analysts

Data is a valuable corporate asset that is used to make informed business decisions. Companies are collecting larger volumes and varieties of data and storing it in different types of database management technologies.  The skills to access and use these databases, as well as a knowledge of programming languages (ie SQL) are in high demand.

The following courses are offered. All courses can be customized and delivered at your location.

  • SQL for Business Analysts (no prior SQL experience required): 4 online sessions   
  • Introduction to Data Management for Business Analysts:
    4 online sessions   Dec 8, 10, 15, 17  8:45AM–12:15PM
      https://cvent.me/NVaqkB

SQL for Business Analysts

This short course is a hands-on introduction to using SQL for data analysis.  It is intended for the business analyst who is familiar with general database concepts and wants to perform their own data discovery.  We will explore how to find answers in the data, pitfalls to avoid, and how to take analysis to the next level.

Prerequisite 

Familiarity with general database concepts is recommended (but not required) for those with no prior database experience.

                                SQL for Business Analysts Course Outline
Day One Day Two  

Database Fundamentals and Vocabulary

Connecting to a Database

Basic SQL Syntax

Table Joining

Exporting Data

Aggregate Functions

Ranking Functions

Database Views

Data Definition Language

Table Creation

Indexes and Performance Tuning

 
Jim Monahan SQL Instructor

Instructor

Jim Monahan is a Principal Consultant with Pinnacle Solutions Group where he focuses on data related business applications.He holds a BS in Electrical and Computer Engineering and an MBA from the University of Cincinnati.He brings experience in systems across a wide range of industries and technologies including eCommerce and Data Warehousing.

Testimonials

  • Thank you for a great course.  I learned a lot and your course was designed very well.
  • I enjoy these classes and appreciate the chance to learn so much in a short period of time
  • Great foundation for learning SQL.
  • Instructor clarified if we were getting what we needed and adjusted materials and labs based on class feedback.
  • Great pace, materials, labs!  Loved having the time to work through them and ask questions, and having solutions to look back on for work.
  • He was great and should teach more of these classes

Online Course Fees: $495  

These trainings can also be customized and delivered at your location.


Introduction to Data Management

Data is the foundation from which business analytics, data visualization, and business intelligence originates. This course focuses on learning the steps to get data into a well-designed database and teaches participants how to use Structure Query Language (SQL) to interact with data. The course will start with topics related to database design and data rules to provide participants with a sound knowledge of databases and relational data design. The class will finish with the coverage of practical examples to solve common business problems, efficient database structure design, and solutions on how to create interactions between analytical tools and a database.

In this short course you will learn:

  • Database design and data rules.
  • How to get data into a well designed database.
  • The steps to use SQL to interact with data.
  • Practical examples for solving common business problems, efficient database structure and design, and how to create interactions between analytical tools and a database.

This course will allow novice users and those with some experience the chance to learn skills, syntax, and techniques to perform analytics and data mining on datasets.

                                      Introduction to Data Managment Course Outline
Day One Day Two  

Data Modeling and Database Design

·       Conceptual Design

·       Logocal Design

·       Normalization

·       Physical Design

·       Extract-Transform-Load Processes

Data Warehousing, Dimensional Modeling, and Big Data

·       Comparing Relational and Dimensional Modeling

·       Kimball's 10 Rules of Dimensional Design

·       Dimension Tables

·       Fact Tables

·       Extending Dimensional Models

·       Key Value Data Models and Big Data

·       Data Manipulation in Big Data Systems

·       Extending the ETL with Data Integration

 

 

4 online sessions

Online Course Fees: $495  

These trainings can also be customized and delivered at your location.

Photo of Andrew Harrison Data Management Instructor

Instructor

Andrew Harrison is an Assistant Professor of Information Systems in the Lindner School of Business at the University of Cincinnati. His research interests include consumer fraud, deception, security systems, privacy, media capabilities, and virtual worlds.  http://business.uc.edu/academics/departments/obais/faculty/andrew-harrison.html#bio

Testimonials

  • I appreciate the time he took to answer questions and to make sure we understood.
  • While only part of the course is directly applicable to my current position, the concepts learned in this course will enable me to better communicate with DBA’s in the organization.
  • This course was a great opportunity to pull many concepts, tools and jargon together to understand how it all works.  Very holistic and helpful.
  • Course covered exactly what I expected from the description.  Adequately challenged me with information and pace.
  • The instructor had a ton of knowledge but broke it down into ways that were easy to understand. 

For more information about these classes, or for custom training classes, please contact
Headshot of Larry Porter

Larry Porter

Training , Marketing and Sponsorship Manager

513-556-4742