Course Details
Database Basics for Financial Professionals
Course ID#: 433 | Short Title: Database Basics | Category: Databases
Course Description
In today’s digital age, databases have become the backbone of every business technology, application, platform, and service. Every system relies on databases to store and organize information, from financial records in Quickbooks and Xero to sales efforts in Salesforce and Hubspot. Popular reporting tools like Power BI and Excel utilize databases to create beautiful, insightful dashboards. Despite the widespread use and importance of databases, many financial professionals lack a basic understanding of how they operate. Traditionally, working with databases has been delegated to an organization’s IT department, leaving the accounting team out of scope. However, in today’s technology-driven environment, accountants need to have a basic understanding of how databases work and the ability to query data independently.
Our database basics course focuses on the knowledge most helpful for financial professionals. Through hands-on learning, participants will develop the skills to query data from a database or cloud provider and use it to create insightful reports in Excel or Power BI. By the end of the course, participants will feel empowered to design their dashboards and work more effectively with cloud data. With our database basics course, gain the knowledge you need to succeed in today’s digital age and enhance your value as a financial professional.
Major Topics
- Introduction and Overview of Databases
- Review of Major Database Components
- Overview of Structured Query Language (SQL)
- Creating and Working with Tables Databases
- Using Power Query to Access Your Data in Excel
Who Should Attend
A business professional who would like to learn more about using a database for reporting and analysis.
Learning Objectives
- List the major database platforms such as MySQL, Microsoft SQL, Postgres, Oracle, and more. Discuss their major features and how they are best utilized in an organization.
- Discuss the major characteristics, features, and syntax of the structured query language (SQL) and how it is used to interact with a database. Recall and explain the major SQL verbs such as SELECT, JOIN, WHERE, GROUP, and their related function.
- Develop a basic SELECT statement in SQL to query data into Microsoft Excel. This will allow for data to be directly imported into a spreadsheet from a database without having to go into an application.
- Identify the various tools to assist with working with databases such as DBeaver and SQL Management Studio. These tools help write and debug database queries and reports.
- Demonstrate SQL abilities by using Microsoft Power Query (for Excel or Power BI) to query a database and create reports from multiple database tables.
- List major SQL helper functions such as LENGTH, COUNT, SUM, CONCAT, MIN, MAX, etc. to modify or aggregate data for reporting.
Course Specifics
Level |
Advanced Preparation |
Prerequisites |
Recommended Duration |
|---|---|---|---|
| Basic | None | None | 200 Minutes |
CPE Credit Recommendations
Primary
|
Primary
|
Secondary
|
Secondary
|
|---|---|---|---|
| Information Technology | 3 | Not Applicable | Not Applicable |
Created and Updated Dates
Creation Year |
Update Year |
Update Date |
|---|---|---|
| 2022 | 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
