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

Jeffrey James

₱7042.99

5 (1 Ratings)

Video Feb 2018 2hrs 49mins 1st Edition

Jeffrey James

₱7042.99

5 (1 Ratings)

Video Feb 2018 2hrs 49mins 1st Edition

What do you get with a video?

Download this video in MP4 format

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents

Download Code

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.