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
March 16,18 ,23, 25: 2021 8:45AM-12:15PM Details and Registration
- Introduction to Data Management for Business Analysts:
4 online sessions
Continuing Education Units
A Certificate of Completion is provided with each course showing number of contact hours (instruction), and field of study as "Information Technology" for continuing education purposes. Most courses provides 12 contact hours and are equivalent to 1.2 CEU's.
The term CEU is not a trademarked term; therefore, any educational institution may use it to describe their courses. Professions and industries usually regulate their approved continuing education within their bylaws and not one institute or accrediting body has become a standard to accept in this regard. Professionals should always consult their Association or regulating body prior to embarking on continuing education and not assume a CEU will be accepted as part of their professional development.
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.
| 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 |
- 4 online sessions
- Time commitment 12-16 hours
- Certificate of Completion.
- Required class for “Python for Data Sciencel” Certificate of Competency
Online Course Fees: See registration page
These trainings can also be customized and delivered at your location.
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
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.
| 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
- Time commitment 12-16 hours
- Certificate of Completion.
- Required class for “Python for Data Sciencel” Certificate of Competency
Online Course Fees: See registration page
These trainings can also be customized and delivered at your location.
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
