What you'll 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
Course content
2 sections * 37 lectures * 4h 46m total length
Requirements
Basic understanding of SQL
Description
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
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 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
Analysts and developers who have a basic understanding of SQL, data and databases.