Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Business and Data Analysis with SQL

person icon Geoffrey Devitt

4.2

Business and Data Analysis with SQL

A practical guide to business and data analysis

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Geoffrey Devitt

English [CC]

category icon Development ,Data Science,Data Analysis

Lectures -39

Duration -5 hours

Lifetime Access

4.2

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Have you thought about working with big data but don't know where to start?  In this course, you will learn the skills of what it takes to become a data and business analyst.  

What we will cover:

  • Database and data warehouse design.
  • How to write queries in SQL (Structured Query Language).
  • How to build interactive dashboards and reports.
  • Tips and techniques on how to run your own big data project from start to finish.

My name is Geoffrey Devitt and I have been working with Big Data and Databases for the past 20+ years.  In this course, I will share with you an overview of the skills I have learned over the years of working on numerous data-driven projects. As a data and business analyst, I have had the privilege of working in many different industry sectors, including financial banking, online gaming, eCommerce retail, insurance, and telecoms.

With the knowledge you will gain from this tailored course, you will be able to fit into any industry and be in a position to start adding value to your team from day one.

Goals

  • At the end of this course, you will have the ability to run a project using big data.

  • Work and manage large datasets using SQL.

  • Navigate databases and data warehouse.

  • Providing meaningful insights using tried and tested analytical techniques.

Prerequisites

  • Be familiar with reports and data-based projects.

Business and Data Analysis with SQL

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

1 Lectures
  • play icon Business and Data Analysis with SQL 06:07 06:07

Database and Datawarehouse Design

9 Lectures
Tutorialspoint

Structured Query Language (SQL) - Fundamentals

11 Lectures
Tutorialspoint

Project Management

3 Lectures
Tutorialspoint

Sales Project

9 Lectures
Tutorialspoint

Data Control Language (DCL)

1 Lectures
Tutorialspoint

MySQL Programs

2 Lectures
Tutorialspoint

Visualising Data

3 Lectures
Tutorialspoint

Instructor Details

Geoffrey Devitt

Geoffrey Devitt

I've been working with databases and data-warehouses for over 20 years.  In that time, I've held many roles from systems analyst, data analyst to present day business intelligence manager.  I'm passionate about data and getting the right data in front of the business to make informed decisions is what keeps me up at night.

I've worked across numerous data platforms from Oracle, Teradata, MySQL, MicroStrategy, Tableau, to name a few and because I've always worked with data, this has landed me jobs analysing data from small start up companies to some of the largest companies in the world. 

As data evolves, so have my skills and now I'm putting together a course on Tutorialspoint to bring all the skills I've learnt over the year, starting with the basics of data analysis and how to run a data driven project as a business analyst.

I hope you enjoy what I have to share and please feel free to drop me a line to ask any questions or just have a chat around what data issues you are working on.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515