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

SQL: Business Intelligence with SQL: 2-in-1, available at $19.99, has an average rating of 3.95, with 37 lectures, 3 quizzes, based on 17 reviews, and has 128 subscribers.

You will learn about 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 This course is ideal for individuals who are Analysts and developers who have a basic understanding of SQL, data and databases. It is particularly useful for Analysts and developers who have a basic understanding of SQL, data and databases.

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

Summary

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

Price: $19.99

Average Rating: 3.95

Number of Lectures: 37

Number of Quizzes: 3

Number of Published Lectures: 37

Number of Published Quizzes: 3

Number of Curriculum Items: 40

Number of Published Curriculum Objects: 40

Original Price: $199.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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

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 Jameshas 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: SQL Fundamentals for Business Intelligence

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

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

Lecture 6: Most Common JOINs

Lecture 7: More LEFT JOIN and SELF JOIN

Lecture 8: Everything Is a Table

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

Lecture 10: WHERE Versus HAVING for Filtering

Lecture 11: Subqueries

Lecture 12: Correlated Subqueries

Lecture 13: Common Table Expressions (CTEs)

Lecture 14: Dealing with Dates and Times

Lecture 15: The CASE Statement

Lecture 16: Inserting External Data

Chapter 2: Advanced Applied SQL for Business Intelligence and Analytics

Lecture 1: The Course Overview

Lecture 2: Installation on Windows and Mac Via Postgres App

Lecture 3: Installing pgAdmin

Lecture 4: Downloading and Restoring the DVD Rental Database

Lecture 5: Finding First Orders

Lecture 6: The Window Function ROW_NUMBER() and Using a CTE to Find First Orders

Lecture 7: Analyzing New Versus Repeat Buyer Behavior

Lecture 8: Customer Value Analysis/LTV Case Study Part One

Lecture 9: Customer Value Analysis/LTV Case Study Part Two

Lecture 10: The LAG Function

Lecture 11: Time between Customer Orders

Lecture 12: Analyzing Our Time Since Behavioral Data

Lecture 13: NTILE Window Function

Lecture 14: First Orders

Lecture 15: Does First Rating Rented from Predict Lifetime Value?

Lecture 16: Top Five Highest Grossing Actors

Lecture 17: Films by Most Gross Revenue Per Actor

Lecture 18: Cross Shopping

Lecture 19: Computing LTV Summary Metrics Using Correlate Subqueries

Lecture 20: CPA and Profitability Analysis Project – Part One

Lecture 21: CPA and Profitability Analysis Project – Part Two

Instructors

Packt Publishing
Tech Knowledge in Motion

Rating Distribution

1 stars: 2 votes
2 stars: 1 votes
3 stars: 1 votes
4 stars: 7 votes
5 stars: 6 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!

Menu