6 docs tagged with "intermediate"

HTML5 Semantic Tags Complete Guide | VD Computer Tuition

Comprehensive guide to HTML5 semantic tags. Learn modern web structure with header, nav, main, article, section, aside, and footer elements.

Indexing & Selection in pandas | loc, iloc, Filtering | VD Docs

Master row and column selection in pandas DataFrames using loc (label-based) and iloc (position-based). Learn to filter rows with boolean conditions.

Python Methods Reference | Strings, Lists & Dictionaries | VD Docs

A quick-lookup guide for the most useful Python methods. Master string manipulation, list management, and dictionary lookups with the Multi-Tool scenario.

SQL Grouping | GROUP BY & HAVING | Universal SQL Guide

Learn how to summarize data in SQL using GROUP BY and aggregate functions like COUNT, SUM, and AVG. Includes the Class Report Card scenario.

SQL Joins Master Class | INNER, LEFT, RIGHT | Universal SQL Guide

Master SQL Joins with Venn diagrams and real-world scenarios. Learn how to combine data from multiple tables in Oracle, MySQL, and PostgreSQL.

SQL Subqueries | Nested Queries | Inception Logic Guide

Master SQL Subqueries (Nested Queries). Learn how to use a query inside another query with the Inception scenario. Covers Oracle, MySQL, and PostgreSQL.