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
AWS: Database
AWS: Databases Course is the fourth course of Exam Prep DVA-C02: AWS Certified Developer Associate Specialization. This course assists learners in learning the core concepts of NoSQL, contrasting it with traditional SQL databases. It covers key aspects of DynamoDB, including compute capacity, read consistency, transactions, and streams. The course also explores other NoSQL options like Amazon MemoryDB for Redis, covering cluster setup, data loading, and its comparison with ElastiCache for Redis. Finally, it provides an overview of Amazon RDS, a managed relational database service. This cours
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
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
Business Intelligence & Visualization
Learn how to transform marketing data into dashboards, reports, and visual stories that support better business decisions. In this course, you’ll build data models and KPI frameworks that connect marketing objectives to measurable outcomes while learning how to design dashboards that are accurate, visually clear, and useful for stakeholders. You’ll use Looker Studio and spreadsheet tools to create interactive reports that combine data from platforms such as GA4, Google Ads, and CRM exports. Along the way, you’ll learn dashboard design principles, data visualization best practices, and storyt
All levels