Tag: SQL Queries
-
SQL GROUP BY, Aggregations and Window Functions Explained (Data Analyst Series, Part 8)
Collapse many rows into one number with GROUP BY and the aggregate functions, filter groups with HAVING, then keep every row while ranking and running totals with window functions.
-
SQL SELECT, WHERE and ORDER BY: Your First Queries (Data Analyst Series, Part 6)
Write your first real SQL queries. SELECT to choose columns, WHERE to filter rows, ORDER BY to sort and LIMIT to cap, all against a five-row sample table.
Architect’s Toolkit
PJ’s Tools
VMware Cloud Foundation
- VCF Documentation
- VCF 9 Planning & Preparation Workbook
- VCF Bill of Materials (BoM)
- VMware Compatibility Guide
- VMware Interoperability Matrix
- VMware Configuration Maximums
- VMware Ports & Protocols
- VMware Hands-on Labs
- RVTools Download
Nutanix
AI & Cloud-Native Platform
- NVIDIA Build (Model Catalog)
- NVIDIA AI Enterprise Reference Architecture
- NVIDIA NIM Performance Benchmarking
- NVIDIA NGC Catalog
- NeMo Microservices Helm Chart
- Helm Charts Repository
- Hugging Face Models
Architecture & Design
About the Author
Dr Pranay Jha
Dr. Pranay Jha is a Cloud and AI Consultant with 18+ years of experience in hybrid cloud, virtualization, and enterprise infrastructure transformation. He specializes in VMware technologies, multi-cloud strategy, and Generative AI solutions. He holds a PhD in Computer Applications with research focused on Cloud and AI, has published multiple research papers, and has been a VMware vExpert since 2016 and a VMUG Community Leader.
You May Have Missed
DrJha