search close
search
0
cart
close
You have no products in your basket yet
left
Tech Categories
Best Sellers
New Releases
Books
Videos
Audiobooks
Articles
Newsletters
Free Learning
right
SQL Fundamentals for Business Intelligence [Video]

SQL Fundamentals for Business Intelligence: Get business insights from your SQL database [Video]

By Jeffrey James
$130.99
Video Oct 2017 1 hours 57 minutes 1st Edition
Video
$130.99
Subscription
$15.99 Monthly
Video
$130.99
Subscription
$15.99 Monthly

What do you get with a video?

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

Product Details

Publication date : Oct 31, 2017
Length 1 hours 57 minutes
Edition : 1st Edition
Language : English
ISBN-13 : 9781788471176
Vendor :
Microsoft
Category :
Data
Languages :
SQL (Beginner)
Concepts :
Business Intelligence
toc View table of contents toc Download Code

Key benefits

  • Develop your SQL skills and learn how to answer business questions from data
  • Work on realistic case studies and examples that will guide you step by step through understanding requirements, reviewing the database, and developing the right queries
  • Discover everything you need to know to query your database and feed the results into Tableau, Excel, or other tools for further analysis

Description

Many of us know a bit of SQL. But when it comes to answering real-world business questions, our rusty memories of database classes let us down! This video course will take you to an intermediate level of familiarity with SQL in the context of writing maintainable and sophisticated SQL for specific business queries. You will start by importing our first dataset which will be the DVD rental database. We then will explore and put into practice various SQL clauses and Join types. All examples of fundamental concepts are tightly guided by practical and hands-on exercises. No “Foo Bar” allowed anywhere, just problems from the wild, brought into the educational space. You will also learn tricks to get external data into the database, without worrying excessively about DBA functions and considerations. You’ll also find out how to take the data into popular BI tools (Excel and Tableau) and refine the analysis further while discussing the interpretation of the data. By the end of the course, you will have developed your SQL skills and learnt how to answer business questions from the set of data.

What you will learn

? Set up PostgreSQL in your environment (Mac or PC) ? Get the working files loaded ? Review the fundamentals of SQL from the unique POV of an advanced SQL write ? Get data into the system: common approaches including the basics of indexing

What do you get with a video?

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

Product Details

Publication date : Oct 31, 2017
Length 1 hours 57 minutes
Edition : 1st Edition
Language : English
ISBN-13 : 9781788471176
Vendor :
Microsoft
Category :
Data
Languages :
SQL (Beginner)
Concepts :
Business Intelligence

Table of Contents

3 Chapters
Installing Postgres and Our Initial Dataset Packt Packt
The Course Overview
Installation on Windows and Mac Via PostgresApp
Installing pgAdmin
Downloading and Restoring the DVD Rental Database
Putting SQL Clauses into Practice Packt Packt
SELECT, WHERE, GROUP BY, and COUNT Clauses
Most Common JOINs
More LEFT JOIN and SELF JOIN
Everything Is a Table
JOIN and Filtering Gotchas – Common Errors to Avoid
WHERE Versus HAVING for Filtering
The Big Picture of Non-Trivial SQL with Examples Packt Packt
Subqueries
Correlated Subqueries
Common Table Expressions (CTEs)
Dealing with Dates and Times
The CASE Statement
Inserting External Data

Recommendations for you

