DivBytes

What is SQL Ans: Structured Query Language  DBMS = Data base management System MySQL is DBMS RDBMS = Relational based database management system =  basically data alg alg column me hota hai use merge krne ke liye relation to hona chahiye use maintain krna hi RDBMS, Data me primary key aur foreign key hoti hai RDBMS (Relational Database Management System) RDBMS ek aisa database management system hota है jisme data tables (rows + columns) ke form me store kiya जाता है, aur tables relationships ke through connected hote हैं. ⭐ RDBMS Kya Hotा Hai? RDBMS = Relational Database Management System Ye ek software hotा है jo: Data ko tables me store karta है Tables ke beech relationships banata है Data ko CRUD operations (Create, Read, Update, Delete) se manage karta है SQL language ka use karta है 📌 RDBMS Ka Structure 1️⃣ Table Data rows (records) aur columns (fields) me hotा है Example: Customers table 2️⃣ Row (Record / Tuple) Table ka ek complete data ent...

 I have 1 Lakhs rows Random data of Ola Ride Step I'm following here    Data Cleaning Remove Duplicate  Data Tab on Ribon ---> Trim Whitespace Sabhi me nhi aa rha ab Lets Start on SQL ==================== 1) Import CSV file , go to schema and then Table Data Import wizard   Import CSV File, go to Schema and Then table data import wizard Now Solving Problems One by One  First Question is : # Retrieve all successful bookings from data: Ans:  CREATE database Ola; Use Ola; #Retrieve all successful bookings from data: Create View Successful_Bookings As #jab bhi ham koi output nikalte hai, temporary form me store krke rakh rhe Select * From newbooking WHERE `Booking Status` = 'Success'; Select * From Successful_Bookings; Explain =========== 1️⃣ Database Creation CREATE DATABASE Ola; USE Ola; Explanation: CREATE DATABASE Ola; → नया database Ola बनाता है। USE Ola; → अब जो भी commands देंगे, वो Ola database में apply होंगे। 2️⃣ Retriev...

 sum = Add numbers, it is basically sumission  =SUM(number1, [number2], ...) Example: =SUM(A1:A7)  ⚡ Tips: You can use AutoSum for quick addition: Select a cell → click Home → AutoSum (Σ) → press Enter . Shortcut key: Alt + = (automatically inserts =SUM() ). Min = TO FIND MINIMUM VALUE  =MIN(A1:A12)  max = TO FIND MAXIMUM VALUE =MAX(A1:A13)  Right  ExamPle: =RIGHT(E2,10)  basically mere pas number hai 91 country code ke sath, main chahta hu 91 code ke bad right se 10 numbers mujhe nikal ke aa jaye yaha E2 mera column number hai and 10 jo mujhe chahiye right se Cases: किसी product code ke last digits निकालने के लिए  किसी date ya year ke last 2 digits निकालने के लिए किसी naam ke last letters निकालने के लिए Note: if I want to paste horizontally number then will use 'paste ke option me transpose left  == left se digits extract krne ke liye will use this  =LEFT(E2,2)   E2 IS CELL AND 2 IS DIG...