16 docs tagged with "database"

BCA Semester 2 Complete Guide & Syllabus

Master BCA Semester 2 with comprehensive RDBMS tutorials, SQL programming, PL/SQL development, and database management. Complete VNSGU BCA student study guide.

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. Complete.

Phase 7: Advanced — Python Exercises | VD Docs

Practice file I/O, exception handling, algorithms (search/sort), and database basics with three levels of challenges. Free student notes & practical code guide.

PostgreSQL Tutorial | Advanced Open-Source Database | VD Docs

PostgreSQL tutorial — master the most advanced open-source relational database. Covers setup, DDL, DML, SELECT, joins, and PostgreSQL-specific features.

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. Complete student exam study guide.

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

SQL commands cheat sheet — DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE), SELECT with WHERE, JOIN, ORDER BY, and GROUP BY. Quick reference.

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. Complete.

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. Complete.

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.