Hands-On SQL for Data Analysts (Using Insurance Data)

Coupons & Discounts

Use insurance data to become proficient in the use of SQL for data analysis - PostgreSQL; MySQL; AWS Athena and more

REDEEM

What you'll learn

• Learn how to construct SQL queries for the purpose of analysing data
• Learn how to manipulate data using advanced SQL techniques
• Gain the confidence to query data using SQL on any platform for analysis or reporting
• Learn how SQL gives you the power to gain valuable insight into your organisation's data

Description

SQL really is the language of Data Analysis.

Learning to use SQL well, allows you to query the data in your organisation's databases so that you can answer the questions you have as a data and business professional. It is the "bread and butter" skill that data professionals have used for decades and it's as in-demand today as its ever been - especially on the cloud!. For anyone wanting to move into the field of Data Analysis or those who have only worked with spreadsheets, or relied on others to query the data for them, this course will help you grasp the most useful SQL functionality and enable you to grow in your role.. even if you have no programming experience. Once you have that skill to query data in different ways and without reliance on others, you'll be able to find useful ways to extract it and analyse it. Its only then that you gain insight into what organisational databases hold.

This course comes with a financial database based upon an insurance claims model (something easily understood) which you'll learn to query and build your skills with. All the lessons and exercises will be based on this database so you'll have the freedom to explore  and investigate relationships in the data that other courses aren't usually able to offer. You'll have access to all of the code used by the instructor so you can follow along,  as well as the solution to exercises that you'll use to shore-up your skills. You'll also have access to me through Q&A of-course!

The techniques you learn can be applied on multiple platforms. Whether you are using PostgreSQL, MySQL, AWS Athena, or any other environment that requires SQL for querying. Once you get started, you'll quickly be able to adapt what you learn for use anywhere.

We'll take you through from the very basics, through to advanced functionality most commonly used in industry and not just the vanilla content you'll see in most other courses. You'll soon be a SQL hero.

So what are you waiting for?

Who this course is for:

• Data Analysts,Scientists and Engineers wanting to learn SQL
• Business Analysts who want to learn SQL to gain insight into their organisation's data
• Students wanting to learn SQL as a data query tool