Business and Data Analysis with SQL
A practical guide to business and data analysis
Updated on Apr, 2024
Language - English
Lectures -39
Duration -5 hours
30-days Money-Back Guarantee
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:
1) Database and data warehouse design
2) How to write queries in SQL (Structured Query Language)
3) How to build interactive dashboards and reports
4) 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
What will you learn in this course:
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 datawarehouse.
Providing meaning insights using tried and tested analytical techniques.
Prerequisites
What are the prerequisites for this course?
Be familiar with reports and data based projects.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Business and Data Analysis with SQL
06:07
06:07
Database and Datawarehouse Design
9 Lectures
Structured Query Language (SQL) - Fundamentals
11 Lectures
Project Management
3 Lectures
Sales Project
9 Lectures
Data Control Language (DCL)
1 Lectures
MySQL Programs
2 Lectures
Visualising Data
3 Lectures
Instructor Details
Geoffrey Devitt
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now