Advanced MySQL Data Analysis / with John Pauler and Maven Analytics.

Format:

Video

Author/Creator:

Pauler, John, speaker.

Contributor:

Analytics, Maven, speaker.

linkedin.com (Firm)

Language:

English

Genre:

Instructional films.

Educational films.

Physical Description:

1 online resource

Place of Publication:

Carpenteria, CA : linkedin.com, 2024.

System Details:

Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.

digital

Summary:

Learn advanced SQL techniques for marketing analytics, and apply them to real-world cases using a custom-built ecommerce database.

MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, learn advanced MySQL techniques and apply them to real-world business challenges using a unique, custom-built ecommerce database. Instructor John Pauler starts by introducing the course project, installing the tools you'll need to access your database, and reviewing the core SQL skills that you should be comfortable with before starting the course, including SELECT statements, aggregate functions, and table joins. From there, work through a number of analytics deep dives, including traffic analysis and optimization, website measurement and testing, channel mix, product performance, user analysis, and more. For each topic, John introduces the business concept, reviews the SQL tools that you'll be applying, and then jumps straight into hands-on exercises and course projects. Note: This course was created by John Pauler and Maven Analytics. We are pleased to host this training in our library.

Participant:

Presenter: John Pauler

Notes:

10/18/202412:00:00AM

Access Restriction:

Restricted for use by site license.