15 docs tagged with "database"

BCA Semester 2 Complete Guide 2025-26 | RDBMS, SQL, PL/SQL, Database Management | VD Computer Tuition

Master BCA Semester 2 with comprehensive RDBMS tutorials, SQL programming, PL/SQL development, and database management.

Java Map Interface | HashMap vs TreeMap | Key-Value Storage

Master the Java Map interface. Learn to store data in key-value pairs using the Digital Assistant scenario. Compare HashMap and TreeMap.

PostgreSQL Tutorial | Advanced Open-Source Database | VD Docs

Master PostgreSQL, the world's most advanced open-source relational database. Learn JSONB, Window Functions, and Geographic data handling.

Python Database Integration | SQL & NoSQL | SQLite & MongoDB

Learn how to connect Python to databases. Master SQLite (built-in), MySQL, and MongoDB using the Digital Librarian scenario.

SQL & Databases Hub | Oracle, MySQL, PostgreSQL | VD Docs

Your central resource for learning SQL and database management. Master universal concepts and explore dialect-specific features for Oracle, MySQL.

SQL BACKUP Database | Create Database Backups | VD Computer Tuition

Learn how to create full and partial database backups in SQL using BACKUP DATABASE, pg_dump, and mysqldump commands with practical examples.

SQL Commands Cheat Sheet

Quick reference for SQL DDL, DML, and query commands

SQL Database Management | CREATE, DROP, & BACKUP

Master the administration of SQL databases. Learn how to create secure database containers, manage deletions, and perform essential backups.

SQL DDL Basics | CREATE, ALTER, DROP | Oracle Table Management

Learn Data Definition Language (DDL) in Oracle. Master how to create, modify, and delete table structures using the Architect's Blueprint scenario.

SQL DML Basics | INSERT, UPDATE, DELETE | Oracle Data Management

Master Data Manipulation Language (DML) in Oracle. Learn how to add, change, and remove data within your tables using the Warehouse Manager scenario.

SQL Filtering with WHERE | Comparison & Logical Operators | Universal SQL

Learn how to filter data in SQL using the WHERE clause. Master AND, OR, LIKE, and BETWEEN operators with the Police Investigation 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 Querying Basics | SELECT, FROM, AS | Universal SQL Guide

Master the fundamental SQL SELECT and FROM clauses. Learn how to extract data from tables using the Digital Filing Cabinet scenario.

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.