Tag: SQL
-
Cleaning Messy Data: Missing Values, Duplicates and Inconsistent Labels (Data Analyst Series, Part 9)
Real exports arrive broken. Learn to profile a dataset and fix the five recurring problems, missing values, duplicates, inconsistent text, wrong types and outliers, in a repeatable order.
-
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 Joins: Combining Tables with INNER and LEFT JOIN (Data Analyst Series, Part 7)
Learn SQL joins the practical way. INNER JOIN keeps matches, LEFT JOIN keeps every row, and the ON versus WHERE trap that quietly drops the rows you need.
-
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.
-
How Data Is Stored: Tables, Types, CSV Files and Databases (Data Analyst Series, Part 5)
Tables, data types, CSV files and databases explained for beginners, so the SQL in the next parts reads like plain sentences instead of a puzzle.
-
The Analyst Toolkit and a Skills Roadmap for Beginners (Data Analyst Series, Part 2)
The four tools a data analyst actually uses, spreadsheets, SQL, a BI tool, and Python, and the order to learn them in so you become employable in a few months.
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