ETL, Data Warehouse, OLAP vs OLTP, Data Catalog | 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.

ETL, Data Warehouse, OLAP vs OLTP, Data Catalog

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.