Course Details
An Accountant’s Detailed Guide to Databases, Integration, and Data Sharing
Course ID#: 429 | Short Title: Integration Intermediate | Category: Databases
Course Description
Every business professional today needs to know how to work with data. We are all generating more and more data every day. However, only some of us know how it can be effectively leveraged. There are many new opportunities for people who can effectively work with data. From helping their organizations make better decisions to working more effectively on projects to creating integration between applications and automating workflows.
This course will take a longer and more in-depth look at how to use databases, structure data for optimum workflow, and share data between applications. This course teaches you how to effectively use Excel, Power BI, SQL, and other data-related technologies. You’ll also discover how to integrate and share data between different applications. By the end of this course, you’ll be able to utilize databases more effectively and make better decisions based on data analytics. We will go beyond the basics to give you the knowledge you need to start.
Major Topics
- Overview of Databases, Integration and Data Sharing
- Tables & Data Models
- Getting Started with Databases & SQL
- Using Power Query to Access and Learn from our Data
Who Should Attend
Financial professionals that want to learn how to work with databases and data more effectively
Learning Objectives
- Discuss how to use databases and data-related technologies inside an organization.
- Explain the central principles of databases, including data structure, keys/constraints, and cardinality.
- Demonstrate how to connect to a database via Excel Power Query functionality and database management tools (e.g. SSMS, DBeaver, etc.)
- List the major types of database technologies and their major use cases.
- Discuss and demonstrate how an Integration-Platform-as-a-Service (iPaaS) tool is used in conjunction with a database to push and pull data throughout an organization.
Course Specifics
Level |
Advanced Preparation |
Prerequisites |
Recommended Duration |
|---|---|---|---|
| Intermediate | Basic knowledge of databases and data models will be helpful. | None | 150 Minutes |
CPE Credit Recommendations
Primary
|
Primary
|
Secondary
|
Secondary
|
|---|---|---|---|
| Information Technology | 2 | Not Applicable | Not Applicable |
Created and Updated Dates
Creation Year |
Update Year |
Update Date |
|---|---|---|
| 2023 | 2023 | 01/26/24 |
© Copyright 2024 Stephen M. Yoss. All Rights Reserved.
No part of these CPE courses may be reproduced, distributed, or transmitted in any form or by any means, including photocopying, recording, or other electronic or mechanical methods, without the prior written permission of the author, except for noncommercial uses permitted by copyright law. For more information about this course or any other of Stephen’s content, please visit https://yoss.io
