Business Intelligence with SQLServer: Create SQL Reports
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
Skills you'll learn
We may earn a commission if you enroll through our links — it never affects the price you pay.
Similar courses
Structured Query Language (SQL) using SAS
Course Description In this course, you learn about Structured Query Language (SQL) and how it can be used in SAS programs to create reports and query your data. “By the end of this course, a learner will be able to…” ● Query and subset data. ● Summarize and present data. ● Combine tables using joins and set operators. ● Create and modify tables and views. ● Create data-driven macro variables using a query. ● Access DBMS data with SAS/ACCESS technology.
All levels
Generative AI for Data Visualization and Data Storytelling
In today’s data-driven world, harnessing the power of Generative AI to create impactful data visualizations is essential for effective communication and decision-making. This course focuses on utilizing cutting-edge AI tools to transform raw data into dynamic, insightful visual artifacts, enhancing your ability to convey complex information clearly and compellingly. Designed for data analysts, business intelligence professionals, and anyone involved in data storytelling, this course provides practical knowledge and skills to optimize your data visualization processes using AI. You'll explore
All levels
Data Engineering with Delta Lake on Databricks
Build production-ready data pipelines using Delta Live Tables and the Medallion Architecture on Databricks. This hands-on course teaches you to design, implement, and monitor ETL workflows that transform raw data into reliable, business-ready datasets through a structured bronze-silver-gold layering pattern. This course is primarily aimed at first- and second-year undergraduates interested in engineering or science, along with professionals with an interest in programming. You will start by mastering DLT fundamentals — declarative pipeline syntax in both SQL and Python, streaming ingestion w
All levels
Data Cleaning, Transformation, and Manipulation
In Data Cleaning, Transformation, and Manipulation, you’ll learn to turn messy data into analysis- and modeling-ready datasets using Python (pandas) and SQL. This is a skill-based path organized around real workplace tasks. Each module mirrors responsibilities you see in job descriptions and focuses on the exact steps you’ll perform on the job. You’ll begin with a quick skills check, then personalize your journey: double down on new topics, or skip what you already know. For each skill, you’ll review concise lessons curated from expert instructors with explanations and demos for filtering and
All levels