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): Sept 15-24, 2020
4 online sessions Details and Registration
- Introduction to Data Management for Business Analysts: TBD
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.
Familiarity with general database concepts is recommended (but not required) for those with no prior database experience.
|Day One||Day Two|
Database Fundamentals and Vocabulary
Connecting to a Database
Basic SQL Syntax
Data Definition Language
Indexes and Performance Tuning
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.
- 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 two-day 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.
|Day One||Day Two|
Data Modeling and Database Design
· Conceptual Design
· Logocal Design
· 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
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
- 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.