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 such as SQL are in high demand.
Data Management & SQL Professional Training Course Offerings
Upcoming schedule for instructor led, live, online courses.
Please check back for scheduled classes.
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 14 contact hours and are equivalent to 1.4 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.
Introduction to SQL for Business Analysts
This course will be online with a live instructor.
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.
- 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.
| 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 |
Instructor
Jim Monahan is a former Principal Consultant with Pinnacle Solutions Group where he focused on data related business applications across multiple technology stacks. He brings experience in system implementations from a wide range of industries including eCommerce and Data Warehousing. He holds a BS in Electrical and Computer Engineering and an MBA from the University of Cincinnati.
Being in Public Health, this course was the introduction to SQL that I needed to work across systems. The format of the course made the skills and material learned easy to translate to my day-to-day work.”
Dominique Walker, MPH, CHES® Senior Data Management Specialist, Cradle Cincinnati
For more information about these classes, or for custom training classes, please contact
