English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 103 lectures (8h 10m) | 2.34 GB
Master advanced SQL database coding w/ MySQL Workbench. My SQL course takes your SQL analysis skills to new heights!
This is an advanced SQL course, which builds on the skills covered in our introductory MySQL courses. Please review the prerequisite skills or complete the beginner SQL course before taking this one!
If you want to develop practical, real-world analytics & BI skills using advanced SQL, you’re in the right place.
This course is unlike anything you’ve seen before, guaranteed. Instead of using random sample data and obscure demos, we’ll be working with a rich, custom-built eCommerce database that we’ve designed from scratch to help you apply your SQL skills to real projects and learn how to truly THINK like an analyst.
You’ll be playing the role of a newly hired Database Analyst for Maven Fuzzy Factory, an eCommerce start-up, and will be working directly with the CEO, Marketing Director and Website Manager to help grow the business and analyze performance along the way. You’ll use a range of advanced SQL tools and techniques, and work through actual projects that data analysts and business intelligence professionals work on every day.
COURSE OUTLINE:
Prerequisite SQL Skills Assessment
In this section we’ll address the core SQL/MySQL skills that you should be comfortable with before starting the course, including SELECT statements, aggregate functions, and table joins. If you aren’t sure how your skills stack up, we’ve included a quiz to assess your baseline SQL knowledge.
MySQL Setup & Install
For students who haven’t completed our intro course, we’ll demonstrate exactly how to download and install the tools that we’ll need to access MySQL, including MySQL Community Server & MySQL Workbench. We’ll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we’ll analyze throughout the course.
Traffic Analysis & Optimization
In this section we’ll use MySQL to analyze where our website traffic is coming from, how different sources perform in terms of traffic volume and conversion rates, and how we can adjust bids to optimize our budgets.
Website Measurement & Testing
In this section we’ll dive into page-level website data to compare traffic and conversion rates, and use MySQL to build and analyze conversion funnels to help optimize the customer purchase experience.
MID-COURSE PROJECT: Preparing data for the executive board meeting
Channel Analysis & Optimization
In this section we’ll dig deeper into our traffic channel mix, explore paid vs. free traffic, break down performance by device type, and write advanced SQL queries to conduct some time-series analyses to understand trending and seasonality.
Product-Level Analysis
In this section we’ll use MySQL to break down product-level sales and conversion rates, analyze cross-selling patterns, and use refund rates to keep a pulse on quality.
User-Level Analysis
In this section we’ll take a closer look at user behavior and repeat sessions, and use MySQL techniques to identify our most valuable customers and explore which channels they are coming from.
FINAL PROJECT: Building a data-driven growth story for potential investors
Unlike other SQL courses, this one is uniquely designed to sharpen your business intelligence and analytical thinking skills; as you complete course projects and exercises, you’ll actually see patterns and trends emerging in the data based on your findings. For those looking to pursue a career in analytics, this course is a must.
What you’ll learn
- Write advanced SQL queries to explore and analyze databases with MySQL Workbench
- Learn how to use subqueries and temporary tables to handle complex multi-step data problems
- Solve practical hands-on assignments and real-world eCommerce use cases
- Analyze data across multiple tables with powerful MySQL JOIN statements
- Master unique tips and tools that you won’t find anywhere else
- Get LIFETIME access to resource files, quizzes, assignments, and expert support
Table of Contents
Getting Started
1 Course Structure & Outline English
2 READ ME Important Notes for New Students
3 DOWNLOAD Course Resources
4 Introducing the Course Project English
5 Setting Expectations English
Prerequisite Skills
6 Introduction English
7 Prerequisite Skills English
MySQL Intro & Setup
8 Introduction English
9 MySQL Installation Overview English
10 Mac Download English
11 Mac Download English
12 PC Download English
13 Connecting MySQL Workbench to the Server English
14 MySQL Workbench Interface English
15 Creating the Maven Fuzzy Factory Database English
16 Getting to Know the Database English
17 USE mavenfuzzyfactory; English
Analyzing Traffic Sources
18 Introduction English
19 Analyzing Top Traffic Sources English
20 ASSIGNMENT Finding Top Traffic Sources English
21 SOLUTION Finding Top Traffic Sources English
22 ASSIGNMENT Traffic Source Conversion Rates English
23 SOLUTION Traffic Source Conversion Rates English
24 Bid Optimization & Trend Analysis English
25 ASSIGNMENT Traffic Source Trending English
26 SOLUTION Traffic Source Trending English
27 ASSIGNMENT Bid Optimization for Paid Traffic English
28 SOLUTION Bid Optimization for Paid Traffic English
29 ASSIGNMENT Trending w Granular Segments English
30 SOLUTION Trending w Granular Segments English
Analyzing Website Performance
31 Introduction English
32 Analyzing Top Website Pages & Entry Pages English
33 ASSIGNMENT Finding Top Website Pages English
34 SOLUTION Finding Top Website Pages English
35 ASSIGNMENT Finding Top Entry Pages English
36 SOLUTION Finding Top Entry Pages English
37 Analyzing Bounce Rates & Landing Page Tests English
38 ASSIGNMENT Calculating Bounce Rates English
39 SOLUTION Calculating Bounce Rates English
40 ASSIGNMENT Analyzing Landing Page Tests English
41 SOLUTION Analyzing Landing Page Tests English
42 ASSIGNMENT Landing Page Trend Analysis English
43 SOLUTION Landing Page Trend Analysis English
44 Building Conversion Funnels & Testing Conversion Paths English
45 ASSIGNMENT Building Conversion Funnels English
46 SOLUTION Building Conversion Funnels English
47 ASSIGNMENT Analyzing Conversion Funnel Tests English
48 SOLUTION Analyzing Conversion Funnel Tests English
MID-COURSE PROJECT
49 Introduction English
50 ASSIGNMENT Mid English
51 SOLUTION Mid English
Analysis for Channel Portfolio Management
52 Introduction English
53 Analyzing Channel Portfolios English
54 ASSIGNMENT Analyzing Channel Portfolios English
55 SOLUTION Analyzing Channel Portfolios English
56 ASSIGNMENT Comparing Channel Characteristics English
57 SOLUTION Comparing Channel Characteristics English
58 ASSIGNMENT Cross English
59 SOLUTION Cross English
60 ASSIGNMENT Analyzing Channel Portfolio Trends English
61 SOLUTION Analyzing Channel Portfolio Trends English
62 Analyzing Direct, Brand English
63 ASSIGNMENT Analyzing Direct Traffic English
64 SOLUTION Analyzing Direct Traffic English
Analyzing Business Patterns and Seasonality
65 Analyzing Business Patterns & Seasonality English
66 ASSIGNMENT Analyzing Seasonality English
67 SOLUTION Analyzing Seasonality English
68 ASSIGNMENT Analyzing Business Patterns English
69 SOLUTION Analyzing Business Patterns English
Product Analysis
70 Introduction English
71 Analyzing Product Sales & Product Launches English
72 ASSIGNMENT Product English
73 SOLUTION Product English
74 ASSIGNMENT Analyzing Product Launches English
75 SOLUTION Analyzing Product Launches English
76 Analyzing Product English
77 ASSIGNMENT Product English
78 SOLUTION Product English
79 ASSIGNMENT Building Product English
80 SOLUTION Building Product English
81 Cross English
82 ASSIGNMENT Cross English
83 SOLUTION Cross English
84 ASSIGNMENT Product Portfolio Expansion English
85 SOLUTION Product Portfolio Expansion English
86 Analyzing Product Refund Rates English
87 ASSIGNMENT Analyzing Product Refund Rates English
88 SOLUTION Analyzing Product Refund Rates English
User Analysis
89 Introduction English
90 Analyzing Repeat Visit & Purchase Behavior English
91 ASSIGNMENT Identifying Repeat Visitors English
92 SOLUTION Identifying Repeat Visitors English
93 ASSIGNMENT Analyzing Time to Repeat English
94 SOLUTION Analyzing Time to Repeat English
95 ASSIGNMENT Analyzing Repeat Channel Behavior English
96 SOLUTION Analyzing Repeat Channel Behavior English
97 ASSIGNMENT Analyzing New & Repeat Conversion Rates English
98 SOLUTION Analyzing New & Repeat Conversion Rates English
FINAL PROJECT
99 ASSIGNMENT Final Project English
100 SOLUTION Final Project English
101 Introduction English
Wrapping Up
102 Resources & Next Steps
103 BONUS LESSON
Resolve the captcha to access the links!