PowerBI Training & AI Agents

Key Topics :

Introduction to Databases & DBMS

Relational Database Management Systems (RDBMS)

ACID Properties (Atomicity, Consistency, Isolation, Durability)

Introduction to PostgreSQL

PostgreSQL Installation & Setup (Windows, Mac, Linux)

PostgreSQL Tools: psql, pgAdmin 4

Database Objects (Databases, Schemas, Tables)

Data Types: Numeric, Character, Date/Time, Boolean, Special types

Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK, DEFAULT

Creating Databases and Tables

INSERT Operations and Data Population

Referential Integrity

Key Topics :

SELECT Statement Basics

Column Aliases and Expressions

WHERE Clause and Filtering

Comparison Operators (=, !=, >, <,>=, <=) - Logical Operators (AND, OR, NOT) - BETWEEN, IN, LIKE operators - NULL handling (IS NULL, IS NOT NULL) - ORDER BY (Sorting data) - DISTINCT (Removing duplicates) - LIMIT and OFFSET (Pagination) - String Functions (UPPER, LOWER, CONCAT, SUBSTRING, etc.) - Numeric Functions (ROUND, CEIL, FLOOR, ABS, etc.) - Date and Time Functions (CURRENT_DATE, EXTRACT, DATE_TRUNC, etc.) - Aggregate Functions (COUNT, SUM, AVG, MIN, MAX) - GROUP BY and HAVING

Window Functions (ROW_NUMBER, RANK, LAG, LEAD, etc.) - JOIN Operations: - INNER JOIN - LEFT JOIN / RIGHT JOIN - FULL OUTER JOIN - CROSS JOIN - SELF JOIN - Multi-table Joins - Join Optimization

Key Topics :

Subqueries in WHERE, SELECT, FROM clauses

Correlated Subqueries

EXISTS and NOT EXISTS

IN and NOT IN with subqueries

Common Table Expressions (CTEs)

Recursive CTEs for hierarchical data

Multiple CTEs

Set Operators:

UNION and UNION ALL

INTERSECT

EXCEPT

UPDATE Statements

UPDATE with expressions

UPDATE with JOIN

DELETE Statements

DELETE with subqueries

TRUNCATE vs DELETE

Transaction Management

BEGIN, COMMIT, ROLLBACK

Savepoints

Transaction Isolation Levels

Concurrency Control

Key Topics :

ALTER TABLE Operations

Adding, Modifying, Dropping Columns

Managing Constraints

Indexes and Performance

Index Types (B-tree, Hash, GIN, GiST)

Creating and Managing Indexes

When to use indexes

Views and Abstraction

Creating Views

Updatable Views

Materialized Views

Refreshing Materialized Views

Stored Functions

PL/pgSQL Programming Language

Function Parameters and Return Types

Control Structures (IF, CASE, LOOP)

Functions Returning Tables

Stored Procedures

Procedure vs Function differences

Exception Handling in PL/pgSQL

Triggers

BEFORE, AFTER, INSTEAD OF triggers

Trigger Functions

Audit Logging with Triggers

Data Validation with Triggers

Advisory Locks

Key Topics :

Entity-Relationship (ER) Modeling

Entities, Attributes, Relationships

Relationship Types (1:1, 1:M, M:N)

ER Diagrams

Normalization Principles

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Normalization Benefits and Trade-offs

When to Denormalize

Database Design Best Practices

Naming Conventions

Data Type Selection

Primary Key Strategies

Foreign Key Design

Query Optimization

EXPLAIN and EXPLAIN ANALYZE

Reading Execution Plans

Index Strategies

Query Rewriting Techniques

Performance Tuning

Database Statistics (ANALYZE)

VACUUM and Maintenance

Connection Pooling

Table Partitioning

Key Topics :

Business Intelligence fundamentals and modern analytics

Power BI components and architecture

Interface navigation and first report creation

Understanding Desktop vs. Service capabilities

Key Topics :

File, database, cloud, and web source connectivity

Import vs. DirectQuery vs. Live Connection

Data source settings and credential management

Performance considerations for connection modes

