Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Advanced Applied SQL for Business Intelligence and Analytics
Advanced Applied SQL for Business Intelligence and Analytics

Advanced Applied SQL for Business Intelligence and Analytics: Develop your knowledge of SQL to grow your business and advance your career

Arrow left icon
Profile Icon Jeffrey James
Arrow right icon
$137.99
Full star icon Full star icon Full star icon Full star icon Full star icon 5 (1 Ratings)
Video Feb 2018 2hrs 49mins 1st Edition
Video
$137.99
Subscription
Free Trial
Renews at $19.99p/m
Arrow left icon
Profile Icon Jeffrey James
Arrow right icon
$137.99
Full star icon Full star icon Full star icon Full star icon Full star icon 5 (1 Ratings)
Video Feb 2018 2hrs 49mins 1st Edition
Video
$137.99
Subscription
Free Trial
Renews at $19.99p/m
Video
$137.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want

Key benefits

  • Real-world datasets and analysis projects
  • Comprehensive coverage of advanced SQL techniques
  • Expert guidance from industry professionals
  • Practical demonstrations and hands-on exercises

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! All the resource files are added to the GitHub repository at https://github.com/packtpublishing/-advanced-applied-sql-for-business-intelligence-and-analytics

Who is this book for?

The course is for analysts and developers who have a basic understanding of SQL and interact with data and databases; it will help them understand query complexity with ease.

What you will learn

  • Install Postgres and import datasets
  • Perform time-based analysis using window functions
  • Conduct customer value analysis and LTV calculations
  • Analyze profitability and CPA metrics

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Feb 28, 2018
Length: 2hrs 49mins
Edition : 1st
Language : English
ISBN-13 : 9781788470803
Category :
Languages :

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want

Product Details

Publication date : Feb 28, 2018
Length: 2hrs 49mins
Edition : 1st
Language : English
ISBN-13 : 9781788470803
Category :
Languages :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 336.97
SQL Fundamentals for Business Intelligence
$137.99
Advanced Applied SQL for Business Intelligence and Analytics
$137.99
SQL Server 2017 Developer???s Guide
$60.99
Total $ 336.97 Stars icon

Table of Contents

5 Chapters
Installing Postgres and Our Initial Dataset Chevron down icon Chevron up icon
SQL in the Real World and Customer Value Analysis Chevron down icon Chevron up icon
Time between Events and Mastering Window Functions Chevron down icon Chevron up icon
Freeform Analysis of the DVD Rental Database Chevron down icon Chevron up icon
Additional Advanced Analysis of the Database Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Full star icon Full star icon 5
(1 Ratings)
5 star 100%
4 star 0%
3 star 0%
2 star 0%
1 star 0%
Cheikh Badiane Jan 17, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
cours complet sur le sql que je recommande vivement à toute personne qui veux mieux comprendre le sql.
Feefo Verified review Feefo
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.