Exercise: Yearly Sales Report | Codebasics

Go to Home

0% Completed

- Login
- Register

back

- Login
- Register

0% Completed

Contents

1.1: The Rise of Databases at AtliQ
1.2: Relational vs No-SQL Database
1.3: AtliQ Hardware’s Business Model
1.4: Profit & Loss Statement
1.5: ETL, Data Warehouse, OLAP vs OLTP, Data Catalog
1.6: Fact vs Dimension Table, Star vs Snowflake Schema, Data Import
1.7: Simplified: What is Kanban?
1.8: Quiz
1.9: Chapter Summary

2.1: Backlog Grooming Meeting: Gross Sales Report
2.2: User-Defined SQL Functions
2.3: Exercise: User-Defined SQL Functions
2.4: Gross Sales Report: Monthly Product Transactions
2.5: Gross Sales Report: Total Sales Amount
2.6: Exercise: Yearly Sales Report
2.7: Stored Procedures: Monthly Gross Sales Report
2.8: Stored Procedure: Market Badge
2.9: Benefits of Stored Procedures
2.10: Quiz

3.1: Problem Statement and Pre-Invoice Discount Report
3.2: Performance Improvement # 1
3.3: Performance Improvement # 2
3.4: Database Views: Introduction
3.5: Database Views: Post Invoice Discount, Net Sales
3.6: Exercise: Database Views
3.7: Top Markets and Customers
3.8: Exercise: Top Products
3.9: The Two Most Important Skills for the Data Analyst
3.10: Quiz

4.1: Supply Chain Basics : Simplified
4.2: Problem Statement
4.3: Create a Helper Table
4.4: Database Triggers
4.5: Database Events
4.6: Temporary Tables & Forecast Accuracy Report
4.7: Exercise: CTE, Temporary Tables
4.8: Subquery vs CTE vs Views vs Temporary Table
4.9: User Accounts and Privileges
4.10: Database Indexes: Overview
4.11: Database Indexes: Composite Index
4.12: Database Indexes: Index Types
4.13: Quiz

Instructor

Dhaval Patel

Dhaval Patel

Data Entrepreneur | YouTuber | Ex - Bloomberg, Nvidia

I have 17 years of experience in Programming and Data Science working for big tech companies like NVIDIA and Bloomberg. I also run a famous YouTube channel called Codebasics where I pursue my passion for teaching. Codebasics is one of the top channels on YouTube when it comes to data science, machine learning, data structures, etc. I firmly believe that “Anyone can code” and I use analogies, simple explanations, and step-by-step storytelling to explain difficult concepts in such a way that even a high school student can understand them easily.

Exercise: Yearly Sales Report

Prev

Lecture Content Locked

Enroll in Bootcamp to Unlock

Login

Log in with Google

Log in with Linkedin

E-Mail Address

Enter your Password

Forgot Password?

Don't have an account? Register Now!

By signing up, you agree to
our Terms and Conditions and Privacy Policy.