SQL: Business Intelligence with SQL: 2-in-1
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
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.
Instructor
- 3.9 Instructor Rating
- 48,048 Reviews
- 429,253 Students
- 689 Courses
Packt are an established, trusted, and innovative global technical learning publisher, founded in Birmingham, UK with over eighteen years experience delivering rich premium content from ground-breaking authors and lecturers on a wide range of emerging and established technologies for professional development.
Packt’s purpose is to help technology professionals advance their knowledge and support the growth of new technologies by publishing vital user focused knowledge-based content faster than any other tech publisher, with a growing library of over 9,000 titles, in book, e-book, audio and video learning formats, our multimedia content is valued as a vital learning tool and offers exceptional support for the development of technology knowledge.
We publish on topics that are at the very cutting edge of technology, helping IT professionals learn about the newest tools and frameworks in a way that suits them.