SQL Fundamentals for Business Intelligence
course

SQL Fundamentals for Business Intelligence

This course will help you reach an Intermediate level in SQL and teach you how to write maintainable and specific SQL queries to answer common business questions. We will work through a series of real world examples that will build your understanding of how to write complex SQL queries. You will also learn how to work with popular BI tools like Excel and Tableau to conduct further analysis and display your data effectively.

Packt
Updated Dec 08, 2024

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 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. Style and Approach: This course will teach you how to get a grip on real-world SQL and write complex queries to answer very specific questions and will help them "Think in SQL". 


Target Audience 

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. 


Business Outcomes 

  • Develop your SQL skills and learn how to answer business questions from data
  • 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
  • Discover everything you need to know to query your database and feed the results into Tableau, Excel, or other tools for further analysis