left arrow
Causal Inference and Discovery in Python: Unlock the secrets of modern causal machine learning with DoWhy, EconML, PyTorch and more
Causal Inference and Discovery in Python: Unlock the secrets of modern causal machine learning with DoWhy, EconML, PyTorch and more
May 2023 456
Ebook
€22.99 €32.99
€41.99
Machine Learning with PyTorch and Scikit-Learn: Develop machine learning and deep learning models with Python
Machine Learning with PyTorch and Scikit-Learn: Develop machine learning and deep learning models with Python
Feb 2022 774
Ebook
€21.99 €31.99
€38.99
Machine Learning for Algorithmic Trading: Predictive models to extract signals from market and alternative data for systematic trading strategies with Python, Second Edition
Machine Learning for Algorithmic Trading: Predictive models to extract signals from market and alternative data for systematic trading strategies with Python, Second Edition
Jul 2020 822
Ebook
€23.99 €34.99
€43.99
Mastering Microsoft Power BI – Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence, Second Edition
Mastering Microsoft Power BI – Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence, Second Edition
Jun 2022 712
Ebook
€20.98 €29.99
€37.99
Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more, Third Edition
Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more, Third Edition
Nov 2022 330
Ebook
€19.99 €28.99
€35.99
Machine Learning Engineering with Python: Manage the lifecycle of machine learning models using MLOps with practical examples, Second Edition
Machine Learning Engineering with Python: Manage the lifecycle of machine learning models using MLOps with practical examples, Second Edition
Aug 2023 462
Ebook
€20.98 €29.99
€37.99
The AI Product Manager's Handbook: Develop a product that takes advantage of machine learning to solve AI problems
The AI Product Manager's Handbook: Develop a product that takes advantage of machine learning to solve AI problems
Feb 2023 250
Ebook
€32.99 €47.99
€59.99
€35.99
Et al.: Because not all research deserves a Nobel Prize
Et al.: Because not all research deserves a Nobel Prize
Aug 2023 230
Ebook
€7.99 €11.99
€14.99
Python Machine Learning: Machine Learning and Deep Learning with Python, scikit-learn, and TensorFlow 2, Third Edition
Python Machine Learning: Machine Learning and Deep Learning with Python, scikit-learn, and TensorFlow 2, Third Edition
Dec 2019 772
Ebook
€21.99 €31.99
€38.99
Data Modeling with Snowflake: A practical guide to accelerating Snowflake development using universal data modeling techniques
Data Modeling with Snowflake: A practical guide to accelerating Snowflake development using universal data modeling techniques
May 2023 324
Ebook
€20.98 €29.99
€37.99
right arrow

Customer reviews

filter Filter
Top Reviews
Rating distribution
star-icon star-icon star-icon star-icon star-icon 0
(0 Ratings)
5 star 0%
4 star 0%
3 star 0%
2 star 0%
1 star 0%

Filter reviews by

No reviews found

People who bought this also bought

left arrow
Mastering Ubuntu Server: Explore the versatile, powerful Linux Server distribution Ubuntu 22.04 with this comprehensive guide, Fourth Edition
Mastering Ubuntu Server: Explore the versatile, powerful Linux Server distribution Ubuntu 22.04 with this comprehensive guide, Fourth Edition
Sep 2022 584
Ebook
€22.99 €32.99
€41.99
Mastering Ansible, 4th Edition: Automate configuration management and overcome deployment challenges with Ansible, Fourth Edition
Mastering Ansible, 4th Edition: Automate configuration management and overcome deployment challenges with Ansible, Fourth Edition
Dec 2021 540
Ebook
€17.99 €25.99
€32.99
Enterprise DevOps for Architects: Leverage AIOps and DevSecOps for secure digital transformation
Enterprise DevOps for Architects: Leverage AIOps and DevSecOps for secure digital transformation
Nov 2021 288
Ebook
€22.99 €32.99
€41.99
Ansible for Real-Life Automation: A complete Ansible handbook filled with practical IT automation use cases
Ansible for Real-Life Automation: A complete Ansible handbook filled with practical IT automation use cases
Sep 2022 480
Ebook
€17.99 €25.99
€31.99
Kubernetes – An Enterprise Guide: Effectively containerize applications, integrate enterprise systems, and scale applications in your enterprise, Second Edition
Kubernetes – An Enterprise Guide: Effectively containerize applications, integrate enterprise systems, and scale applications in your enterprise, Second Edition
Dec 2021 578
Ebook
€19.99 €28.99
€37.99
right arrow

Authors (1)

Profile Jeffrey James
Jeffrey James has been working in the analytics and data space since 2006. With roots in digital marketing and web analytics, he's applied analytical techniques to problems including customer value analysis, financial forecasting, machine learning, and process automation. He's made his share of mistakes on the way to mastery and understands the mindset of a beginner/learner.
See other products by Jeffrey James
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? Packt Packt
  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? Packt Packt

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? Packt Packt

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? Packt Packt

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.