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.
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
Major Topics
- 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
- Introduction and Overview of Databases
