Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Fundamentals for Business Intelligence
Rating: 4.2 out of 5(11 ratings)
62 students

SQL Fundamentals for Business Intelligence

Get business insights from your SQL database
Created byPackt Publishing
Last updated 11/2017
English

What you'll 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

Course content

3 sections • 16 lectures • 1h 56m 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.

  • Installing pgAdmin2:16

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

  • Downloading and Restoring the DVD Rental Database2:24

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

  • Installing PG, PGAdmin and Importing the Database

Requirements

  • Basic understanding of SQL.

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.

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:

  • 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.

Report abuse