Main site 🏠 Main Website 📚 Courses 📞 Enroll Now About Us
logo
VD Computer Tuition Surat | Learning Platform
Backup
Initializing search
    • Home
    • Academic Boards
    • 1. Python
    • 2. Java
    • 3. SQL & Databases
    • 4. Web / HTML
    • 5. JavaScript
    • 6. PHP & MySQL
    • 7. C & C++
    • References
    • Exercises
    • Certificates
    • Home
      • Overview
      • GSEB
        • Std 10
          • HTML Intro
          • Lists & Tables
          • C Intro
          • C Basics
        • Std 11
          • Linux Commands
        • Std 12
          • HTML Forms
          • Cascading Style Sheets
          • JavaScript
          • Java Basics
          • Classes & Objects
      • CBSE
        • Std 10 (IT)
          • Question Paper 2025
        • Std 11 (CS)
        • Std 12 (CS)
          • File Handling
          • Stack & Queue
          • Detailed Syllabus
      • ICSE / ISC
        • Std 10
        • Std 11
        • Std 12
      • BCA
        • Semester 2
          • Checklists
            • RDBMS Concepts
            • Programming Skills 204
          • RDBMS Lab
            • PL/SQL Salary Deduction
            • PL/SQL Control Structures
            • PL/SQL Data Handling
            • PL/SQL Emp/Dept Calculations
            • PL/SQL Patient Retrieval
            • PL/SQL Product Totalsale
            • SQL Employee Project
    • 1. Python
      • Intro
        • Installation
        • Hello World
        • Features & Apps
      • Foundations
        • Variables & Data Types
        • Keywords & Literals
        • Numbers & Casting
        • Operators
        • Booleans
        • Strings
      • Control Flow
        • Loops
        • Comparisons
        • Break, Continue & Pass
      • Data Structures
        • Tuples
        • Dictionaries
        • Sets
        • Comparisons
      • Functions
        • Lambda Functions
        • List Comprehension
      • OOP
        • Classes & Objects
        • Constructors
        • Inheritance
        • Access Modifiers
        • Abstraction & Encapsulation
      • Exceptions
        • Multiple Exceptions
        • Raise & Finally
      • Files & Data
        • CSV Handling
        • Excel & JSON
      • Modules
        • Standard Libraries
      • Algorithms
        • Sorting
      • Data Science
        • pandas Intro
        • pandas Series
        • DataFrame Basics
        • Indexing & Selection
        • CSV with pandas
      • Advanced
        • Regex & Multiprocessing
        • Magic & CLI
        • Stack & Queue
      • Database Integration
      • Tkinter (GUI)
      • Reference
        • Methods
        • MCQs
      • Practice Lab
        • Foundations Bucket
          • Hello World
          • User Input
          • Arithmetic
          • Type Conversion
          • Data Types & Sizes
          • ASCII Values
          • Sum & Average
          • Swap Variables
    • 2. Java
      • Intro
        • Get Started
        • Syntax & Output
        • Comments
      • Foundations
        • Data Types
        • Operators
        • Strings
        • Booleans
        • Math
        • Type Casting
      • Control Flow
        • Switch
        • Loops
        • Break & Continue
        • Arrays
      • Methods
        • Overloading
        • Recursion
      • OOP
        • Classes & Objects
        • Attributes & Methods
        • Constructors
        • Modifiers & Encapsulation
        • Inheritance
        • Polymorphism
        • Abstraction & Interface
        • Packages & API
        • Inner, Anonymous & Enum
        • Aggregation
        • Composition
      • Collections
        • Lists
        • Sets
        • Maps
        • Algorithms
      • Exceptions
        • Try-with-Resources
        • Errors vs Exceptions
      • File I/O
        • I/O Streams
      • Advanced
        • Wrapper & Generics
        • Regex & Threads
      • Reference
        • Quiz
        • Interview Prep
      • Practice Lab
    • 3. SQL & Databases
      • Intro
        • Syntax
        • Data Types
        • Operators
        • Commands
      • Querying
        • Filtering (WHERE)
        • SELECT Statements
        • INSERT
        • INSERT Multiple
        • UPDATE
        • DELETE
        • Delete Duplicates
      • Clauses
        • WHERE
        • DISTINCT
        • ORDER BY
        • LIMIT / FETCH
        • Aliases
        • GROUP BY
        • HAVING
        • WITH (CTE)
      • Operators
        • IN & BETWEEN
        • LIKE & Wildcards
        • NULLs
        • EXISTS & CASE
        • Set Operators
      • Joins
        • INNER JOIN
        • OUTER JOINs
        • CROSS & SELF JOIN
        • Recursive JOIN
        • Joins (Intermediate)
      • Aggregates
        • COUNT & SUM
        • AVG
        • MIN & MAX
        • Grouping
      • Subqueries
        • Subqueries (Intermediate)
      • Tables
        • CREATE TABLE
        • ALTER TABLE
        • DROP TABLE
        • Copy & Temp Tables
      • Constraints
        • NOT NULL & UNIQUE
        • CHECK & DEFAULT
        • Keys
        • Advanced Keys
      • Data Management
        • DML
      • Database Operations
        • Create Database
        • Drop Database
        • Backup
      • Views & Indexes
        • Indexes
      • Functions
      • Advanced
        • Stored Procedures
        • Basics
          • DISTINCT
          • WHERE
          • LIKE
          • IN
          • BETWEEN
          • Logical Operators
          • NULLs
          • Sorting
          • Limiting Rows
        • Joins
          • LEFT JOIN
          • CROSS & SELF JOIN
          • FULL JOIN
          • PIVOT
          • Set Operators
          • Visual Recap
        • DDL
          • Data Types
          • Constraints
          • Sequences
        • DML
          • Advanced INSERT
          • MERGE
          • Temp Tables
        • Objects
          • Indexes
          • Synonyms
        • Analytics
          • Grouping
          • Advanced Grouping
      • Oracle PL/SQL
        • Basics
        • Foundations
          • Comments
          • Anonymous Block
          • Variables
          • Constants
          • Data Types
        • Variables
        • Control Structures
          • IF Statement
          • CASE Statement
          • Loops
        • Control (Detail)
          • IF Statements
          • CASE Statements
          • Basic Loop
          • WHILE Loop
          • FOR Loop
          • CONTINUE
          • NULL Statement
          • GOTO
        • Data
          • Records
        • Collections
        • Subprograms
          • Procedures
          • Functions
          • Subprogram Functions
          • Packages
          • Implicit Results
        • Cursors
          • Cursor Parameters
          • Cursor FOR Loop
          • Updatable Cursor
          • REF CURSOR
        • Triggers
          • INSTEAD OF Trigger
        • Exceptions
          • RAISE
          • Propagation
          • Unhandled Exceptions
      • Reference
        • Quick Reference
        • Quiz
    • 4. Web / HTML
      • Basics
        • Tags & Elements
        • Attributes
        • Comments
        • First Web Page
      • Formatting
      • Links
      • Tables
      • Media
      • Forms
      • HTML5
      • APIs
      • SEO & Accessibility
      • Performance
      • Best Practices
      • Projects
    • 5. JavaScript
      • Intro
        • Syntax & Comments
        • Output
        • Where to Write JS
      • Foundations
        • Data Types
        • Operators
        • Numbers
        • Strings
        • Functions
        • Objects
        • Events
      • Control Flow
        • Comparisons
        • Loops
        • Break & Continue
      • Arrays
        • const Arrays
        • Array Methods
        • Array Iteration
      • DOM
        • DOM Navigation
        • Changing the DOM
        • DOM Events
      • Async JavaScript
        • Promises
        • Async / Await
      • ES6+
        • Classes
        • Destructuring & Spread
        • Modules
      • Web APIs
        • Storage
      • Reference
    • 6. PHP & MySQL
      • Intro
        • Setup (XAMPP)
        • Hello World
      • Foundations
        • Strings
        • Numbers
        • Operators
      • Control Flow
        • switch & match
        • Loops
      • Functions
      • Arrays & Strings
      • OOP
      • Forms & Sessions
        • Sessions & Cookies
      • MySQL & PDO
        • SELECT Queries
        • INSERT, UPDATE, DELETE
        • Prepared Statements
      • File Handling
      • Practice Projects
      • Reference
        • MCQs
      • C Tutorial
        • C Foundations
        • C Course Foundations
          • 2D Numeric Array
          • 2D Character Array
          • Structure & Union
          • User Defined Functions
          • Best Practices
          • Common Mistakes
          • Debugging Techniques
          • Performance Tips
          • Testing Methods
          • Code Review Guide
        • C Resources
      • C++ Tutorial
        • C++ Foundations
    • References
        • SQL SELECT Queries
        • Python MySQL Connection
        • Java MySQL Connection
        • Loops (For & While)
        • HTML Forms Basics
        • Python Resources
        • Java Resources
        • Oracle Resources
        • Database Connectivity
        • Variables & Data Types
        • Function Architecture
        • Loop Efficiency
        • Rosetta Stone
    • Exercises
      • Problem Solving
        • Area Calculations
          • Rectangle
          • Triangle
          • Circle
        • Temperature
          • Fahrenheit to Celsius
          • Celsius to Fahrenheit
        • Unit Conversion
          • mm to cm
          • cm to mm
        • Degrees to Radians
        • Electricity Bill
        • Sorting Algorithms
    • Certificates
    1. Home
    2. 3. SQL & Databases
    3. Database Operations

    Backup

    Copyright © 2026 VD Computer Tuition - All rights reserved
    Made with Material for MkDocs