Description
Sebastian Taylor & Pavel Nacev – CFI Education – SQL Case Study – WOWI Sales Analysis download, Sebastian Taylor & Pavel Nacev – CFI Education – SQL Case Study – WOWI Sales Analysis review, Sebastian Taylor & Pavel Nacev – CFI Education – SQL Case Study – WOWI Sales Analysis free
Sebastian Taylor & Pavel Nacev – CFI Education – SQL Case Study – WOWI Sales Analysis
SQL Case Study – WOWI Sales Analysis
Take on the role of a sql focused business intelligence analyst, working with World Wide Importers to answer a series of business questions: – explore a database from scratch using documentation and guided questions – use SQL to respond to business questions with data-driven insights – apply SQL to real-life scenarios
Overview
SQL Case Study – WOWI Sales Analysis Course Overview
You’ve recently joined World Wide Importers as a Business Intelligence Analyst. They are a novelty goods distributor and are keen to get you involved in helping make some key business decisions.
You’ll be exploring the database, responding to questions from the product and marketing teams, and using all the knowledge you gained in SQL fundamentals to test your skills on the job.
SQL Fundamentals Learning Objectives
Upon completing this course, you will be able to:
Explore new data using documentation
Apply SQL queries to respond to business questions
Execute simple queries from single tables
Execute complex queries using joins and subqueries
Develop responses based on evolving requirements from the business
Who should take this course?
This SQL case study is perfect for those who want to put their knowledge about SQL into practice with selected, real-life scenarios. This makes the course a great follow-up to CFI’s SQL Fundamentals. As with any coding language, SQL can be daunting: while this course aims to present practice problems, you’ll also be able to walk through each problem with assistance where needed. Every concept and step is explained clearly and in non-technical language.
What you’ll learn
Case Study Introduction
SQL Case Study Introduction
Learning Objectives
Case Overview
Downloadable Materials
SQL Login Credentials
Basic Queries
Chapter Introduction
Explore the Database
Basic Customer Data
Product Data
Marketing Data
Marketing Data Part 2
Delivery Efficiency
Other Data
Multi-table Queries
Chapter Introduction
Sales Over Time
Sales by Fiscal Period
Top Selling Products
Top Selling Chilled Products
Conclusion
Case Study Summary
Qualified Assessment
Qualified Assessment
What our students say
It is good for analysis
Lydia Angolo Endjala
Awesome
I enjoyed every bit of the course. Thanks to the Instructor
Oluwafemi Ayelomi
Good refresher course on SQL. A little tough at the end but very informative. I enjoyed this a lot.
Onyedika Nwoji