Key Topics :

Power Query interface and applied steps

Data profiling and quality assessment

Essential transformations: filtering, splitting, merging

Reshaping: pivot, unpivot, grouping

Combining queries: append and merge operations

Key Topics :

Star schema vs. snowflake schema design

Creating and managing table relationships

Primary and foreign keys

Hierarchies and date dimension tables

Data model optimization strategies

Key Topics :

Data visualization principles and chart selection

Core visualizations: charts, tables, maps, KPIs

Interactive elements: slicers, filters, bookmarks, drill-through

Dashboard layout and mobile optimization

Storytelling with data

Key Topics :

DAX syntax and structure

Calculated columns vs. measures

Essential functions: aggregation, logical, text, date/time

CALCULATE and FILTER functions

Creating KPIs and business metrics

Key Topics :

Time intelligence functions: YTD, MTD, QTD

Prior period comparisons and growth rates

Filter context vs. row context

Variables and iterator functions

DAX performance optimization

Key Topics :

Custom visuals from AppSource

Advanced chart types: waterfall, funnel, decomposition tree

R and Python integration

AI visuals: Key Influencers, Q&A, Smart Narratives

Dynamic visuals with parameters

Key Topics :

Publishing and workspace management

Dashboards vs. reports

Data refresh and gateway configuration

Sharing strategies and Power BI apps

Integration with Teams, SharePoint, Excel, PowerPoint

Key Topics :

Power BI admin portal and tenant settings

Row-Level Security (RLS) and Object-Level Security (OLS)

Incremental refresh and aggregations

Dataflows and deployment pipelines

Performance optimization and capacity management

Enterprise licensing models

APIs and embedded analytics

Topics:

Large Language Models fundamentals

Transformer architecture

Comparing major LLMs (GPT, Claude, Gemini, DeepSeek)

Evolution of LLMs from GPT-1 to 2026 frontier models

LLM architecture and tokenization

Model selection for different use cases

Cost optimization strategies

Topics:

Advanced prompt engineering techniques

Context engineering and design

Reasoning mode optimization

Reducing hallucinations

Zero-shot, few-shot, and chain-of-thought prompting

Multimodal prompting (text, image, audio)

Domain-specific prompt design

Topics:

OpenAI, Anthropic, Google, and DeepSeek APIs

LangChain 1.0 fundamentals

Create_agent abstraction

Middleware systems for customization

Multi-provider integration

Streaming and batching

Function calling and structured outputs

Cost-optimized pipelines

Topics:

Vector databases (ChromaDB, Pinecone, Qdrant)

Building production RAG pipelines

Agentic RAG and self-improving retrieval

MCP-Enhanced RAG

Embedding strategies

Hybrid search (semantic and keyword)

Document processing at scale

Hallucination reduction techniques

Topics:

Streamlit and Gradio interfaces

LangGraph Platform deployment

Cost optimization strategies

AI governance and EU AI Act compliance

API security and rate limiting

Monitoring and observability

Scaling strategies

Integration with enterprise tools

Topics:

Agentic AI fundamentals (plan, reason, act)

LangChain 1.0 Agents with middleware

Model Context Protocol (MCP)

Tool integration patterns

Enterprise adoption and use cases

Agent architectures and design patterns

Topics:

LangGraph 1.0 architecture

State management and graph-based logic

Node caching for development

Pre/Post hooks for guardrails

Building AI workflows

Production use cases

Topics:

Parallel execution with deferred nodes

Conditional routing and decision trees

Iterative refinement loops

Type-safe streaming

Essay evaluation systems

Customer feedback routing

Multi-stage approval workflows

Quality-gated content generation

Topics:

Durable state management

Built-in persistence (PostgreSQL, Redis)

Human-in-the-loop (HITL) implementations

Multi-day workflow support

Enterprise compliance and audit trails

Restart and failure recovery

Topics:

LangGraph Platform deployment

Multi-agent system design

Google A2A Protocol for agent-to-agent communication

LangSmith observability and monitoring

MCP security model

Prompt injection prevention

Compliance and audit trails

Agent guardrails and safety