Business Intelligence with SQLServer: Create SQL Reports
About this Course
In this 1.5 hour project-based course, you will learn how to use SQL (structured query language) to join tables, aggregate related data and derive business intelligence. We will do this by analyzing the historical data of a medical specimen pickup service. Learners will take on the role of an intermediate level database developer to join tables and aggregate related data for calculation using SQL server functions. Then, we will use a report generator to create presentable reports with these SQL statements. Relational database and SQL are industry standards and this will allow you to transfer what you have learned to other relational database systems as well. This course is aimed at learners with intermediate level of SQL and MSSQL Server. To succeed in this course, you should have already mastered these skills: SQLServer: Tables. SQL: Select, where, order by.Created by: Coursera Project Network
Related Online Courses
This specialization is intended for both students and businesses who aim to learn more about how Cloud technology can help them grow. With Developer, System Operator and Devops courses, users will... more
We are introducing a new course to replace the \"Coding with ChatGPT\" course in the Generative AI specialization. This updated course will cover materials, models, and content released in 2024.... more
This course offers a comprehensive exploration of dairy cattle nutrition, focusing on feeding strategies for cows, calves, and heifers. Students will learn to formulate diets, identify key... more
Fundamentals of Project Management offers a comprehensive introduction to the key principles and practices necessary to lead successful projects. You will learn how to navigate each phase of the... more
This course provides an intermediate-level exploration of Robotics Process Automation (RPA) within the realm of smart manufacturing, catering to manufacturing engineers, process designers,... more