UNITED KINGDOM

Fundamentals of SQL for Analysts

Go from zero to hero in SQL with this two-day course taught by former Google & Salesforce BI analysts in BigQuery.
product
2 day course
Supporting material
Private
Private
A private training session for your team. Groups can be of any size, at a location of your choice including our training centres.

Taught by experts who focus on creating engaging sessions to enhance learning, this course focuses on teaching you to write and understand advanced SQL queries.

This includes multiple different types of filtering methods and subqueries, which will help you and your team to pull data confidently. You’ll also learn how to leverage SQL in Sheets to automate reporting streams, saving you time.

While the course is tailored to business and data analysts, no coding background is required.

The Fundamentals of SQL for Analysts course is offered as a private training session at a location of your choice or via Virtual Classroom.

Course overview
Who should attend:
Business users who need to draw insights from data; data analysts who are responsible for data analysis and visualisation within their organisations; and people with a general interest in data science and working with big data.
Walk away with the ability to:
  • Understand how to work with data using SQL
  • Work with the most important SQL functions to pull and manipulate data
  • Translate the business questions into data-driven answers using SQL
  • Build datasets that power business intelligence dashboards
  • Apply these newly learned skills in a business context
Prerequisites
No prior technical or coding knowledge is required.
Course Agenda
Day one:
 
Module 1: Working with single tables & automating spreadsheets
  • Pulling and manipulating data from one table
  • Filtering, aggregating and ordering the rows you need to answer your business question(s)
  • How to apply this knowledge to automate repetitive tasks in Google Sheets
Module 2: Working with multiple tables and subqueries
  • Combining data that comes from multiple tables
  • Combining multiple tables by using joins, union and subqueries
  • How to create new tables to store and update results for future use in dashboards or analysis
Day two:
 
Module 3: Business cases
  • Practice your skills: apply your knowledge to two different business cases
Book this course
Call our sales team today
close
Don't miss out
Keep up to date with news, views and offers from Jellyfish Training.
Your data will be handled in accordance with our Privacy Policy