SQL Fundamentals for Business Intelligence

SQL Fundamentals for Business Intelligence, available at $34.99, has an average rating of 4.35, with 16 lectures, 3 quizzes, based on 11 reviews, and has 60 subscribers.

You will learn about 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 This course is ideal for individuals who are 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. It is particularly useful 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.

Enroll now: SQL Fundamentals for Business Intelligence

Summary

Title: SQL Fundamentals for Business Intelligence

Price: $34.99

Average Rating: 4.35

Number of Lectures: 16

Number of Quizzes: 3

Number of Published Lectures: 16

Number of Published Quizzes: 3

Number of Curriculum Items: 19

Number of Published Curriculum Objects: 19

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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.

Target Audiences

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.

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.

Course Curriculum

Chapter 1: Installing Postgres and Our Initial Dataset

Lecture 1: The Course Overview

Lecture 2: Installation on Windows and Mac Via PostgresApp

Lecture 3: Installing pgAdmin

Lecture 4: Downloading and Restoring the DVD Rental Database

Chapter 2: Putting SQL Clauses into Practice

Lecture 1: SELECT, WHERE, GROUP BY, and COUNT Clauses

Lecture 2: Most Common JOINs

Lecture 3: More LEFT JOIN and SELF JOIN

Lecture 4: Everything Is a Table

Lecture 5: JOIN and Filtering Gotchas – Common Errors to Avoid

Lecture 6: WHERE Versus HAVING for Filtering

Chapter 3: The Big Picture of Non-Trivial SQL with Examples

Lecture 1: Subqueries

Lecture 2: Correlated Subqueries

Lecture 3: Common Table Expressions (CTEs)

Lecture 4: Dealing with Dates and Times

Lecture 5: The CASE Statement

Lecture 6: Inserting External Data

Instructors

Packt Publishing
Tech Knowledge in Motion

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 2 votes

4 stars: 5 votes

5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!