SQL for Business Analysts

How to see the data in a database. Now you have access to the data base. You can now use the basic functions of joining and grouping data. Next, you will need to learn how to search a PostgreSQL data base.

This course is designed to teach you how to utilize SQL to make informed decisions. The course is centered around a case study involving an online movie rental company that maintains a database with various customer information, movie ratings, and actor background information. SQL queries can be used to analyze customer preferences, sales development, and more. Additionally, the course covers SQL extensions for online analysis processing (OLAP), which allow for the exploration of multidimensional aggregated data. By taking this course, you will gain valuable insights into data-driven decision-making and learn how to use SQL for data analysis effectively.

Now you are ready to learn SQL basics to develop practical skills. This course will be using a database that was created by a fictional rental company. The database is complex and large so you'll be able see the problems of working with databases. This course will teach SQL skills that can be used to solve business-driven questions. This course will give you the skills to find the tables you need. This will enable you to manage data in the views and tables you create. This will allow you to create code that communicates clearly your intent and is easily read.

Companies keep track everything, from marketing to operations to human resources. These data can be used by businesses to better understand their customers, and to improve performance. This course will help you understand the most important metrics that businesses use to measure their success. These metrics will be calculated with SQL queries and report-ready results by you. This course will teach you how to use data from a fictional delivery service that delivers food. It is based on real data.

You will learn how to create complex reports. This course will help you use the SQL concepts and functions you have learned in previous courses. Your dashboard will be created. You'll be able navigate the Olympics database and become an data explorer. Data is imperfect. Learn valuable strategies for solving real-world SQL problems. These strategies include how to remove data duplication and organize messy information into clean reports. In one report, you will learn complex calculations using window functions and multi-layered computations. Anyone who regularly pulls data from databases will find this class useful. This class is also great for those who use R or Python for data science.