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

Jeffrey James

$9.99 ~~$137.99~~

Video Oct 2017 1hr 57mins 1st Edition

Jeffrey James

$9.99 ~~$137.99~~

Video Oct 2017 1hr 57mins 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

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.