by Jeffrey James | Released October 2017 | ISBN: 9781788471176

Learn how to use SQL business intelligence to collect, analyze, and visualize crucial data and to support better business decision making.About This VideoDevelop your SQL skills and learn how to answer business questions from dataWork on realistic case studies and examples that will guide you step by step through understanding requirements, reviewing the database, and developing the right queriesDiscover everything you need to know to query your database and feed the results into Tableau, Excel, or other tools for further analysisIn DetailMany 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. Show and hide more Publisher resources Download Example Code

1. Chapter 1 : Installing Postgres and Our Initial Dataset
   • The Course Overview 00:04:14
   • Installation on Windows and Mac Via PostgresApp 00:03:18
   • Installing pgAdmin 00:02:17
   • Downloading and Restoring the DVD Rental Database 00:02:24
2. Chapter 2 : Putting SQL Clauses into Practice
   • SELECT, WHERE, GROUP BY, and COUNT Clauses 00:13:09
   • Most Common JOINs 00:10:44
   • More LEFT JOIN and SELF JOIN 00:09:45
   • Everything Is a Table 00:07:02
   • JOIN and Filtering Gotchas – Common Errors to Avoid 00:07:29
   • WHERE Versus HAVING for Filtering 00:08:19
3. Chapter 3 : The Big Picture of Non-Trivial SQL with Examples
   • Subqueries 00:09:22
   • Correlated Subqueries 00:06:00
   • Common Table Expressions (CTEs) 00:07:37
   • Dealing with Dates and Times 00:07:28
   • The CASE Statement 00:05:58
   • Inserting External Data 00:11:54
Show and hide more