Business and Data Analysis with SQL
A practical guide to business and data analysis
Development ,Data Science,Data Analysis
Lectures -39
Duration -5 hours
Lifetime Access
Lifetime Access
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:
- 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.

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
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.

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