October 2017
Beginner
1h 57m
English
Closed Captioning available in English
Overview
In this 1 hr course, you will enhance your data analysis skills by mastering SQL for Business Intelligence. Through real-world examples, you'll learn to query and analyze data stored in databases and apply it in popular BI tools like Excel and Tableau.
What I will be able to do after this course
- Understand how to install and set up Postgres and pgAdmin tools to interact with your SQL databases.
- Gain mastery over critical SQL clauses such as SELECT, JOIN, and WHERE for effective data querying.
- Learn to use subqueries and common table expressions (CTEs) for advanced data manipulation and filtering.
- Acquire skills to handle date and time manipulations to facilitate temporal data analysis using SQL.
- Discover how to incorporate external datasets into your database for enhanced data integration.
Course Instructor(s)
Jeffrey James is an experienced data analyst and educator with over a decade of expertise in SQL and Business Intelligence. Having worked in multiple industries, Jeffrey brings a practical perspective to data analytics. His teaching approach focuses on hands-on learning, making complex database concepts approachable and actionable.
Who is it for?
This course is ideal for data analysts and developers who have a basic understanding of SQL and wish to advance their skills. Learners who interact with data and databases in their roles will benefit from practical, real-world query development strategies. Business professionals looking to integrate SQL skills into their toolbox for enhanced data-driven decision-making will also find this course valuable. It is suitable for those aiming for more sophisticated data analysis techniques.