database

-- Create the IT Jobs table CREATE TABLE IT_Jobs ( id INT AUTO_INCREMENT PRIMARY KEY, role VARCHAR(100) NOT NULL, experience VARCHAR(50), skills VARCHAR(255), salary_usa VARCHAR(50), salary_india VARCHAR(50) ); -- Insert sample data into IT_Jobs table INSERT INTO IT_Jobs (role, experience, skills, salary_usa, salary_india) VALUES ('Front-End Developer', '0–5 yrs', 'HTML, CSS, JavaScript, React/Vue', '$55K–$110K', '₹4 L–₹10 L'), ('Back-End Developer', '1–6 yrs', 'Node.js, Python, Java, APIs', '$65K–$125K', '₹5 L–₹12 L'), ('Full Stack Developer', '2–8 yrs', 'React + Node.js, DBs, Git', '$80K–$140K', '₹6 L–₹15 L'), ('Mobile App Developer', '1–6 yrs', 'Swift, Kotlin, Flutter, APIs', '$70K–$130K', '₹5.5 L–₹13 L'), ('iOS Developer', '1–5 yrs', 'Swift, Xcode, iOS SDK', '$75K–$130K', '₹6 L–₹14 L'), ('Android Developer', '1–5 yrs', 'Kotlin, Android Studio, Gradle', '$70K–$125K', '₹5.5 L–₹13 L'), ('Web Developer', '0–4 yrs', 'HTML5, CSS3, JavaScript, CMS', '$50K–$95K', '₹4 L–₹9 L'), ('Software Engineer', '2–10 yrs', 'SDLC, OOP, Git, CI/CD', '$80K–$150K', '₹6 L–₹16 L'), ('Game Developer', '2–8 yrs', 'Unity, Unreal, C#', '$65K–$120K', '₹5 L–₹12 L'), ('DevOps Engineer', '3–10 yrs', 'AWS, Docker, Kubernetes, CI/CD', '$90K–$160K', '₹7 L–₹18 L'); -- Cloud & Infrastructure examples INSERT INTO IT_Jobs (role, experience, skills, salary_usa, salary_india) VALUES ('Cloud Engineer', '2–8 yrs', 'AWS/Azure/GCP certs, Terraform', '$85K–$150K', '₹6.5 L–₹17 L'), ('Cloud Solutions Architect', '5–12 yrs', 'Cloud architecture, networking', '$120K–$200K', '₹10 L–₹25 L'), ('AWS Specialist', '2–7 yrs', 'AWS certs, EC2, S3, Lambda', '$90K–$155K', '₹7 L–₹18 L'), ('Azure Cloud Administrator', '2–6 yrs', 'Azure AD, networking, PowerShell', '$80K–$140K', '₹6 L–₹15 L'), ('GCP Engineer', '2–6 yrs', 'Google Cloud certs, Kubernetes', '$80K–$140K', '₹6 L–₹15 L'); -- Cybersecurity examples INSERT INTO IT_Jobs (role, experience, skills, salary_usa, salary_india) VALUES ('Security Analyst', '1–5 yrs', 'SIEM, firewalls, incident response', '$70K–$120K', '₹5.5 L–₹12 L'), ('Cybersecurity Engineer', '3–8 yrs', 'CompTIA Sec+, CEH, tools', '$90K–$150K', '₹7 L–₹15 L'), ('Ethical Hacker / Penetration Tester', '2–7 yrs', 'Kali Linux, Pen testing', '$80K–$140K', '₹6 L–₹14 L'), ('SOC Analyst', '0–4 yrs', 'SIEM tools, logs', '$60K–$100K', '₹4.5 L–₹10 L'), ('Security Compliance Manager', '5–12 yrs', 'NIST, GDPR, audits', '$110K–$180K', '₹9 L–₹20 L'); -- You can continue similarly for other categories (Data, QA, Emerging Tech, Support, etc.)