Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL: Business Intelligence with SQL: 2-in-1
Rating: 4.2 out of 5(18 ratings)
129 students

SQL: Business Intelligence with SQL: 2-in-1

Collect, analyze, and visualize crucial data
Created byPackt Publishing
Last updated 4/2018
English

What you'll learn

  • Get data into the system: common approaches including the basics of indexing
  • 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
  • Master advanced topics such as materialized views, common table expressions, advanced data grouping, and more
  • Uncover key insights about your customers, suppliers, and business performance
  • Use your database to make crucial business decisions and grow the bottom line

Course content

2 sections • 37 lectures • 4h 46m total length

  • The Course Overview4:14

    This video gives an overview of entire course.

  • Installation on Windows and Mac Via PostgresApp3:17

    The aim of the video is to install Postgres on Mac and Windows operating systems.

    • For Windows, install Postgres via official site
    • For Mac, install Postgres via official site
    • Learn some basic psql commands
  • Installing pgAdmin2:16

    The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage.

    • Know why to not use pgAdmin 4
    • Download pgAdmin
    • Test our connection to localhost
  • Downloading and Restoring the DVD Rental Database2:24

    The aim of this video is to import our first dataset, the DVD rental database.

    • Download PostgreSQL sample database
    • Unzip to get the .tar file
    • Restore the DB using pgAdmin
  • Test your knowledge
  • SELECT, WHERE, GROUP BY, and COUNT Clauses13:09

    The goal of this video is to build the mental model of SQL by exploring the SELECT, WHERE, GROUP BY and COUNT clauses.

    • Focus on a single table without JOINs
    • Explore the clauses individually to know its operation
  • Most Common JOINs10:44

    The aim of the video is to use the most common JOINS namely INNER and LEFT bringing data together.

    • Ascertain why to use PostgreSQL JOIN clause
    • Understand and use the INNER JOIN clause
    • Understand and use the LEFT JOIN clause
  • More LEFT JOIN and SELF JOIN9:45

    The aim of this video is to learn more about LEFT JOIN and also about SELF JOIN clause to help bring data together.

    • Discuss multi-table joins and compare with INNER JOIN result
    • Use correlated subquery, that is SELF JOIN, which also JOINs a table to itself
  • Everything Is a Table7:02

    The goal of this video is to select from queries and nesting your SQL.

    • Discover why is everything a table
    • Alias your sub-selects
    • Learn the CTE (common table expression)
  • JOIN and Filtering Gotchas – Common Errors to Avoid7:28

    The goal of this video is to learn the common JOIN and filtering Gotchas mistakes to avoid.

    • Take a look at WHERE clause restricting a LEFT JOIN
    • Chain logical conditions
  • WHERE Versus HAVING for Filtering8:18

    The aim of this video is to use strategies for filtering on aggregates.

    • Use the WHERE clause to filter on the non-aggregates
    • Use HAVING clause to filter aggregates such as COUNTs, SUMs, MAXs, and so on.
  • Test your knowledge
  • Subqueries9:21

    The goal of this video is to filter your data using subqueries, a useful and very flexible filtering strategy.

    • Filter down data without multiple WHERE clauses
    • Create a unique JOIN condition
    • Follow an example
  • Correlated Subqueries6:00

    The aim of the video is to compute many similar values, avoiding JOINs.

    • Understand how the subquery declares a relationship to the outer query
    • Discover how it is useful when you want multiple variants of the same concept
    • Follow an example
  • Common Table Expressions (CTEs)7:37

    The aim of this video is to use common table expressions to turn messy queries into organized code.

    • Uncover and understand common table expressions
    • Use the common table expression to prepare cleaner code if you don’t want to use a view
    • Follow an example
  • Dealing with Dates and Times7:28

    The aim of this video is to use strategies which will help sort data into dates and time for analysis.

    • Study about the operation and uses of EXTRACT function, TO_CHAR, INTERVAL
    • Study about the operation and uses of current_date, ::date and age
    • Follow an example
  • The CASE Statement5:58

    The goal of this video is to use the CASE statement, which is similar to the IF”statement of SQL.

    • Discover in detail about the CASE statement
    • Understand how it manually computes a dimension, using an existing dimension
    • Follow an example
  • Inserting External Data11:54

    The goal of this video is to learn how to insert external data.

    • Learn a use case for integrating external data
    • Create a table
    • Upload a csv via. pgAdmin
  • Test your knowledge

Requirements

  • Basic understanding of SQL

Description

With every new version of SQL Server, new features that support and expand business intelligence capabilities and facilitate BI reporting and analysis are getting popular.

The main purpose of this comprehensive course is to assist you on how to use SQL business intelligence to collect, analyze, and visualize crucial data and to support better business decision making and also to extend your knowledge of SQL, databases, and BI

The main purpose of this comprehensive course is to assist you on how to use SQL business intelligence to collect, analyze, and visualize crucial data and to support better business decision making and also to extend your knowledge of SQL, databases, and BI

 Contents and Overview

This training program includes 2 complete courses, carefully chosen to give you the most comprehensive training possible.

The first course, SQL Fundamentals for Business Intelligence, will take you to an intermediate level of familiarity with SQL in the context of writing maintainable and sophisticated SQL for specific business queries. Start by importing your first dataset which will be the DVD rental database. Then explore and put into practice various SQL clauses and Join types. You’ll also learn tricks to get external data into the database, without worrying excessively about DBA functions and considerations. Also you’ll 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.

The second course, Advanced Applied SQL for Business Intelligence and Analytics, runs 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. Finally, you’ll have gone through all the examples and coded them out, and be ready to confidently tackle non-trivial problems.

By the end of this training program, you will have developed your SQL skills and learnt how to answer business questions from the set of data.

About the Author

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 ranging from customer value analysis to 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.

Who this course is for:

  • Analysts and developers who have a basic understanding of SQL, data and databases.

Report abuse