Accountant's Detailed Guide to Databases, AC Recorded Webinar Avail Mar 9, 2023

OVERVIEW

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.

TOPICS:

• Databases technologies such as MySQL and Microsoft SQL

• Microsoft Excel and Data modeling

• Integration and data sharing between applications

• Extracting and using data from databases for reporting and insight generation

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

MINIMUM REQUIREMENTS:

You will require an Internet connection and a phone/voice connection at the same time. Most attendees use their computer for the audio. Participants are able to submit questions and comments during the session via a Q&A text panel. Terms, conditions, pricing and services subject to change.

TARGET AUDIENCE:

Financial professionals that want to learn how to work with databases and data more effectively.

PROFESSIONAL DEVELOPMENT CREDITS (CPE HOURS):

Wolters Kluwer professional development programs are designed to meet the continuing education requirements of a variety of professional associations. These requirements do vary by association and region. Please consult your provincial association to ensure this webinar meets the continuing professional development standards for your specific situation.

Registrations for each Live Webinar are available until the start of each program. We reserve the right to substitute speakers in the case of instructor illness. In the event that we must cancel a Live Webinar, all registrants will be notified immediately and given the opportunity to either transfer their registration to another Live Webinar or a Recorded Webinar or obtain a refund. For all Live Webinars that are recorded, participants will have access to the recording for 3 months following the Live Webinar. Partial credit will not be awarded for attendees that are not present for the entirety of the Live Webinar. Credit will not be awarded if an attendee does not answer all of the polling questions (where applicable). Additional credit will not be awarded due to the instructor presenting over the allotted time.

CANCELLATION POLICY:

Due to the costs involved with planning Web sessions, cancellations must be confirmed in writing at least one (1) business day before the beginning of the Web session. If we receive your cancellation notice within the above-mentioned period, you will receive a full refund. No refund will be issued for notices received after the cancellation period.

THIS WEBINAR INCLUDES:

• 90-days to review the webinar recording

• Print version of the presentation slides

• PD Certificate for 8 hours

PRESENTER:

This webinar is being presented by:

Stephen Yoss

Stephen M. Yoss, Jr., CPA, MS, is a certified public accountant, the senior technology strategist and partner of Devmatics, a continuing education instructor for financial professionals, and a licensed pyrotechnician. While his interests and skills are varied, they all share a common thread—his love for and skill in finding technology-based solutions.

Whether it’s teaching in the classroom, consulting clients in a boardroom, or shooting a fireworks display, Steve brings passion, hard work, value—and above all else—technological expertise to each of his clients. With an open, honest approach, he creates a unique strategy for each client specifically designed to benefit their needs and streamline their operations in order to create efficiency and maximize their financial potential. For more information about Steve, please click here to visit his personal website.