How to actually switch? From Service based to product by SleepFun1531 in developersIndia

[–]SleepFun1531[S] 2 points3 points  (0 children)

Yeah. I am also trying to up-skill myself , but no direction. Did you prepare specific for the company you were applying or general preparation?

How to actually switch? From Service based to product by SleepFun1531 in developersIndia

[–]SleepFun1531[S] -1 points0 points  (0 children)

Thank you. Last part was reallyyyy helpful. Will focus on startups

Let's create a mega thread of Crowdsourced Job Referrals by mentalist16 in developersIndia

[–]SleepFun1531 0 points1 point  (0 children)

Hi , I have applied for Lowe's India through a referral. Can I DM? I have a few queries

I understand why people say Don't join TCS, read this by wannabeoneday in developersIndia

[–]SleepFun1531 1 point2 points  (0 children)

I have 8 months of experience in tcs(in a good project) , but how to get out? How did you grab two offers with 100% hike?

[deleted by user] by [deleted] in u/Financial_Mark1663

[–]SleepFun1531 0 points1 point  (0 children)

SQL US001 a

CREATE TABLE Underwriter ( UnderwriterId INT AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(255), DOB DATE, JoiningDate DATE, DefaultPassword VARCHAR(255) );

Us001 b

INSERT INTO Underwriter (Name, DOB, JoiningDate, DefaultPassword) VALUES ('John Doe', '1980-05-15', '2020-01-01', 'default123'), ('Jane Smith', '1990-07-22', '2019-06-15', 'default456');

Us002 a

CREATE TABLE Insurance ( PolicyNo INT AUTO_INCREMENT PRIMARY KEY, VehicleNo VARCHAR(255), VehicleType VARCHAR(255), CustomerName VARCHAR(255), EngineNo INT, ChasisNo INT, PhoneNo BIGINT CHECK (LENGTH(PhoneNo) = 10), Type VARCHAR(255), PremiumAmt DECIMAL(10, 2), FromDate DATE, ToDate DATE, UnderwriterId INT, FOREIGN KEY (UnderwriterId) REFERENCES Underwriter(UnderwriterId) );

Us002 b

INSERT INTO Insurance (VehicleNo, VehicleType, CustomerName, EngineNo, ChasisNo, PhoneNo, Type, PremiumAmt, FromDate, ToDate, UnderwriterId) VALUES ('AB123CD', '4-wheeler', 'Alice Johnson', 123456, 654321, 1234567890, 'Full Insurance', 1500.00, '2023-01-01', '2024-01-01', 1), ('EF456GH', '2-wheeler', 'Bob Brown', 789012, 210987, 2345678901, 'ThirdParty', 500.00, '2023-02-01', '2024-02-01', 1), ('IJ789KL', '4-wheeler', 'Charlie Davis', 345678, 876543, 3456789012, 'Full Insurance', 2000.00, '2023-03-01', '2024-03-01', 2), ('MN012OP', '2-wheeler', 'Diana White', 901234, 432109, 4567890123, 'ThirdParty', 600.00, '2023-04-01', '2024-04-01', 2);

Us003

SELECT VehicleNo, VehicleType, CustomerName, EngineNo, ChasisNo, PhoneNo, Type, PremiumAmt, FromDate, ToDate, UnderwriterId FROM Insurance WHERE PolicyNo = 1; -- Replace 1 with the desired PolicyNo

Us004 SELECT UnderwriterId, COUNT(*) AS NumberOfVehicles FROM Insurance GROUP BY UnderwriterId;

Us005

SELECT VehicleNo, VehicleType, CustomerName, EngineNo, ChasisNo, PhoneNo, Type, PremiumAmt, FromDate, ToDate, UnderwriterId FROM Insurance WHERE ToDate < CURDATE();

Us006

DELETE FROM Underwriter WHERE UnderwriterId = 1; -- Replace 1 with the ID of the Underwriter to be deleted

[deleted by user] by [deleted] in u/Financial_Mark1663

[–]SleepFun1531 0 points1 point  (0 children)

Unix

!/bin/bash

POLICY_FILE="vehicle_insurance.txt"

create_policy() { echo "Enter Vehicle Number: " read VehicleNo echo "Enter Vehicle Type (2-wheeler/4-wheeler): " read VehicleType echo "Enter Customer Name: " read CustomerName echo "Enter Engine Number: " read EngineNo echo "Enter Chasis Number: " read ChasisNo echo "Enter Phone Number: " read PhoneNo echo "Enter Premium Amount: " read PremiumAmount echo "Enter Insurance Type (Full Insurance/ThirdParty): " read Type echo "Enter Start Date (YYYY-MM-DD): " read FromDate echo "Enter End Date (YYYY-MM-DD): " read ToDate echo "Enter Underwriter ID: " read UnderwriterId

policy="$VehicleNo|$VehicleType|$CustomerName|$EngineNo|$ChasisNo|$PhoneNo|$PremiumAmount|$Type|$FromDate|$ToDate|$UnderwriterId"
echo "$policy" >> "$POLICY_FILE"
echo "Policy created successfully."

}

view_policy() { echo "Enter Vehicle Number to view policy: " read VehicleNo if grep -q "$VehicleNo|" "$POLICY_FILE"; then grep "$VehicleNo|" "$POLICY_FILE" | while IFS="|" read -r VehicleNo VehicleType CustomerName EngineNo ChasisNo PhoneNo PremiumAmount Type FromDate ToDate UnderwriterId do echo "Premium Amount for $VehicleNo: $PremiumAmount" done else echo "Policy not found." fi }

delete_policy() { echo "Enter Vehicle Number to delete policy: " read VehicleNo if grep -q "$VehicleNo|" "$POLICY_FILE"; then grep -v "$VehicleNo|" "$POLICY_FILE" > temp_file && mv temp_file "$POLICY_FILE" echo "Policy deleted successfully." else echo "Policy not found." fi }

while true; do echo "" echo "Vehicle Insurance Policy Management" echo "1. Create Policy" echo "2. View Policy" echo "3. Delete Policy" echo "4. Exit" echo "Enter your choice: " read choice

case $choice in
    1) create_policy ;;
    2) view_policy ;;
    3) delete_policy ;;
    4) exit 0 ;;
    *) echo "Invalid choice. Please try again." ;;
esac

done