UtkarshYadav01

-- REPLACE INTO SQL Demonstration
-- This script demonstrates how REPLACE INTO combines INSERT and DELETE operations
-- to simplify the process of updating or inserting records based on primary or unique key values.

-- Create and use database
CREATE DATABASE replace_demo;
USE replace_demo;

-- Create products table
CREATE TABLE products (

UtkarshYadav01

-- SQL DELETE Tutorial
-- Demonstrates how to remove records from a database table
-- DELETE FROM table_name WHERE condition;

-- Create a database for our examples
CREATE DATABASE delete_tutorial;

-- Use the database
USE delete_tutorial;

UtkarshYadav01

-- =============================================
-- MySQL Subqueries Demonstration 
-- Online Store Database Example
-- =============================================

-- Create database and set it as the active database
CREATE DATABASE online_store;
USE online_store;

-- =============================================

UtkarshYadav01

-- Create the database
CREATE DATABASE store_inventory;

-- Switch to the new database
USE store_inventory;

-- Create products table
CREATE TABLE products (
    product_id INT PRIMARY KEY,
    product_name VARCHAR(50) NOT NULL,

UtkarshYadav01

==========================================
              Docker Commands
==========================================

1. docker --version
   - Check version.

2. docker images
   - List all Docker images.

UtkarshYadav01

==========================
 Maven Build Lifecycle Phases
==========================

1. validate
   - Validate the project is correct and all necessary information is available.

2. compile
   - Compile the source code of the project.

UtkarshYadav01

Bash Terminal Commands

The basic terminal commands for navigating and manipulating directories and files are as follows:

---

File Content Commands

cat Command

UtkarshYadav01

JSP Tag Cheat Sheet

1. Scriptlet Tag (<% %>)

• Used for writing Java code directly within a JSP.

  <% int count = 42; %>

2. Declaration Tag (<%! %>)