SQL Fundamentals for Business Intelligence – Learn the Basics of SQL Server for Business Intelligence
Many of us know a bit of SQL. But when it comes to answering real-world business questions, let us down our rusty memories of database classes!
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. The “Foo Bar” allowed anywhere, just from the problems of the wild, brought into the educational space. You will also learn tricks to get external data into the database, without worrying too much about DBA functions and considerations.
You will 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 learn how to answer business questions from a set of data.
Table of Contents:
– Installing Postgres and Our Initial Dataset
– Putting SQL Clauses into Practice
– The Big Picture of Non-Trivial SQL with Examples
Manufacturer: Packt Publishing
Language of instruction: English
Teacher: Jeffrey James
Level of training: Elementary, Secondary
Time of training: 2 hours +
File size: 457 MB