SQL Fundamentals (119652817) - Online

Description

CPA Members only

CPA Australia has partnered with the Corporate Finance Institute (CFI) to curate a collection of data and digital courses exclusively for CPA members. CFI courses have an emphasis on hands-on, practical learning and skills acquisition. They teach in-demand industry practices, tools and techniques that help accounting and finance professionals build confidence, stand out from the competition, and make a positive impact on their careers.

SQL plays a foundational role in Business Intelligence as it provides us with a way to extract data from databases for use in other BI tools. 

This course covers SQL’s foundational syntax and essential transformations with practical, hands-on examples. To do this, learners are provided with access to an Azure Data Studio data warehouse from which they can run the queries taught throughout this course. Connecting to the data warehouse is simple and can be from a Windows, iOS, or Linux computer.

This course will walk you through retrieving and filtering data from a database with basic SQL syntax, transforming that data with functions, combining data from multiple tables, best practices when using SQL and common mistakes. By the end of this course, you’ll have the core skills business analysts need to extract data from a database using SQL. 

This CFI course involves specific technical requirements, so we encourage you to review them here.

CPA Australia handles your personal information in accordance with the CPA Australia Privacy Policy. By proceeding you may be redirected to an external website to access the course.

Our Privacy Policy includes the following statement under the subsection 'Links to external websites':  
•    We may provide links to websites operated by third parties. 
•    We are not responsible for the privacy practices or the content of such websites which will be governed by their own privacy policies to which you are advised to refer. 
•    Your satisfactory completion of the course may be recorded in your CPD Diary.

CFI programs will be supplied to CPA Australia members as standalone courses for 12 months from the date of purchase and as such, any associated CFI certifications are not able to be supplied. Refunds or extensions for purchases of CFI courses will only be available in exceptional circumstances and will be based on CPA Australia and CFI’s cancellation terms.

Learning objectives

• Retrieve and filter data using basic SQL syntax
• Transform data with the help of numerical, date, and text functions
• Identify strategies for constructing an unbiased sample
• Explain essential terminology related to SQL, databases, and data warehouses

Audience