0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

SQL Fundamentals for Business Intelligence

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

Jeffrey James

€130.99

Video Oct 2017 1hr 57mins 1st Edition

Renews at €18.99p/m

Jeffrey James

€130.99

Video Oct 2017 1hr 57mins 1st Edition

Renews at €18.99p/m

Renews at €18.99p/m

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

Hands-on tutorials and practical examples
Expert guidance from industry professionals
Focus on real-world BI applications
Comprehensive coverage of SQL fundamentals

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.

Who is this book for?

This course is for analysts and developers who have a basic understanding of SQL who interact with data and databases, helping them to understand the complexity of the queries with ease.

What you will learn

Install Postgres and pgAdmin
Master SQL SELECT, JOIN, and WHERE clauses
Utilize subqueries and CTEs for data filtering
Handle date and time manipulation with SQL
Insert external data into your database

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

Product Details

Publication date : Oct 31, 2017

Length: 1hr 57mins

Edition : 1st

Language : English

ISBN-13 : 9781788471176

Vendor :

Microsoft

Category :

Data

Languages :

SQL

Concepts :

Business Intelligence

Frequently bought together

SQL Fundamentals for Business Intelligence

SQL Fundamentals for Business Intelligence

Oct 2017 1hr 57mins

Video

€130.99

SQL Server 2016 Database Reporting

SQL Server 2016 Database Reporting

Feb 2017 3hrs 45mins

Video

€130.99

Advanced Applied SQL for Business Intelligence and Analytics

Advanced Applied SQL for Business Intelligence and Analytics

Feb 2018 2hrs 49mins

Video

€114.99

Total € 376.97

SQL Fundamentals for Business Intelligence

€130.99

SQL Server 2016 Database Reporting

€130.99

Advanced Applied SQL for Business Intelligence and Analytics

€114.99

Total € 376.97

Table of Contents

3 Chapters

Installing Postgres and Our Initial Dataset

The Course Overview

Installation on Windows and Mac Via PostgresApp

Installing pgAdmin

Downloading and Restoring the DVD Rental Database

Putting SQL Clauses into Practice

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

Correlated Subqueries

Common Table Expressions (CTEs)

Dealing with Dates and Times

The CASE Statement

Inserting External Data

Recommendations for you

Python Machine Learning By Example

Python Machine Learning By Example

Jul 2024 518 pages

eBook

€18.99 ~~€27.99~~

Building AI Applications with OpenAI APIs

Building AI Applications with OpenAI APIs

Oct 2024 252 pages

eBook

€15.99 ~~€23.99~~

Unlocking Data with Generative AI and RAG

Unlocking Data with Generative AI and RAG

Sep 2024 346 pages

eBook

€15.99 ~~€23.99~~

Building LLM Powered Applications

Building LLM Powered Applications

May 2024 342 pages

eBook

€20.98 ~~€29.99~~

RAG-Driven Generative AI

RAG-Driven Generative AI

Sep 2024 334 pages

eBook

€22.99 ~~€32.99~~

Machine Learning with PyTorch and Scikit-Learn

Machine Learning with PyTorch and Scikit-Learn

Feb 2022 774 pages

eBook

€22.99 ~~€32.99~~

Python for Algorithmic Trading Cookbook

Python for Algorithmic Trading Cookbook

Aug 2024 404 pages

eBook

€24.99 ~~€35.99~~

Microsoft Power BI - The Complete Masterclass [2023 EDITION]

Microsoft Power BI - The Complete Masterclass [2023 EDITION]

Jan 2023 14hrs 31mins

Video

€82.99

Principles of Data Science

Principles of Data Science

Jan 2024 326 pages

eBook

€15.99 ~~€23.99~~

Mastering NLP from Foundations to LLMs

Mastering NLP from Foundations to LLMs

Apr 2024 340 pages

eBook

€21.99 ~~€31.99~~

People who bought this also bought

Machine Learning Engineering with Python

Machine Learning Engineering with Python

Aug 2023 462 pages

eBook

€20.98 ~~€29.99~~

Deep Learning with TensorFlow and Keras – 3rd edition

Deep Learning with TensorFlow and Keras – 3rd edition

Oct 2022 698 pages

eBook

€20.98 ~~€29.99~~

Modern Generative AI with ChatGPT and OpenAI Models

Modern Generative AI with ChatGPT and OpenAI Models

May 2023 286 pages

eBook

€20.98 ~~€29.99~~

Generative AI with LangChain

Generative AI with LangChain

Dec 2023 368 pages

eBook

€20.98 ~~€29.99~~

Causal Inference and Discovery in Python

Causal Inference and Discovery in Python

May 2023 456 pages

eBook

€15.99 ~~€23.99~~

About the author

Jeffrey James

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

FAQs

How can I download a video package for offline viewing?

Login to your account at Packtpub.com.
Click on "My Account" and then click on the "My Videos" tab to access your videos.
Click on the "Download Now" link to start your video download.

How can I extract my video file?

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?

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.

Video
Format watched (HTML, MP4, streaming)
Chapter or section that issue relates to (if relevant)
System being played on
Browser used (if relevant)
Details of support

Why can’t I download my video package?

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

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