Business Intelligence & Data analysis | Advanced MySQL

NOTE: This is an ADVANCED SQL course, built on topics and skills covered in the previous course or on prior knowledge in SQL queries.

Please have the minimum prerequisite skills or complete the Beginner SQL course to be able to complete the course.

In this course you will develop real-world analytics and Business Intelligence skills using Advanced SQL by Analyzing an ecommerce store to get insight for the performance of the website, products and user experience

GUARANTEED, instead of learning some advanced codes, in this course you will learn how to apply the advanced skills, analyzing the data and doing Business analysis too

We will walk through real project database of eCommerce store for toys  from scratch

          What you will learn:

• Write Advanced SQL queries and analyze database.

• Learn TEMPORARY TABLES and SUBQUERIES to handle complex multistep data problem.

• Analyze data for eCommerce real-world case where you can solve tasks.

• Mastering JOIN statements across multiple tables

You will use advanced skills such TEMPORARY TABLE, Subqueries to solve multistep data problem which make you THINK like an ANALYST

COURSE OUTLINES:

• Introduction from downloading SQL server to connect the database.

  In this section we will take about how to install MySQL workbench and connect the database to the server plus creating  a connection, after watching this part make sure you have the relevant skills including SELECT statements, Aggregate Functions and tables joins.

• Analyzing Traffic source

  In this section we will warm up and do some review for some queries, then we will analyze where our traffic source coming from, how different sources perform in terms of traffic volume, calculate conversion rates, analyzing bids and optimize it, trend analysis

• Analyzing website performance

  In this section we will analyze website pageviews and use TEMPORAY TABLE, calculate bounce rate, analyzing landing page, and use SUBQUERIES

• Analyzing Channel portfolio management

  In this section we will compare channels and do multi channel bidding , also analyzing bid changes impact, traffic breakdown.

• Analyzing Business Patterns and Seasonality

  In this section we will dig deeper into traffic analysis and explore more about organic and paid campaign, also seasonality and business patterns analysis

• Product Analysis

  In this section we will break down sales on product level, conversion rates and cross-selling patterns and refund rates analysis to keep quality

• User Analysis

  In this section we deep analyze user behavior and analyze the repeated sessions to identify most valuable customers and explore which channels they are coming from

Rating Distribution

• 1 stars: 0 votes
• 2 stars: 1 votes
• 3 stars: 3 votes
• 4 stars: 2 votes
• 5 stars: 7 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!