Advanced Applied SQL for Business Intelligence and Analytics [Video]

Advanced Applied SQL for Business Intelligence and Analytics [Video]

Jeffrey James

Extend your knowledge of SQL, databases, and BI by mastering complex topics such as materialized views, common table expressions, and advanced data grouping
Packt Subscription
FREE
$9.99/m after trial
Video
$106.25
RRP $124.99
Save 14%
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$106.25
$9.99 p/m after trial
RRP $124.99
Subscription
Video
Start a FREE 10-day trial

Frequently bought together


Advanced Applied SQL for Business Intelligence and Analytics [Video] Book Cover
Advanced Applied SQL for Business Intelligence and Analytics [Video]
$ 124.99
$ 106.25
Hands-On pfSense 2.x for Firewalls and Routers [Video] Book Cover
Hands-On pfSense 2.x for Firewalls and Routers [Video]
$ 124.99
$ 106.25
Buy 2 for $212.50
Save $37.48
Add to Cart

Video Description

This example-driven course provides thoughtful and interactive commentary throughout. We understand the common mistakes and misconceptions you might make and help you navigate tricky SQL concepts.

Window Functions are used in detail throughout the course to solve problems dealing with finding the first order or the Nth instance of an event, computing the timing between events, and new and repeat purchase behaviors among customers. You'll run through the workflow from SQL to a localhost connection in Tableau and also analysis, all of which you'll need in your professional life. Concepts such as CASE statements, common table expressions, and subqueries will be explained via case studies. You'll generate web analytics acquisition source data using Python and then create tables to store your information.

By the end of the course, you will have gone through all the examples and coded them out, and you'll be ready to confidently tackle non-trivial problems. Supercharge your data productivity today with this course and get 100x your time investment back in the next year or two!

Style and Approach

This course will teach you to master real-world SQL, write complex queries, and answer very specific questions. In short, it will help you think in SQL.

Video Preview

What You Will Learn

  • Put SQL to work for Business Intelligence
  • Develop your SQL skills to advance your career
  • Master advanced topics such as materialized views, common table expressions, advanced data grouping, and more!
  • Bring data into Excel, Tableau or other business software for further analysis and visualization
  • Uncover key insights about your customers, suppliers, and business performance
  • Use your database to make crucial business decisions and grow the bottom line
  • Avoid common mistakes that cost you credibility and time.

Authors

Video Details

ISBN 139781788470803
Course Length2 hours 49 minutes
Read More

Read More Reviews

Recommended for You

Hands-On pfSense 2.x for Firewalls and Routers [Video] Book Cover
Hands-On pfSense 2.x for Firewalls and Routers [Video]
$ 124.99
$ 106.25
Working with SQS and SNS: AWS with Python and Boto3 Series [Video] Book Cover
Working with SQS and SNS: AWS with Python and Boto3 Series [Video]
$ 36.99
$ 31.45
Threat and Vulnerability Assessment for Enterprises [Video] Book Cover
Threat and Vulnerability Assessment for Enterprises [Video]
$ 124.99
$ 106.25
Practical Artificial Intelligence for A/B Testing [Video] Book Cover
Practical Artificial Intelligence for A/B Testing [Video]
$ 124.99
$ 106.25
Implementing Business Intelligence with SQL Server 2019 [Video] Book Cover
Implementing Business Intelligence with SQL Server 2019 [Video]
$ 124.99
$ 106.25
RDS PostgreSQL and DynamoDB CRUD: AWS with Python and Boto3 [Video] Book Cover
RDS PostgreSQL and DynamoDB CRUD: AWS with Python and Boto3 [Video]
$ 54.99
$ 46.75