Database and DBMSIntro to DB Systems 1. Why databases exist Core idea Data grows. Files become chaotic. Teams need safe, structured, fast access to information. A database solves this by giving order, meaning, and consistency to data. Key reasons databases are needed...Jan 18 · 23 min readaiagcp.hashnode.dev
Software Development LifecycleThere are 6 phases in SDLC: Requirement Gathering and Analysis Design Development Testing Deployment Maitainance 1. Requirement Gathering and Analysis: Functional Requiremtns Non Functional Requirements Functional Requirements Definition: Descri...Jan 18 · 3 min readaiagcp.hashnode.dev
Introduction to Data AnalyticsThe data analytics landscape is built around three core approaches: descriptive (what happened), predictive (what could happen), and prescriptive (what should we do). Descriptive Analytics – Understanding the Past Purpose: Summarizes historical dat...Jan 18 · 11 min readaiagcp.hashnode.dev
Data WarehouseModule 1: Guide to Core Concepts 1. What is an Operational System (OLTP)? An operational system is the system that supports day-to-day business operations. It handles frequent, real-time transactions such as order entry, payments, inventory updates, ...Jan 18 · 25 min readaiagcp.hashnode.dev
ETL PipelineBig Picture: ETL vs ELT ETL (Extract → Transform → Load): Transform happens before loading into the target warehouse/mart. Common when target compute is limited or rules must be enforced early. ELT (Extract → Load → Transform): Raw data is loaded ...Jan 18 · 11 min readaiagcp.hashnode.dev
