base.sql

--
-- PostgreSQL database dump
--

\restrict moOYIn7JQujQu54gf9eyF5GbjQVSgNk4qQmTRb4Wg4QzNeRCPD1TCpZqahlWjTx

-- Dumped from database version 17.8 (a48d9ca)
-- Dumped by pg_dump version 18.3

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Data for Name: User; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public."User" (id, email, password, name, "githubId", "githubToken", "createdAt", "updatedAt", phase, "userId", roadmap_credits) VALUES (1, 'paresh@gmail.com', '$2b$12$w37fzG/WTzWWZrgEllEwdeussO2BYKZ5r53FT9eqSJfh2Mm0uyr6O', 'Paresh', NULL, NULL, '2026-01-21 15:47:16.884', '2026-04-08 08:59:42.453', '4', '0SeJOK', 150);


--
-- Data for Name: Achievement; Type: TABLE DATA; Schema: public; Owner: -
--



--
-- Data for Name: Blog; Type: TABLE DATA; Schema: public; Owner: -
--



--
-- Data for Name: BlogInteraction; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public."BlogInteraction" (id, "blogTitle", interested, domain, "createdAt", "userRefId") VALUES (1, 'Meme Monday', true, 'general', '2026-02-02 15:39:46.118', '0SeJOK');
INSERT INTO public."BlogInteraction" (id, "blogTitle", interested, domain, "createdAt", "userRefId") VALUES (2, 'Should Junior Developers Still Learn JavaScript the Hard Way?', true, 'general', '2026-02-02 15:39:48.916', '0SeJOK');
INSERT INTO public."BlogInteraction" (id, "blogTitle", interested, domain, "createdAt", "userRefId") VALUES (3, 'The Compiler Never Used Sarcasm: Why AI Feels Unsafe to the Neurodivergent Coder', true, 'general', '2026-02-02 15:39:50.296', '0SeJOK');


--
-- Data for Name: Club; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public."Club" (id, name, tagline, description, president, "createdAt") VALUES (1, 'AIML Club', 'Building intelligent systems', 'AI-focused club', 'Omkar', '2026-04-07 20:53:10.912');


--
-- Data for Name: Challenge; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public."Challenge" (id, title, description, points, "clubId") VALUES (1, 'Build Classifier', 'Train ML model', 100, 1);


--
-- Data for Name: ClubMember; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public."ClubMember" (id, name, role, tier, "clubId") VALUES (1, 'Omkar', 'President', 'president', 1);
INSERT INTO public."ClubMember" (id, name, role, tier, "clubId") VALUES (2, 'Rahul', 'VP', 'vp', 1);
INSERT INTO public."ClubMember" (id, name, role, tier, "clubId") VALUES (3, 'Amit', 'Member', 'member', 1);


--
-- Data for Name: Event; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public."Event" (id, title, date, "time", venue, speaker, status, "clubId") VALUES (1, 'Intro to ML', '12 FEB', '3 PM', 'Lab 3', 'Dr. Sharma', 'UPCOMING', 1);


--
-- Data for Name: Roadmap; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (1, 'Fullstack Web Development', '{"name":"Fullstack Web Development","children":[{"name":"Frontend Fundamentals","children":[{"name":"HTML5 Mastery","moduleDescription":"Understanding the semantic structure of the web, including elements, attributes, and modern document standards.","link":"https://en.wikipedia.org/wiki/HTML5"},{"name":"CSS3 Styling","moduleDescription":"Learning layout techniques such as Flexbox and Grid, along with animations, transitions, and media queries.","link":"https://en.wikipedia.org/wiki/CSS"},{"name":"JavaScript Essentials","moduleDescription":"Introduction to programming logic, variables, loops, functions, and DOM manipulation for interactive websites.","link":"https://en.wikipedia.org/wiki/JavaScript"},{"name":"Responsive Web Design","moduleDescription":"Designing websites that provide an optimal viewing experience across a wide range of devices from mobile to desktop.","link":"https://en.wikipedia.org/wiki/Responsive_web_design"}]},{"name":"Client-Side Application Logic","children":[{"name":"ES6+ and Modern JS","moduleDescription":"Mastering advanced JavaScript concepts like Arrow Functions, Promises, Async/Await, and Destructuring.","link":"https://en.wikipedia.org/wiki/ECMAScript"},{"name":"React Framework","moduleDescription":"Building component-based user interfaces using one of the most popular frontend libraries.","link":"https://en.wikipedia.org/wiki/React_(software)"},{"name":"State Management","moduleDescription":"Learning how to manage complex application states across different components using Redux or Context API.","link":"https://en.wikipedia.org/wiki/State_management"},{"name":"Version Control with Git","moduleDescription":"Managing source code history and collaborating with other developers using Git and GitHub.","link":"https://en.wikipedia.org/wiki/Git"}]},{"name":"Server-Side Engineering","children":[{"name":"Node.js Runtime","moduleDescription":"Using JavaScript on the server-side to build scalable and high-performance network applications.","link":"https://en.wikipedia.org/wiki/Node.js"},{"name":"Express.js Framework","moduleDescription":"Setting up a minimal and flexible web application framework for Node.js to handle routing and middleware.","link":"https://en.wikipedia.org/wiki/Express.js"},{"name":"Relational Databases (SQL)","moduleDescription":"Designing schemas and managing data using relational database systems like PostgreSQL or MySQL.","link":"https://en.wikipedia.org/wiki/SQL"},{"name":"NoSQL Databases (MongoDB)","moduleDescription":"Working with document-oriented databases for flexible data storage and high-speed access.","link":"https://en.wikipedia.org/wiki/MongoDB"}]},{"name":"System Architecture and Deployment","children":[{"name":"RESTful API Design","moduleDescription":"Building standardized web services that allow the frontend and backend to communicate efficiently.","link":"https://en.wikipedia.org/wiki/Representational_state_transfer"},{"name":"Web Security Fundamentals","moduleDescription":"Implementing authentication, authorization, and protection against common threats like XSS and CSRF.","link":"https://en.wikipedia.org/wiki/Web_security_exploits"},{"name":"Docker and Containerization","moduleDescription":"Packaging applications into containers to ensure consistency across different development and production environments.","link":"https://en.wikipedia.org/wiki/Docker_(software)"},{"name":"Cloud Deployment (CI/CD)","moduleDescription":"Automating the deployment process and hosting applications on platforms like AWS, Heroku, or Azure.","link":"https://en.wikipedia.org/wiki/CI/CD"}]}]}', 0, 1, '2026-01-21 17:56:50.239');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (2, 'Devops Engineer', '{"name":"Devops Engineer","children":[{"name":"Fundamentals and Scripting","children":[{"name":"Linux Administration","moduleDescription":"Mastering the Linux operating system, file permissions, process management, and user administration which form the backbone of server management.","link":"https://en.wikipedia.org/wiki/Linux"},{"name":"Command Line Interface (CLI)","moduleDescription":"Learning to navigate and control the operating system using text-based commands rather than a GUI.","link":"https://en.wikipedia.org/wiki/Command-line_interface"},{"name":"Shell Scripting","moduleDescription":"Writing scripts using Bash or similar shells to automate repetitive tasks and manage system configurations.","link":"https://en.wikipedia.org/wiki/Shell_script"},{"name":"Python for Automation","moduleDescription":"Using Python to build more complex automation tools, interact with APIs, and manage cloud resources.","link":"https://en.wikipedia.org/wiki/Python_(programming_language)"}]},{"name":"Version Control and Networking","children":[{"name":"Git Fundamentals","moduleDescription":"Understanding distributed version control, tracking changes in source code, and managing collaborative code bases.","link":"https://en.wikipedia.org/wiki/Git"},{"name":"Branching and Merging","moduleDescription":"Learning strategies for feature branching, release management, and resolving code conflicts within a team environment.","link":"https://en.wikipedia.org/wiki/Version_control"},{"name":"Networking Basics","moduleDescription":"Understanding OSI layers, IP addressing, DNS, HTTP/S protocols, and how data moves across the internet.","link":"https://en.wikipedia.org/wiki/Computer_network"},{"name":"SSH and Security Protocols","moduleDescription":"Learning secure remote access methods and the cryptographic principles behind secure communication.","link":"https://en.wikipedia.org/wiki/Secure_Shell"}]},{"name":"CI/CD and Containerization","children":[{"name":"Continuous Integration (CI)","moduleDescription":"The practice of automating the integration of code changes from multiple contributors into a single software project.","link":"https://en.wikipedia.org/wiki/Continuous_integration"},{"name":"Docker and Containerization","moduleDescription":"Learning to package applications with all their dependencies into standardized units for consistent deployment.","link":"https://en.wikipedia.org/wiki/Docker_(software)"},{"name":"Continuous Deployment (CD)","moduleDescription":"Extending CI to automatically deploy all code changes to a testing or production environment after the build stage.","link":"https://en.wikipedia.org/wiki/Continuous_deployment"},{"name":"Jenkins and Automation Servers","moduleDescription":"Configuring and managing build pipelines using industry-standard automation tools.","link":"https://en.wikipedia.org/wiki/Jenkins_(software)"}]},{"name":"Infrastructure as Code and Cloud","children":[{"name":"Terraform","moduleDescription":"Using declarative configuration files to manage and provision data center infrastructure.","link":"https://en.wikipedia.org/wiki/Terraform_(software)"},{"name":"Cloud Service Providers (AWS/Azure)","moduleDescription":"Managing scalable infrastructure using public cloud platforms and their native services.","link":"https://en.wikipedia.org/wiki/Cloud_computing"},{"name":"Ansible for Configuration Management","moduleDescription":"Automating the software provisioning, configuration management, and application-deployment of remote servers.","link":"https://en.wikipedia.org/wiki/Ansible_(software)"},{"name":"Infrastructure as Code (IaC) Concepts","moduleDescription":"Managing and provisioning computer data centers through machine-readable definition files, rather than physical hardware configuration.","link":"https://en.wikipedia.org/wiki/Infrastructure_as_code"}]},{"name":"Orchestration and Monitoring","children":[{"name":"Kubernetes Architecture","moduleDescription":"Understanding the container orchestration system for automating application deployment, scaling, and management.","link":"https://en.wikipedia.org/wiki/Kubernetes"},{"name":"Observability and Monitoring","moduleDescription":"Implementing tools like Prometheus or Grafana to track system health and performance metrics.","link":"https://en.wikipedia.org/wiki/Monitoring"},{"name":"Log Management","moduleDescription":"Centralizing and analyzing application logs to troubleshoot issues and understand user behavior.","link":"https://en.wikipedia.org/wiki/Log_management"},{"name":"Site Reliability Engineering (SRE)","moduleDescription":"Applying software engineering principles to infrastructure and operations problems to create scalable and reliable systems.","link":"https://en.wikipedia.org/wiki/Site_reliability_engineering"}]}]}', 0, 1, '2026-01-21 18:17:23.855');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (3, 'Cyber Security', '{"name":"Cyber Security","children":[{"name":"Fundamentals of Cyber Security","children":[{"name":"Introduction to Cyber Security","moduleDescription":"Learning the core principles of the CIA triad: Confidentiality, Integrity, and Availability.","link":"https://en.wikipedia.org/wiki/Computer_security"},{"name":"Networking Basics for Security","moduleDescription":"Understanding the OSI model, TCP/IP protocols, and how data travels across networks.","link":"https://en.wikipedia.org/wiki/Computer_network"},{"name":"Common Cyber Threats","moduleDescription":"Overview of malware, phishing, social engineering, and man-in-the-middle attacks.","link":"https://en.wikipedia.org/wiki/Cyberattack"},{"name":"Basic Cryptography","moduleDescription":"Introduction to encryption, decryption, symmetric and asymmetric keys.","link":"https://en.wikipedia.org/wiki/Cryptography"}]},{"name":"Defensive Security Operations","children":[{"name":"Network Security Tools","moduleDescription":"Implementation and management of Firewalls, Intrusion Detection Systems (IDS), and Intrusion Prevention Systems (IPS).","link":"https://en.wikipedia.org/wiki/Firewall_(computing)"},{"name":"Identity and Access Management (IAM)","moduleDescription":"Controlling user permissions, Multi-Factor Authentication (MFA), and Single Sign-On (SSO) technologies.","link":"https://en.wikipedia.org/wiki/Identity_management"},{"name":"Endpoint Security","moduleDescription":"Securing individual devices such as laptops and mobile phones using Antivirus and EDR solutions.","link":"https://en.wikipedia.org/wiki/Endpoint_security"},{"name":"Incident Response","moduleDescription":"The process of identifying, containing, and eradicating cyber threats after a breach occurs.","link":"https://en.wikipedia.org/wiki/Computer_security_incident_management"}]},{"name":"Offensive Security and Pentesting","children":[{"name":"Ethical Hacking Principles","moduleDescription":"The methodology of authorized hacking to identify vulnerabilities before malicious actors do.","link":"https://en.wikipedia.org/wiki/Penetration_test"},{"name":"Vulnerability Assessment","moduleDescription":"Using automated tools to scan systems for known security weaknesses.","link":"https://en.wikipedia.org/wiki/Vulnerability_assessment"},{"name":"Web Application Security","moduleDescription":"Studying the OWASP Top 10 vulnerabilities including SQL Injection and Cross-Site Scripting (XSS).","link":"https://en.wikipedia.org/wiki/Web_application_security"},{"name":"Exploit Development","moduleDescription":"Understanding how software vulnerabilities are leveraged to execute unauthorized code.","link":"https://en.wikipedia.org/wiki/Exploit_(computer_security)"}]},{"name":"Advanced Security Architecture and Governance","children":[{"name":"Cloud Security","moduleDescription":"Securing data and infrastructure in environments like AWS, Azure, and Google Cloud.","link":"https://en.wikipedia.org/wiki/Cloud_computing_security"},{"name":"Digital Forensics","moduleDescription":"The recovery and investigation of material found in digital devices related to cybercrime.","link":"https://en.wikipedia.org/wiki/Digital_forensics"},{"name":"Governance, Risk, and Compliance (GRC)","moduleDescription":"Aligning IT security with business goals and complying with laws like GDPR and HIPAA.","link":"https://en.wikipedia.org/wiki/Governance,_risk_management,_and_compliance"},{"name":"Zero Trust Architecture","moduleDescription":"A strategic initiative that prevents data breaches by eliminating the concept of trust from an organization''s network architecture.","link":"https://en.wikipedia.org/wiki/Zero_trust_security_model"}]}]}', 0, 1, '2026-01-21 18:20:37.545');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (4, 'Cyber Security Engineer', '{"name":"Cyber Security Engineer","children":[{"name":"Foundations of Information Technology","children":[{"name":"Computer Networking","moduleDescription":"Understanding the OSI model, TCP/IP protocols, IP addressing, and how data travels across local and wide area networks.","link":"https://en.wikipedia.org/wiki/Computer_network"},{"name":"Operating Systems Administration","moduleDescription":"Mastering Windows and Linux command-line interfaces, file systems, permissions, and process management.","link":"https://en.wikipedia.org/wiki/Operating_system"},{"name":"Introduction to Cryptography","moduleDescription":"Learning the basics of encryption, decryption, symmetric and asymmetric keys, and hashing algorithms.","link":"https://en.wikipedia.org/wiki/Cryptography"},{"name":"Information Security Principles","moduleDescription":"Deep dive into the CIA Triad (Confidentiality, Integrity, Availability) and the fundamental pillars of security.","link":"https://en.wikipedia.org/wiki/Information_security"}]},{"name":"Network and Infrastructure Security","children":[{"name":"Firewalls and Network Security","moduleDescription":"Implementing and managing stateful and stateless firewalls, Access Control Lists (ACLs), and VPNs.","link":"https://en.wikipedia.org/wiki/Firewall_(computing)"},{"name":"Intrusion Detection and Prevention Systems","moduleDescription":"Setting up systems to monitor network traffic for malicious activity and policy violations.","link":"https://en.wikipedia.org/wiki/Intrusion_detection_system"},{"name":"Wireless Network Security","moduleDescription":"Securing Wi-Fi networks using WPA2/WPA3 protocols and understanding common wireless vulnerabilities.","link":"https://en.wikipedia.org/wiki/Wireless_security"},{"name":"Cloud Security Fundamentals","moduleDescription":"Understanding shared responsibility models, identity and access management (IAM), and securing cloud environments like AWS or Azure.","link":"https://en.wikipedia.org/wiki/Cloud_computing_security"}]},{"name":"Defensive Security and Incident Response","children":[{"name":"Vulnerability Management","moduleDescription":"The systematic process of identifying, categorizing, and mitigating software vulnerabilities and misconfigurations.","link":"https://en.wikipedia.org/wiki/Vulnerability_management"},{"name":"Security Operations Center (SOC) Operations","moduleDescription":"Learning to use SIEM (Security Information and Event Management) tools for real-time monitoring and log analysis.","link":"https://en.wikipedia.org/wiki/Security_operations_center"},{"name":"Digital Forensics","moduleDescription":"Techniques for recovering and investigating material found in digital devices related to cybercrimes.","link":"https://en.wikipedia.org/wiki/Digital_forensics"},{"name":"Incident Response Planning","moduleDescription":"Developing procedures to handle and limit the damage of security breaches or cyberattacks.","link":"https://en.wikipedia.org/wiki/Computer_security_incident_management"}]},{"name":"Offensive Security and Advanced Engineering","children":[{"name":"Ethical Hacking and Penetration Testing","moduleDescription":"Authorized simulated attacks on computer systems to evaluate security posture and identify weaknesses.","link":"https://en.wikipedia.org/wiki/Penetration_test"},{"name":"Web Application Security","moduleDescription":"Securing web services against OWASP Top 10 threats like SQL injection and Cross-Site Scripting (XSS).","link":"https://en.wikipedia.org/wiki/Web_application_security"},{"name":"Secure Software Development (DevSecOps)","moduleDescription":"Integrating security practices into the software development life cycle through automated testing and code analysis.","link":"https://en.wikipedia.org/wiki/DevSecOps"},{"name":"Reverse Engineering","moduleDescription":"Analyzing software to understand its internal structure, often used for malware analysis or exploit development.","link":"https://en.wikipedia.org/wiki/Reverse_engineering"}]}]}', 0, 1, '2026-01-21 18:21:30.216');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (5, 'Full Stack Developer', '{"name":"Full Stack Developer","children":[{"name":"Frontend Development Foundations","children":[{"name":"HTML5 and Semantic Web","moduleDescription":"Learning the core structure of web pages using modern HTML5 elements and accessibility standards.","link":"https://en.wikipedia.org/wiki/HTML5"},{"name":"CSS3 and Responsive Design","moduleDescription":"Mastering layout techniques like Flexbox and Grid, along with media queries for mobile-first development.","link":"https://en.wikipedia.org/wiki/CSS"},{"name":"JavaScript Essentials (ES6+)","moduleDescription":"Understanding core programming concepts, DOM manipulation, and modern syntax like arrow functions and promises.","link":"https://en.wikipedia.org/wiki/JavaScript"},{"name":"Frontend Frameworks (React/Angular/Vue)","moduleDescription":"Building complex user interfaces using component-based architectures and state management libraries.","link":"https://en.wikipedia.org/wiki/React_(software)"}]},{"name":"Backend Development and Logic","children":[{"name":"Node.js and Runtime Environments","moduleDescription":"Executing JavaScript on the server-side and managing packages using NPM or Yarn.","link":"https://en.wikipedia.org/wiki/Node.js"},{"name":"RESTful API Development","moduleDescription":"Designing and building scalable Application Programming Interfaces for client-server communication.","link":"https://en.wikipedia.org/wiki/Representational_state_transfer"},{"name":"Server-side Frameworks (Express.js)","moduleDescription":"Utilizing frameworks to handle routing, middleware, and server-side logic efficiently.","link":"https://en.wikipedia.org/wiki/Express.js"},{"name":"Authentication and Security","moduleDescription":"Implementing secure user sessions using JWT, OAuth, and password hashing techniques.","link":"https://en.wikipedia.org/wiki/JSON_Web_Token"}]},{"name":"Database Management and Persistence","children":[{"name":"Relational Databases (SQL)","moduleDescription":"Learning to model data and write complex queries using systems like PostgreSQL or MySQL.","link":"https://en.wikipedia.org/wiki/SQL"},{"name":"NoSQL Databases","moduleDescription":"Understanding document-oriented storage and horizontal scaling with MongoDB or CouchDB.","link":"https://en.wikipedia.org/wiki/NoSQL"},{"name":"Object-Relational Mapping (ORM)","moduleDescription":"Using libraries like Sequelize or Mongoose to interact with databases through code objects.","link":"https://en.wikipedia.org/wiki/Object%E2%80%93relational_mapping"},{"name":"Caching and Performance","moduleDescription":"Implementing in-memory data stores like Redis to speed up data retrieval and reduce load.","link":"https://en.wikipedia.org/wiki/Cache_(computing)"}]},{"name":"Deployment and DevOps","children":[{"name":"Version Control with Git","moduleDescription":"Managing codebases and collaborating with other developers using branching and merging strategies.","link":"https://en.wikipedia.org/wiki/Git"},{"name":"Containerization with Docker","moduleDescription":"Packaging applications and dependencies into isolated environments for consistent deployment.","link":"https://en.wikipedia.org/wiki/Docker_(software)"},{"name":"CI/CD Pipelines","moduleDescription":"Automating the testing and deployment process using Continuous Integration and Delivery tools.","link":"https://en.wikipedia.org/wiki/CI/CD"},{"name":"Cloud Computing and Infrastructure","moduleDescription":"Deploying applications to cloud providers like AWS, Azure, or GCP and managing scalable infrastructure.","link":"https://en.wikipedia.org/wiki/Cloud_computing"}]}]}', 0, 1, '2026-01-21 18:23:56.755');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (15, 'BlockChain Developer', '{"name":"BlockChain Developer","children":[{"name":"Foundations of Blockchain Technology","children":[{"name":"Introduction to Distributed Ledgers","moduleDescription":"Understanding the core concept of decentralization, peer-to-peer networks, and how distributed ledgers differ from centralized databases.","link":"https://en.wikipedia.org/wiki/Distributed_ledger"},{"name":"Cryptographic Principles","moduleDescription":"Learning about hash functions (SHA-256), digital signatures, and public-key cryptography which form the security backbone of blockchain.","link":"https://en.wikipedia.org/wiki/Cryptography"},{"name":"Consensus Mechanisms","moduleDescription":"Exploring how nodes reach agreement on the state of the blockchain through Proof of Work (PoW), Proof of Stake (PoS), and other algorithms.","link":"https://en.wikipedia.org/wiki/Consensus_(computer_science)"},{"name":"Blockchain Architecture","moduleDescription":"Studying the structure of blocks, the chain of hashes, and the lifecycle of a transaction from broadcast to confirmation.","link":"https://en.wikipedia.org/wiki/Blockchain"}]},{"name":"Smart Contract Development","children":[{"name":"Ethereum Virtual Machine (EVM)","moduleDescription":"Deep dive into the runtime environment for smart contracts in Ethereum and how the global state is managed.","link":"https://en.wikipedia.org/wiki/Ethereum"},{"name":"Solidity Programming Language","moduleDescription":"Learning the syntax, data types, and structures of Solidity, the primary language for writing smart contracts.","link":"https://en.wikipedia.org/wiki/Solidity"},{"name":"Token Standards (ERC-20 & ERC-721)","moduleDescription":"Understanding the implementation of fungible tokens (ERC-20) and non-fungible tokens (ERC-721/NFTs) on the blockchain.","link":"https://en.wikipedia.org/wiki/Non-fungible_token"},{"name":"Smart Contract Security","moduleDescription":"Identifying common vulnerabilities like reentrancy attacks and learning best practices for writing secure code.","link":"https://en.wikipedia.org/wiki/Smart_contract"}]},{"name":"Decentralized Applications (DApps)","children":[{"name":"Web3 Libraries (Web3.js & Ethers.js)","moduleDescription":"Learning how to connect frontend applications to the blockchain using JavaScript libraries to interact with smart contracts.","link":"https://en.wikipedia.org/wiki/Web3"},{"name":"Decentralized Storage (IPFS)","moduleDescription":"Integrating InterPlanetary File System (IPFS) for storing large assets off-chain while maintaining decentralization.","link":"https://en.wikipedia.org/wiki/InterPlanetary_File_System"},{"name":"Blockchain Oracles","moduleDescription":"Studying how to fetch real-world data (like price feeds) into smart contracts using decentralized oracle networks like Chainlink.","link":"https://en.wikipedia.org/wiki/Blockchain_oracle"},{"name":"DApp User Experience and Wallets","moduleDescription":"Managing user sessions, transaction signing, and integrating browser-based wallets like MetaMask.","link":"https://en.wikipedia.org/wiki/Cryptocurrency_wallet"}]},{"name":"Advanced Scaling and Ecosystems","children":[{"name":"Layer 2 Scaling Solutions","moduleDescription":"Exploring Optimistic Rollups and ZK-Rollups to increase transaction throughput and reduce gas fees.","link":"https://en.wikipedia.org/wiki/Scalability"},{"name":"Decentralized Finance (DeFi) Protocols","moduleDescription":"Analyzing the architecture of automated market makers (AMMs), lending protocols, and yield farming.","link":"https://en.wikipedia.org/wiki/Decentralized_finance"},{"name":"DAOs and Governance","moduleDescription":"Designing on-chain governance systems and Decentralized Autonomous Organizations for community-led project management.","link":"https://en.wikipedia.org/wiki/Decentralized_autonomous_organization"},{"name":"Interoperability Protocols","moduleDescription":"Learning about cross-chain bridges and communication protocols that allow different blockchains to share data and assets.","link":"https://en.wikipedia.org/wiki/Interoperability"}]}]}', 0, 1, '2026-04-07 15:15:23.999');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (18, 'Data Analyst', '{"name":"Data Analyst","children":[{"name":"Foundations of Data Analysis","children":[{"name":"Introduction to Data Analysis","moduleDescription":"Understanding the core concepts, lifecycle, and importance of data-driven decision making in modern business.","link":"https://en.wikipedia.org/wiki/Data_analysis"},{"name":"Statistical Foundations","moduleDescription":"Learning descriptive and inferential statistics, including mean, median, standard deviation, and hypothesis testing.","link":"https://en.wikipedia.org/wiki/Statistics"},{"name":"Data Ethics and Privacy","moduleDescription":"Exploring the legal and ethical implications of data collection, including GDPR and data anonymization.","link":"https://en.wikipedia.org/wiki/Information_ethics"},{"name":"Spreadsheet Proficiency","moduleDescription":"Mastering advanced Excel functions, pivot tables, and data cleaning techniques within spreadsheet software.","link":"https://en.wikipedia.org/wiki/Microsoft_Excel"}]},{"name":"Data Querying and Management","children":[{"name":"Relational Database Concepts","moduleDescription":"Understanding how data is structured in tables and the principles of relational database management systems.","link":"https://en.wikipedia.org/wiki/Relational_database"},{"name":"SQL Fundamentals","moduleDescription":"Learning the basics of SQL including SELECT statements, filtering with WHERE, and sorting data.","link":"https://en.wikipedia.org/wiki/SQL"},{"name":"Data Aggregation and Joins","moduleDescription":"Mastering complex queries to combine data from multiple tables using INNER, LEFT, and RIGHT joins.","link":"https://en.wikipedia.org/wiki/Join_(SQL)"},{"name":"Advanced SQL Functions","moduleDescription":"Utilizing window functions, subqueries, and stored procedures to perform sophisticated data manipulation.","link":"https://en.wikipedia.org/wiki/Window_function_(SQL)"}]},{"name":"Programming for Data Analysis","children":[{"name":"Python Programming Basics","moduleDescription":"Introduction to Python syntax, data types, loops, and control structures specifically for data tasks.","link":"https://en.wikipedia.org/wiki/Python_(programming_language)"},{"name":"Data Manipulation with Pandas","moduleDescription":"Using the Pandas library to load, clean, transform, and analyze structured data efficiently.","link":"https://en.wikipedia.org/wiki/Pandas_(software)"},{"name":"Numerical Computing with NumPy","moduleDescription":"Leveraging NumPy for high-performance mathematical operations on multi-dimensional arrays.","link":"https://en.wikipedia.org/wiki/NumPy"},{"name":"Exploratory Data Analysis (EDA)","moduleDescription":"The process of performing initial investigations on data to discover patterns and spot anomalies.","link":"https://en.wikipedia.org/wiki/Exploratory_data_analysis"}]},{"name":"Data Visualization and Communication","children":[{"name":"Principles of Data Visualization","moduleDescription":"Studying the theory of visual communication and how to choose the right chart for different data types.","link":"https://en.wikipedia.org/wiki/Data_visualization"},{"name":"Business Intelligence Tools","moduleDescription":"Learning to build interactive dashboards and reports using tools like Tableau or Power BI.","link":"https://en.wikipedia.org/wiki/Business_intelligence"},{"name":"Visualization Libraries (Matplotlib/Seaborn)","moduleDescription":"Creating programmatic visualizations using Python libraries for deeper customization and technical reporting.","link":"https://en.wikipedia.org/wiki/Matplotlib"},{"name":"Data Storytelling","moduleDescription":"Combining data, visuals, and narrative to explain insights effectively to non-technical stakeholders.","link":"https://en.wikipedia.org/wiki/Narrative_advising"}]},{"name":"Advanced Analytics and Machine Learning","children":[{"name":"Regression Analysis","moduleDescription":"Understanding the relationship between variables and predicting continuous outcomes using linear regression.","link":"https://en.wikipedia.org/wiki/Regression_analysis"},{"name":"Classification Techniques","moduleDescription":"Implementing algorithms to categorize data into distinct classes, such as logistic regression and decision trees.","link":"https://en.wikipedia.org/wiki/Statistical_classification"},{"name":"Clustering and Unsupervised Learning","moduleDescription":"Finding hidden patterns or groupings in data without pre-existing labels using K-means clustering.","link":"https://en.wikipedia.org/wiki/Cluster_analysis"},{"name":"Introduction to Big Data","moduleDescription":"Exploring technologies like Hadoop and Spark for analyzing massive datasets that exceed traditional memory.","link":"https://en.wikipedia.org/wiki/Big_data"}]}]}', 0, 1, '2026-04-08 08:59:41.534');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (17, 'HyperAutomate Engineer', '{"name":"HyperAutomate Engineer","children":[{"name":"Foundations of Automation","children":[{"name":"Introduction to Robotic Process Automation (RPA)","moduleDescription":"Learn the basics of software robotics to automate repetitive, rule-based tasks performed by humans on a computer.","link":"https://en.wikipedia.org/wiki/Robotic_process_automation"},{"name":"Business Process Management (BPM) Fundamentals","moduleDescription":"Understand how to discover, model, analyze, measure, improve, and optimize business strategy and processes.","link":"https://en.wikipedia.org/wiki/Business_process_management"},{"name":"Low-Code Development Platforms","moduleDescription":"Explore software development environments that allow users to create application software through graphical user interfaces instead of traditional programming.","link":"https://en.wikipedia.org/wiki/Low-code_development_platform"},{"name":"Systems Development Life Cycle (SDLC)","moduleDescription":"Master the process for planning, creating, testing, and deploying an information system in an automation context.","link":"https://en.wikipedia.org/wiki/Systems_development_life_cycle"}]},{"name":"Intermediate Process Optimization and Integration","children":[{"name":"Process Mining","moduleDescription":"Techniques for analyzing business processes based on event logs to identify bottlenecks and automation opportunities.","link":"https://en.wikipedia.org/wiki/Process_mining"},{"name":"Application Programming Interface (API) Management","moduleDescription":"Learning how to connect disparate systems using APIs to ensure seamless data flow and process continuity.","link":"https://en.wikipedia.org/wiki/API"},{"name":"Intelligent Document Processing (IDP)","moduleDescription":"Using Optical Character Recognition and AI to extract and digitize data from unstructured documents.","link":"https://en.wikipedia.org/wiki/Optical_character_recognition"},{"name":"Integration Platform as a Service (iPaaS)","moduleDescription":"Utilizing cloud-based suites to integrate various applications, data, and processes across multiple organizations.","link":"https://en.wikipedia.org/wiki/Integration_platform"}]},{"name":"Advanced AI and Cognitive Automation","children":[{"name":"Natural Language Processing (NLP)","moduleDescription":"Implementing AI that enables computers to understand, interpret, and generate human language within automated workflows.","link":"https://en.wikipedia.org/wiki/Natural_language_processing"},{"name":"Machine Learning Operations (MLOps)","moduleDescription":"The practice of reliably and efficiently deploying and maintaining machine learning models in production environments.","link":"https://en.wikipedia.org/wiki/MLOps"},{"name":"Computer Vision for Automation","moduleDescription":"Applying AI that allows automation tools to ''see'' and interact with graphical user interfaces (GUIs) like a human.","link":"https://en.wikipedia.org/wiki/Computer_vision"},{"name":"Cognitive Computing","moduleDescription":"Developing systems that simulate human thought processes in complex situations where answers may be ambiguous.","link":"https://en.wikipedia.org/wiki/Cognitive_computing"}]},{"name":"Enterprise Strategy and Digital Transformation","children":[{"name":"Automation Center of Excellence (CoE)","moduleDescription":"Structuring a central team to manage automation standards, best practices, and enterprise-wide scaling.","link":"https://en.wikipedia.org/wiki/Center_of_excellence"},{"name":"AIOps and Infrastructure Automation","moduleDescription":"Using artificial intelligence to automate IT operations, including proactive monitoring and incident response.","link":"https://en.wikipedia.org/wiki/Artificial_intelligence_for_IT_operations"},{"name":"Cybersecurity in Automation","moduleDescription":"Ensuring the security of digital workers and automated workflows against unauthorized access and data breaches.","link":"https://en.wikipedia.org/wiki/Computer_security"},{"name":"Digital Twin of an Organization (DTO)","moduleDescription":"Creating a virtual model of business processes to simulate and predict the outcomes of hyperautomation initiatives.","link":"https://en.wikipedia.org/wiki/Digital_twin"}]}]}', 0, 1, '2026-04-07 16:35:58.444');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (16, 'HyperAutomation Engineer', '{"name":"HyperAutomation Engineer","children":[{"name":"Foundations of HyperAutomation","children":[{"name":"Introduction to HyperAutomation","moduleDescription":"Understanding the convergence of RPA, AI, and Process Mining to automate complex business processes.","link":"https://en.wikipedia.org/wiki/Hyperautomation"},{"name":"Business Process Modeling Notation (BPMN)","moduleDescription":"Learning the standard graphical representation for specifying business processes in a business process model.","link":"https://en.wikipedia.org/wiki/Business_Process_Model_and_Notation"},{"name":"Digital Transformation Fundamentals","moduleDescription":"Exploring how organizations use technology to radically improve performance or reach of enterprises.","link":"https://en.wikipedia.org/wiki/Digital_transformation"},{"name":"Systems Thinking and Analysis","moduleDescription":"Analyzing how different parts of a business system interact with one another within a whole.","link":"https://en.wikipedia.org/wiki/Systems_thinking"}]},{"name":"Robotic Process Automation (RPA) Mastery","children":[{"name":"RPA Architecture and Lifecycle","moduleDescription":"Understanding the stages of RPA implementation from discovery to maintenance.","link":"https://en.wikipedia.org/wiki/Robotic_process_automation"},{"name":"Bot Development and Scripting","moduleDescription":"Creating rule-based software robots to perform repetitive human tasks.","link":"https://en.wikipedia.org/wiki/Software_tool"},{"name":"Exception Handling and Debugging","moduleDescription":"Implementing robust error-handling mechanisms to ensure bot reliability.","link":"https://en.wikipedia.org/wiki/Exception_handling"},{"name":"Attended vs. Unattended Automation","moduleDescription":"Distinguishing between bots that work with humans and those that run on back-office servers.","link":"https://en.wikipedia.org/wiki/Virtual_workforce"}]},{"name":"Process Discovery and Mining","children":[{"name":"Data Mining for Process Logs","moduleDescription":"Techniques for discovering, monitoring, and improving real processes by extracting knowledge from event logs.","link":"https://en.wikipedia.org/wiki/Process_mining"},{"name":"Task Mining and User Behavior Analysis","moduleDescription":"Capturing user interaction data to identify automation opportunities at the desktop level.","link":"https://en.wikipedia.org/wiki/Task_analysis"},{"name":"Conformance Checking","moduleDescription":"Comparing existing process models with actual event logs to find deviations.","link":"https://en.wikipedia.org/wiki/Process_mining#Conformance_Checking"},{"name":"Operational Support and Forecasting","moduleDescription":"Using process data to predict future bottle-necks and process outcomes.","link":"https://en.wikipedia.org/wiki/Predictive_analytics"}]},{"name":"Intelligent Automation (AI & ML Integration)","children":[{"name":"Cognitive Automation and OCR","moduleDescription":"Integrating Optical Character Recognition to process unstructured data from documents.","link":"https://en.wikipedia.org/wiki/Optical_character_recognition"},{"name":"Natural Language Processing (NLP)","moduleDescription":"Utilizing NLP to allow bots to understand and respond to human language.","link":"https://en.wikipedia.org/wiki/Natural_language_processing"},{"name":"Machine Learning Model Integration","moduleDescription":"Deploying predictive models within automated workflows to handle complex decision-making.","link":"https://en.wikipedia.org/wiki/Machine_learning"},{"name":"Conversational AI and Chatbots","moduleDescription":"Building automated interfaces for customer service and internal support.","link":"https://en.wikipedia.org/wiki/Chatbot"}]},{"name":"Enterprise Orchestration and Governance","children":[{"name":"Low-Code/No-Code Platforms","moduleDescription":"Using visual development environments to accelerate the delivery of automation solutions.","link":"https://en.wikipedia.org/wiki/Low-code_development_platform"},{"name":"Automation Center of Excellence (CoE)","moduleDescription":"Establishing standards, best practices, and governance for scaling automation across an enterprise.","link":"https://en.wikipedia.org/wiki/Center_of_excellence"},{"name":"IT Security and Compliance in Automation","moduleDescription":"Ensuring automated processes adhere to data privacy laws and cybersecurity protocols.","link":"https://en.wikipedia.org/wiki/Information_security"},{"name":"Continuous Improvement (PDCA) in Automation","moduleDescription":"Monitoring ROI and iteratively improving automation performance over time.","link":"https://en.wikipedia.org/wiki/PDCA"}]}]}', 2, 1, '2026-04-07 16:15:21.539');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (6, 'Full stack development', '{"name":"Full stack development","children":[{"name":"Frontend Foundations","children":[{"name":"HTML5","moduleDescription":"The standard markup language for creating the structure of web pages and web applications.","link":"https://en.wikipedia.org/wiki/HTML5"},{"name":"CSS3","moduleDescription":"A style sheet language used for describing the presentation of a document written in a markup language like HTML.","link":"https://en.wikipedia.org/wiki/CSS"},{"name":"JavaScript Essentials","moduleDescription":"The high-level, interpreted programming language that enables interactive web pages and is an essential part of web applications.","link":"https://en.wikipedia.org/wiki/JavaScript"},{"name":"Document Object Model (DOM)","moduleDescription":"A cross-platform and language-independent interface that treats an XML or HTML document as a tree structure.","link":"https://en.wikipedia.org/wiki/Document_Object_Model"}]},{"name":"Server-Side Programming","children":[{"name":"Node.js","moduleDescription":"An open-source, cross-platform, JavaScript runtime environment that executes JavaScript code outside a web browser.","link":"https://en.wikipedia.org/wiki/Node.js"},{"name":"Express.js","moduleDescription":"A back end web application framework for Node.js, designed for building web applications and APIs.","link":"https://en.wikipedia.org/wiki/Express.js"},{"name":"RESTful API Design","moduleDescription":"An architectural style that defines a set of constraints to be used for creating web services.","link":"https://en.wikipedia.org/wiki/Representational_state_transfer"},{"name":"JSON Web Token (JWT)","moduleDescription":"An Internet standard for creating data with optional signature and/or optional encryption whose payload holds JSON that asserts some number of claims.","link":"https://en.wikipedia.org/wiki/JSON_Web_Token"}]},{"name":"Database Management","children":[{"name":"Relational Databases (SQL)","moduleDescription":"A domain-specific language used in programming and designed for managing data held in a relational database management system.","link":"https://en.wikipedia.org/wiki/SQL"},{"name":"NoSQL Databases","moduleDescription":"A mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.","link":"https://en.wikipedia.org/wiki/NoSQL"},{"name":"Object-Relational Mapping (ORM)","moduleDescription":"A programming technique for converting data between incompatible type systems using object-oriented programming languages.","link":"https://en.wikipedia.org/wiki/Object%E2%80%93relational_mapping"},{"name":"Database Normalization","moduleDescription":"The process of structuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy.","link":"https://en.wikipedia.org/wiki/Database_normalization"}]},{"name":"Advanced Architecture and Deployment","children":[{"name":"Version Control (Git)","moduleDescription":"A distributed version control system for tracking changes in source code during software development.","link":"https://en.wikipedia.org/wiki/Git"},{"name":"Docker and Containerization","moduleDescription":"A set of platform as a service products that use OS-level virtualization to deliver software in packages called containers.","link":"https://en.wikipedia.org/wiki/Docker_(software)"},{"name":"CI/CD Pipelines","moduleDescription":"The combined practices of continuous integration and either continuous delivery or continuous deployment.","link":"https://en.wikipedia.org/wiki/CI/CD"},{"name":"Microservices Architecture","moduleDescription":"An architectural style that structures an application as a collection of services that are highly maintainable and testable.","link":"https://en.wikipedia.org/wiki/Microservices"}]}]}', 0, 1, '2026-01-23 07:53:55.922');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (7, 'Devops Engineer', '{"name":"Devops Engineer","children":[{"name":"Foundations and Version Control","children":[{"name":"Introduction to DevOps","moduleDescription":"Understanding the DevOps philosophy, the cultural shift, and the CAMS model (Culture, Automation, Measurement, Sharing).","link":"https://en.wikipedia.org/wiki/DevOps"},{"name":"Linux Fundamentals and CLI","moduleDescription":"Mastering the command line interface, file systems, permissions, and process management in Linux environments.","link":"https://en.wikipedia.org/wiki/Linux"},{"name":"Shell Scripting","moduleDescription":"Learning Bash or Python scripting to automate repetitive system tasks and handle text processing.","link":"https://en.wikipedia.org/wiki/Shell_script"},{"name":"Version Control with Git","moduleDescription":"Managing source code history, branching strategies, merging, and collaborating using Git and platforms like GitHub/GitLab.","link":"https://en.wikipedia.org/wiki/Git"}]},{"name":"Infrastructure and Networking","children":[{"name":"Computer Networking Basics","moduleDescription":"Understanding OSI layers, TCP/IP, DNS, HTTP/S, and Load Balancing essential for managing server communication.","link":"https://en.wikipedia.org/wiki/Computer_network"},{"name":"Infrastructure as Code (IaC)","moduleDescription":"Provisioning and managing infrastructure using code-based tools like Terraform or CloudFormation.","link":"https://en.wikipedia.org/wiki/Infrastructure_as_code"},{"name":"Configuration Management","moduleDescription":"Automating the setup and maintenance of software on servers using tools like Ansible, Chef, or Puppet.","link":"https://en.wikipedia.org/wiki/Ansible_(software)"},{"name":"Cloud Computing Platforms","moduleDescription":"Deep dive into major cloud providers like AWS, Azure, or GCP and their core services (Compute, Storage, Identity).","link":"https://en.wikipedia.org/wiki/Cloud_computing"}]},{"name":"CI/CD and Automation","children":[{"name":"Continuous Integration (CI)","moduleDescription":"Automating the process of merging code changes into a shared repository and running automated tests.","link":"https://en.wikipedia.org/wiki/Continuous_integration"},{"name":"Continuous Delivery and Deployment (CD)","moduleDescription":"Automating the release process to ensure code can be deployed to production safely and quickly at any time.","link":"https://en.wikipedia.org/wiki/Continuous_deployment"},{"name":"Build Tools and Package Management","moduleDescription":"Using tools like Maven, Gradle, or NPM to compile code and manage dependencies.","link":"https://en.wikipedia.org/wiki/Build_automation"},{"name":"Jenkins and Pipeline Orchestration","moduleDescription":"Configuring automation servers to orchestrate complex workflows and integration pipelines.","link":"https://en.wikipedia.org/wiki/Jenkins_(software)"}]},{"name":"Containerization and Orchestration","children":[{"name":"Containerization with Docker","moduleDescription":"Packaging applications and their dependencies into lightweight, portable containers for consistency across environments.","link":"https://en.wikipedia.org/wiki/Docker_(software)"},{"name":"Kubernetes Architecture","moduleDescription":"Understanding the components of a K8s cluster, including nodes, pods, services, and the control plane.","link":"https://en.wikipedia.org/wiki/Kubernetes"},{"name":"Microservices Architecture","moduleDescription":"Designing applications as a collection of loosely coupled services to improve scalability and maintainability.","link":"https://en.wikipedia.org/wiki/Microservices"},{"name":"Service Mesh and Advanced Networking","moduleDescription":"Managing service-to-service communication, security, and observability using tools like Istio or Linkerd.","link":"https://en.wikipedia.org/wiki/Service_mesh"}]},{"name":"Observability and Site Reliability","children":[{"name":"Monitoring and Alerting","moduleDescription":"Implementing real-time monitoring using Prometheus and creating visualization dashboards with Grafana.","link":"https://en.wikipedia.org/wiki/Prometheus_(software)"},{"name":"Log Management","moduleDescription":"Centralizing and analyzing application and system logs using the ELK Stack (Elasticsearch, Logstash, Kibana).","link":"https://en.wikipedia.org/wiki/Elasticsearch"},{"name":"DevSecOps and Security","moduleDescription":"Integrating security practices into the DevOps pipeline, including vulnerability scanning and secrets management.","link":"https://en.wikipedia.org/wiki/DevSecOps"},{"name":"Site Reliability Engineering (SRE)","moduleDescription":"Applying software engineering principles to operations to create highly scalable and reliable software systems.","link":"https://en.wikipedia.org/wiki/Site_reliability_engineering"}]}]}', 0, 1, '2026-01-23 08:08:54.609');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (8, 'Cyber Security Engineer', '{"name":"Cyber Security Engineer","children":[{"name":"Fundamentals of Information Security","children":[{"name":"Introduction to Information Security","moduleDescription":"Understanding the core principles of confidentiality, integrity, and availability (CIA Triad).","link":"https://en.wikipedia.org/wiki/Information_security"},{"name":"Network Fundamentals","moduleDescription":"Learning about the OSI model, TCP/IP protocols, and how data moves across networks.","link":"https://en.wikipedia.org/wiki/Computer_network"},{"name":"Operating Systems Security","moduleDescription":"Basics of securing Windows and Linux environments, including file permissions and user management.","link":"https://en.wikipedia.org/wiki/Operating_system"},{"name":"Basic Cryptography","moduleDescription":"Overview of encryption, decryption, hashing, and digital signatures.","link":"https://en.wikipedia.org/wiki/Cryptography"}]},{"name":"Security Operations and Infrastructure","children":[{"name":"Network Security Hardware","moduleDescription":"Implementing and managing Firewalls, IDS (Intrusion Detection Systems), and IPS.","link":"https://en.wikipedia.org/wiki/Network_security"},{"name":"Identity and Access Management (IAM)","moduleDescription":"Managing user identities and controlling access to resources through authentication and authorization.","link":"https://en.wikipedia.org/wiki/Identity_and_access_management"},{"name":"Security Information and Event Management (SIEM)","moduleDescription":"Using SIEM tools to aggregate logs and monitor security alerts in real-time.","link":"https://en.wikipedia.org/wiki/Security_information_and_event_management"},{"name":"Endpoint Protection","moduleDescription":"Securing workstations, mobile devices, and servers using antivirus and EDR solutions.","link":"https://en.wikipedia.org/wiki/Endpoint_security"}]},{"name":"Offensive Security and Vulnerability Management","children":[{"name":"Vulnerability Assessment","moduleDescription":"Identifying and classifying security weaknesses in a system or network.","link":"https://en.wikipedia.org/wiki/Vulnerability_assessment"},{"name":"Penetration Testing Methodology","moduleDescription":"Learning the phases of an authorized cyber attack to evaluate security posture.","link":"https://en.wikipedia.org/wiki/Penetration_test"},{"name":"Web Application Security","moduleDescription":"Focusing on common web vulnerabilities like SQL injection and Cross-Site Scripting (XSS).","link":"https://en.wikipedia.org/wiki/Web_application_security"},{"name":"Social Engineering Attacks","moduleDescription":"Understanding psychological manipulation techniques like phishing to gain unauthorized access.","link":"https://en.wikipedia.org/wiki/Social_engineering_(security)"}]},{"name":"Advanced Security Engineering and Governance","children":[{"name":"Cloud Security Architecture","moduleDescription":"Designing and securing infrastructure in cloud environments like AWS, Azure, or GCP.","link":"https://en.wikipedia.org/wiki/Cloud_computing_security"},{"name":"Digital Forensics and Incident Response","moduleDescription":"Investigating security breaches, recovering data, and handling active threats.","link":"https://en.wikipedia.org/wiki/Digital_forensics"},{"name":"Secure Software Development (DevSecOps)","moduleDescription":"Integrating security practices into the software development life cycle.","link":"https://en.wikipedia.org/wiki/DevSecOps"},{"name":"Governance, Risk, and Compliance (GRC)","moduleDescription":"Aligning IT security with business goals and legal regulations like GDPR or HIPAA.","link":"https://en.wikipedia.org/wiki/Governance,_risk_management,_and_compliance"}]}]}', 0, 1, '2026-02-13 07:39:39.922');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (9, 'AIML Engineer', '{"name":"AIML Engineer","children":[{"name":"Mathematical Foundations","children":[{"name":"Linear Algebra","moduleDescription":"Study of vectors, matrices, and linear transformations essential for understanding how data is represented and processed in AI models.","link":"https://en.wikipedia.org/wiki/Linear_algebra"},{"name":"Calculus","moduleDescription":"Focus on derivatives and gradients, which are fundamental for optimization algorithms like gradient descent used in training neural networks.","link":"https://en.wikipedia.org/wiki/Calculus"},{"name":"Probability Theory","moduleDescription":"Explores uncertainty, random variables, and distributions which allow models to make predictions and handle noisy data.","link":"https://en.wikipedia.org/wiki/Probability_theory"},{"name":"Statistics","moduleDescription":"Methods for data collection, analysis, and interpretation to validate model performance and ensure statistical significance.","link":"https://en.wikipedia.org/wiki/Statistics"}]},{"name":"Programming and Data Engineering","children":[{"name":"Python Programming","moduleDescription":"The primary language for AI/ML due to its extensive libraries and readability for complex algorithmic development.","link":"https://en.wikipedia.org/wiki/Python_(programming_language)"},{"name":"Data Manipulation with Pandas","moduleDescription":"Techniques for cleaning, transforming, and analyzing structured data using high-performance data structures.","link":"https://en.wikipedia.org/wiki/Pandas_(software)"},{"name":"Exploratory Data Analysis","moduleDescription":"Using visualization and summary statistics to understand data patterns and relationships before modeling.","link":"https://en.wikipedia.org/wiki/Exploratory_data_analysis"},{"name":"SQL and Database Management","moduleDescription":"Mastering structured query language to extract and manage data from relational database systems.","link":"https://en.wikipedia.org/wiki/SQL"}]},{"name":"Core Machine Learning","children":[{"name":"Supervised Learning","moduleDescription":"Training algorithms on labeled datasets to perform tasks like classification and regression.","link":"https://en.wikipedia.org/wiki/Supervised_learning"},{"name":"Unsupervised Learning","moduleDescription":"Discovering hidden patterns or data groupings in unlabeled datasets using clustering and association.","link":"https://en.wikipedia.org/wiki/Unsupervised_learning"},{"name":"Decision Tree Learning","moduleDescription":"A predictive modeling approach that uses a tree-like graph to model decisions and their possible consequences.","link":"https://en.wikipedia.org/wiki/Decision_tree_learning"},{"name":"Model Evaluation and Selection","moduleDescription":"Techniques such as Cross-Validation and metrics like F1-score to choose the best performing model.","link":"https://en.wikipedia.org/wiki/Model_selection"}]},{"name":"Deep Learning Architectures","children":[{"name":"Artificial Neural Networks","moduleDescription":"Computing systems inspired by biological neural networks that learn to perform tasks by considering examples.","link":"https://en.wikipedia.org/wiki/Artificial_neural_network"},{"name":"Convolutional Neural Networks","moduleDescription":"Specialized deep learning architectures primarily used for processing structured arrays of data such as images.","link":"https://en.wikipedia.org/wiki/Convolutional_neural_network"},{"name":"Recurrent Neural Networks","moduleDescription":"A class of neural networks where connections between nodes form a directed graph along a temporal sequence.","link":"https://en.wikipedia.org/wiki/Recurrent_neural_network"},{"name":"Transformer Models","moduleDescription":"Deep learning models that adopt the mechanism of self-attention, differentially weighting the significance of each part of the input data.","link":"https://en.wikipedia.org/wiki/Transformer_(machine_learning_model)"}]},{"name":"Advanced AI and Deployment","children":[{"name":"Natural Language Processing","moduleDescription":"Interaction between computers and human languages, enabling machines to read, understand, and derive meaning.","link":"https://en.wikipedia.org/wiki/Natural_language_processing"},{"name":"Reinforcement Learning","moduleDescription":"An area of machine learning concerned with how intelligent agents ought to take actions in an environment to maximize cumulative reward.","link":"https://en.wikipedia.org/wiki/Reinforcement_learning"},{"name":"MLOps (Machine Learning Operations)","moduleDescription":"Practices for reliably and efficiently deploying and maintaining machine learning models in production.","link":"https://en.wikipedia.org/wiki/MLOps"},{"name":"Generative Artificial Intelligence","moduleDescription":"AI systems capable of generating text, images, or other media in response to prompts, often using large-scale generative models.","link":"https://en.wikipedia.org/wiki/Generative_artificial_intelligence"}]}]}', 0, 1, '2026-02-13 07:40:25.219');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (10, 'AIML Engineer', '{"name":"AIML Engineer","children":[{"name":"Level 1: Mathematical Foundations and Programming","children":[{"name":"Linear Algebra for AI","moduleDescription":"Study of vectors, matrices, and linear transformations which are the building blocks of data representation in machine learning.","link":"https://en.wikipedia.org/wiki/Linear_algebra"},{"name":"Calculus and Optimization","moduleDescription":"Learning about derivatives and integrals to understand how algorithms like gradient descent optimize model parameters.","link":"https://en.wikipedia.org/wiki/Calculus"},{"name":"Probability and Statistics","moduleDescription":"Foundational concepts for dealing with uncertainty, data distributions, hypothesis testing, and Bayesian inference.","link":"https://en.wikipedia.org/wiki/Statistics"},{"name":"Python Programming for Data Science","moduleDescription":"Mastering Python syntax and essential libraries such as NumPy, Pandas, and Matplotlib for data manipulation.","link":"https://en.wikipedia.org/wiki/Python_(programming_language)"}]},{"name":"Level 2: Classical Machine Learning","children":[{"name":"Supervised Learning Algorithms","moduleDescription":"Implementing regression and classification models including Linear Regression, SVMs, and k-Nearest Neighbors.","link":"https://en.wikipedia.org/wiki/Supervised_learning"},{"name":"Unsupervised Learning","moduleDescription":"Exploring pattern recognition through clustering techniques like K-Means and dimensionality reduction like PCA.","link":"https://en.wikipedia.org/wiki/Unsupervised_learning"},{"name":"Model Evaluation and Selection","moduleDescription":"Techniques for measuring performance using metrics like Precision, Recall, F1-Score, and Cross-Validation.","link":"https://en.wikipedia.org/wiki/Evaluation_of_machine_learning_models"},{"name":"Ensemble Methods","moduleDescription":"Combining multiple models to improve accuracy using techniques like Bagging, Boosting, and Random Forests.","link":"https://en.wikipedia.org/wiki/Ensemble_learning"}]},{"name":"Level 3: Deep Learning and Neural Networks","children":[{"name":"Artificial Neural Networks (ANN)","moduleDescription":"Understanding the architecture of neurons, layers, activation functions, and the backpropagation algorithm.","link":"https://en.wikipedia.org/wiki/Artificial_neural_network"},{"name":"Convolutional Neural Networks (CNN)","moduleDescription":"Specialized neural networks designed for processing grid-like data such as images and video.","link":"https://en.wikipedia.org/wiki/Convolutional_neural_network"},{"name":"Recurrent Neural Networks (RNN)","moduleDescription":"Architectures suited for sequential data like time series or natural language using LSTM and GRU cells.","link":"https://en.wikipedia.org/wiki/Recurrent_neural_network"},{"name":"Optimization and Regularization","moduleDescription":"Techniques to prevent overfitting and speed up training, including Dropout, Batch Normalization, and Adam Optimizer.","link":"https://en.wikipedia.org/wiki/Regularization_(mathematics)"}]},{"name":"Level 4: Advanced AI and Specialized Domains","children":[{"name":"Natural Language Processing (NLP)","moduleDescription":"Processing and generating human language using Word Embeddings, Transformers, and Large Language Models.","link":"https://en.wikipedia.org/wiki/Natural_language_processing"},{"name":"Computer Vision","moduleDescription":"Advanced techniques for image segmentation, object detection (YOLO), and facial recognition.","link":"https://en.wikipedia.org/wiki/Computer_vision"},{"name":"Reinforcement Learning","moduleDescription":"Training agents to make a sequence of decisions through rewards and penalties using Q-Learning and Policy Gradients.","link":"https://en.wikipedia.org/wiki/Reinforcement_learning"},{"name":"Generative AI and GANs","moduleDescription":"Exploring models that create new content, including Generative Adversarial Networks and Variational Autoencoders.","link":"https://en.wikipedia.org/wiki/Generative_artificial_intelligence"}]},{"name":"Level 5: MLOps and Production Engineering","children":[{"name":"Machine Learning Pipelines","moduleDescription":"Automating the workflow from data ingestion to model training using tools like Airflow or Kubeflow.","link":"https://en.wikipedia.org/wiki/Pipeline_(computing)"},{"name":"Model Deployment and Serving","moduleDescription":"Turning models into APIs and deploying them using Docker, Kubernetes, or cloud services like AWS SageMaker.","link":"https://en.wikipedia.org/wiki/Software_deployment"},{"name":"Monitoring and Data Drift","moduleDescription":"Strategies for tracking model performance in production and handling changes in data distribution over time.","link":"https://en.wikipedia.org/wiki/MLOps"},{"name":"Ethics and Explainable AI (XAI)","moduleDescription":"Ensuring fairness, transparency, and interpretability in AI systems to avoid bias and meet regulatory standards.","link":"https://en.wikipedia.org/wiki/Explainable_artificial_intelligence"}]}]}', 0, 1, '2026-02-15 15:55:34.334');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (11, 'AIML Engineer', '{"name":"AIML Engineer","children":[{"name":"Foundational Mathematics for AI","children":[{"name":"Linear Algebra","moduleDescription":"Understanding vectors, matrices, and tensors which form the core data structures in AI.","link":"https://en.wikipedia.org/wiki/Linear_algebra"},{"name":"Calculus","moduleDescription":"Learning derivatives and gradients necessary for optimization algorithms like gradient descent.","link":"https://en.wikipedia.org/wiki/Calculus"},{"name":"Probability Theory","moduleDescription":"Studying random variables and distributions to handle uncertainty in data.","link":"https://en.wikipedia.org/wiki/Probability_theory"},{"name":"Statistics","moduleDescription":"Applied statistics for data analysis, hypothesis testing, and inference.","link":"https://en.wikipedia.org/wiki/Statistics"}]},{"name":"Programming and Data Engineering","children":[{"name":"Python Programming","moduleDescription":"Mastering Python, the primary language for AI/ML development and its ecosystem.","link":"https://en.wikipedia.org/wiki/Python_(programming_language)"},{"name":"Data Manipulation with NumPy and Pandas","moduleDescription":"Using libraries to clean, transform, and analyze large datasets efficiently.","link":"https://en.wikipedia.org/wiki/Pandas_(software)"},{"name":"Data Visualization","moduleDescription":"Communicating insights through graphical representations using Matplotlib and Seaborn.","link":"https://en.wikipedia.org/wiki/Data_visualization"},{"name":"SQL and Database Management","moduleDescription":"Querying and managing structured data within relational database systems.","link":"https://en.wikipedia.org/wiki/SQL"}]},{"name":"Machine Learning Mastery","children":[{"name":"Supervised Learning","moduleDescription":"Training models on labeled data including regression and classification tasks.","link":"https://en.wikipedia.org/wiki/Supervised_learning"},{"name":"Unsupervised Learning","moduleDescription":"Finding hidden patterns or groupings in unlabeled data through clustering and association.","link":"https://en.wikipedia.org/wiki/Unsupervised_learning"},{"name":"Feature Engineering","moduleDescription":"The process of selecting and transforming raw data into features that improve model performance.","link":"https://en.wikipedia.org/wiki/Feature_engineering"},{"name":"Model Evaluation and Selection","moduleDescription":"Techniques like cross-validation and metrics like F1-score to validate model efficacy.","link":"https://en.wikipedia.org/wiki/Evaluation_of_binary_classifiers"}]},{"name":"Deep Learning Architectures","children":[{"name":"Artificial Neural Networks (ANN)","moduleDescription":"Building the foundational multi-layer perceptrons inspired by biological neurons.","link":"https://en.wikipedia.org/wiki/Artificial_neural_network"},{"name":"Convolutional Neural Networks (CNN)","moduleDescription":"Specialized networks for processing structured arrays of data like images.","link":"https://en.wikipedia.org/wiki/Convolutional_neural_network"},{"name":"Recurrent Neural Networks (RNN)","moduleDescription":"Networks designed for sequential data like time-series or speech.","link":"https://en.wikipedia.org/wiki/Recurrent_neural_network"},{"name":"Generative Adversarial Networks (GAN)","moduleDescription":"Advanced frameworks where two networks compete to create realistic synthetic data.","link":"https://en.wikipedia.org/wiki/Generative_adversarial_network"}]},{"name":"Advanced AI Specialties","children":[{"name":"Natural Language Processing (NLP)","moduleDescription":"Enabling machines to understand and process human language text and speech.","link":"https://en.wikipedia.org/wiki/Natural_language_processing"},{"name":"Computer Vision","moduleDescription":"Training computers to interpret and understand the visual world.","link":"https://en.wikipedia.org/wiki/Computer_vision"},{"name":"Reinforcement Learning","moduleDescription":"Training agents to make a sequence of decisions by rewarding desired behaviors.","link":"https://en.wikipedia.org/wiki/Reinforcement_learning"},{"name":"Large Language Models (LLM)","moduleDescription":"Exploring transformer-based architectures like GPT for advanced reasoning and generation.","link":"https://en.wikipedia.org/wiki/Large_language_model"}]},{"name":"MLOps and Production","children":[{"name":"Model Deployment","moduleDescription":"Integrating machine learning models into existing production environments.","link":"https://en.wikipedia.org/wiki/Software_deployment"},{"name":"Cloud Computing for AI","moduleDescription":"Leveraging platforms like AWS, GCP, or Azure to scale AI workloads.","link":"https://en.wikipedia.org/wiki/Cloud_computing"},{"name":"CI/CD for Machine Learning","moduleDescription":"Automating the testing and deployment pipelines for AI models.","link":"https://en.wikipedia.org/wiki/MLOps"},{"name":"Ethics and Bias in AI","moduleDescription":"Ensuring models are fair, transparent, and free from harmful biases.","link":"https://en.wikipedia.org/wiki/Ethics_of_artificial_intelligence"}]}]}', 0, 1, '2026-02-15 15:58:45.62');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (12, 'Prompt Engineer', '{"name":"Prompt Engineer","children":[{"name":"Foundations of Large Language Models","children":[{"name":"Introduction to Natural Language Processing","moduleDescription":"Understanding the core concepts of how machines process human language and the history of linguistics in AI.","link":"https://en.wikipedia.org/wiki/Natural_language_processing"},{"name":"Architecture of Large Language Models","moduleDescription":"Exploring the transformer architecture, self-attention mechanisms, and how models like GPT are trained.","link":"https://en.wikipedia.org/wiki/Large_language_model"},{"name":"Tokenization and Context Windows","moduleDescription":"Learning how text is broken down into tokens and the limitations of model memory and context length.","link":"https://en.wikipedia.org/wiki/Lexical_analysis#Tokenization"},{"name":"Probability and Text Generation","moduleDescription":"An introduction to how models predict the next token based on statistical probability and weights.","link":"https://en.wikipedia.org/wiki/Generative_artificial_intelligence"}]},{"name":"Core Prompting Techniques","children":[{"name":"Zero-Shot and Few-Shot Prompting","moduleDescription":"Learning to provide instructions without examples versus providing a few examples to guide model output.","link":"https://en.wikipedia.org/wiki/Zero-shot_learning"},{"name":"Role and Persona Prompting","moduleDescription":"Techniques for assigning specific roles or personas to the AI to improve the relevance and tone of responses.","link":"https://en.wikipedia.org/wiki/Prompt_engineering#Role_prompting"},{"name":"Chain of Thought (CoT) Prompting","moduleDescription":"Encouraging the model to explain its reasoning process step-by-step to improve logical accuracy.","link":"https://en.wikipedia.org/wiki/Prompt_engineering#Chain-of-thought"},{"name":"Instruction Induction","moduleDescription":"Understanding how to format instructions clearly using delimiters, constraints, and specific output formats.","link":"https://en.wikipedia.org/wiki/Prompt_engineering"}]},{"name":"Advanced Engineering and System Design","children":[{"name":"Retrieval-Augmented Generation (RAG)","moduleDescription":"Integrating external data sources and vector databases to provide the model with up-to-date or private information.","link":"https://en.wikipedia.org/wiki/Retrieval-augmented_generation"},{"name":"Prompt Chaining and Orchestration","moduleDescription":"Designing complex workflows where the output of one prompt serves as the input for another to solve multi-step problems.","link":"https://en.wikipedia.org/wiki/Pipeline_(computing)"},{"name":"Hyperparameter Tuning","moduleDescription":"Adjusting technical settings like Temperature, Top-P, and Frequency Penalty to control creativity and randomness.","link":"https://en.wikipedia.org/wiki/Hyperparameter_(machine_learning)"},{"name":"Fine-Tuning vs. Prompting","moduleDescription":"Analyzing when to solve problems through prompt engineering versus when to retrain model weights on specific datasets.","link":"https://en.wikipedia.org/wiki/Fine-tuning_(deep_learning)"}]},{"name":"Security, Evaluation, and Ethics","children":[{"name":"Prompt Injection and Security","moduleDescription":"Identifying vulnerabilities where users can bypass AI safety filters and learning how to harden prompts against attacks.","link":"https://en.wikipedia.org/wiki/Prompt_injection"},{"name":"Evaluation Metrics (LLM-as-a-Judge)","moduleDescription":"Using quantitative and qualitative methods to measure the accuracy, hallucination rate, and performance of prompts.","link":"https://en.wikipedia.org/wiki/Evaluation_of_natural_language_processing_systems"},{"name":"AI Ethics and Bias Mitigation","moduleDescription":"Understanding how prompts can trigger or reduce social biases and the ethical responsibility of a Prompt Engineer.","link":"https://en.wikipedia.org/wiki/Ethics_of_artificial_intelligence"},{"name":"Human-in-the-Loop Systems","moduleDescription":"Designing interfaces and workflows that allow humans to verify and correct AI-generated content effectively.","link":"https://en.wikipedia.org/wiki/Human-in-the-loop"}]}]}', 0, 1, '2026-02-15 16:02:36.353');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (13, 'MLOps Engineer', '{"name":"MLOps Engineer","children":[{"name":"Foundations of ML and Software Engineering","children":[{"name":"Python Programming","moduleDescription":"Mastering Python as the primary language for data science and automation, focusing on libraries like NumPy and Pandas.","link":"https://en.wikipedia.org/wiki/Python_(programming_language)"},{"name":"Version Control Systems","moduleDescription":"Learning Git for tracking changes in code and collaborating within a development team.","link":"https://en.wikipedia.org/wiki/Version_control"},{"name":"Software Development Life Cycle","moduleDescription":"Understanding the process of planning, creating, testing, and deploying software applications.","link":"https://en.wikipedia.org/wiki/Systems_development_life_cycle"},{"name":"Machine Learning Fundamentals","moduleDescription":"Core concepts of supervised and unsupervised learning, algorithms, and model evaluation metrics.","link":"https://en.wikipedia.org/wiki/Machine_learning"}]},{"name":"Data Engineering and Pipeline Management","children":[{"name":"ETL Processes","moduleDescription":"Extracting, transforming, and loading data into storage systems suitable for machine learning.","link":"https://en.wikipedia.org/wiki/Extract,_transform,_load"},{"name":"Database Management","moduleDescription":"Working with SQL and NoSQL databases to store and retrieve structured and unstructured data.","link":"https://en.wikipedia.org/wiki/SQL"},{"name":"Feature Stores","moduleDescription":"Managing and serving features to models in both training and production environments efficiently.","link":"https://en.wikipedia.org/wiki/Feature_store"},{"name":"Data Versioning","moduleDescription":"Using tools like DVC to track versions of datasets alongside code to ensure reproducibility.","link":"https://en.wikipedia.org/wiki/Data_management"}]},{"name":"Model Experimentation and Automation","children":[{"name":"Experiment Tracking","moduleDescription":"Logging parameters, metrics, and artifacts during model training to compare different runs.","link":"https://en.wikipedia.org/wiki/MLflow"},{"name":"Hyperparameter Tuning","moduleDescription":"Automating the search for the best model parameters to optimize performance.","link":"https://en.wikipedia.org/wiki/Hyperparameter_optimization"},{"name":"Automated Machine Learning","moduleDescription":"Applying AutoML techniques to streamline the selection and training of machine learning models.","link":"https://en.wikipedia.org/wiki/Automated_machine_learning"},{"name":"Model Validation","moduleDescription":"Implementing rigorous testing to ensure models meet performance and fairness standards before deployment.","link":"https://en.wikipedia.org/wiki/Training,_validation,_and_test_data_sets"}]},{"name":"Deployment and Orchestration","children":[{"name":"Containerization with Docker","moduleDescription":"Packaging applications and their dependencies into containers for consistent deployment across environments.","link":"https://en.wikipedia.org/wiki/Docker_(software)"},{"name":"Kubernetes Orchestration","moduleDescription":"Managing containerized applications at scale, handling load balancing and self-healing.","link":"https://en.wikipedia.org/wiki/Kubernetes"},{"name":"CI/CD for Machine Learning","moduleDescription":"Automating the integration and delivery pipelines specifically tailored for ML model updates.","link":"https://en.wikipedia.org/wiki/CI/CD"},{"name":"Workflow Orchestration","moduleDescription":"Using tools like Apache Airflow to schedule and monitor complex data and ML workflows.","link":"https://en.wikipedia.org/wiki/Apache_Airflow"}]},{"name":"Monitoring and Maintenance","children":[{"name":"Model Serving","moduleDescription":"Deploying models as REST or gRPC APIs to be consumed by end-user applications.","link":"https://en.wikipedia.org/wiki/Machine_learning_model_deployment"},{"name":"Observability and Drift Detection","moduleDescription":"Monitoring model performance in production and detecting concept or data drift.","link":"https://en.wikipedia.org/wiki/Concept_drift"},{"name":"Infrastructure as Code","moduleDescription":"Managing cloud infrastructure using code (e.g., Terraform) to ensure repeatable environments.","link":"https://en.wikipedia.org/wiki/Infrastructure_as_code"},{"name":"A/B Testing in Production","moduleDescription":"Running controlled experiments to compare new model versions against existing ones in real-time.","link":"https://en.wikipedia.org/wiki/A/B_testing"}]}]}', 0, 1, '2026-02-17 06:52:39.12');
INSERT INTO public."Roadmap" (id, title, content, "searchCount", "userId", "createdAt") VALUES (14, 'Prompt Engineer', '{"name":"Prompt Engineer","children":[{"name":"Foundations of Artificial Intelligence","children":[{"name":"Introduction to Large Language Models","moduleDescription":"Understanding the history, development, and basic functionality of LLMs like GPT, BERT, and Claude.","link":"https://en.wikipedia.org/wiki/Large_language_model"},{"name":"Natural Language Processing Basics","moduleDescription":"Exploring the core principles of NLP that allow machines to interpret and process human language.","link":"https://en.wikipedia.org/wiki/Natural_language_processing"},{"name":"Tokenization and Encoding","moduleDescription":"Learning how text is converted into numerical data (tokens) for processing by neural networks.","link":"https://en.wikipedia.org/wiki/Lexical_analysis#Tokenization"},{"name":"The Transformer Architecture","moduleDescription":"A deep dive into the attention mechanism and the architecture that powers modern generative AI.","link":"https://en.wikipedia.org/wiki/Transformer_(deep_learning_architecture)"}]},{"name":"Core Prompting Techniques","children":[{"name":"Prompt Engineering Fundamentals","moduleDescription":"Defining what a prompt is and learning the basic structure of effective model instructions.","link":"https://en.wikipedia.org/wiki/Prompt_engineering"},{"name":"Zero-Shot and Few-Shot Learning","moduleDescription":"Mastering the art of providing context or examples within a prompt to guide model output.","link":"https://en.wikipedia.org/wiki/Few-shot_learning_(natural_language_processing)"},{"name":"Instruction Tuning and System Prompts","moduleDescription":"Learning to use system-level instructions to define the persona and constraints of an AI agent.","link":"https://en.wikipedia.org/wiki/Prompt_engineering#Instruction_tuning"},{"name":"Delimiters and Structure","moduleDescription":"Using specific characters and formatting to help the model distinguish between instructions and data.","link":"https://en.wikipedia.org/wiki/Data_segmentation"}]},{"name":"Advanced Reasoning and Logic","children":[{"name":"Chain-of-Thought (CoT) Prompting","moduleDescription":"Encouraging models to perform step-by-step reasoning to solve complex mathematical or logical problems.","link":"https://en.wikipedia.org/wiki/Chain-of-thought_prompting"},{"name":"Retrieval-Augmented Generation (RAG)","moduleDescription":"Integrating external knowledge bases and search results into prompts to provide factual accuracy.","link":"https://en.wikipedia.org/wiki/Retrieval-augmented_generation"},{"name":"Self-Consistency and Tree-of-Thought","moduleDescription":"Advanced techniques for generating multiple reasoning paths to reach the most reliable conclusion.","link":"https://en.wikipedia.org/wiki/Prompt_engineering#Tree-of-thought"},{"name":"Prompt Chaining and Workflows","moduleDescription":"Designing sequential prompts where the output of one step becomes the input for the next.","link":"https://en.wikipedia.org/wiki/Pipeline_(computing)"}]},{"name":"Safety, Ethics, and Optimization","children":[{"name":"Hallucination Mitigation","moduleDescription":"Developing strategies to reduce the generation of false or misleading information by the AI.","link":"https://en.wikipedia.org/wiki/Hallucination_(artificial_intelligence)"},{"name":"Prompt Injection and Security","moduleDescription":"Identifying and defending against malicious prompts designed to bypass safety filters.","link":"https://en.wikipedia.org/wiki/Prompt_injection"},{"name":"AI Alignment and Safety","moduleDescription":"Ensuring that the model''s outputs align with human values and safety guidelines.","link":"https://en.wikipedia.org/wiki/AI_safety"},{"name":"Iterative Evaluation and Testing","moduleDescription":"Using benchmarks and automated testing to measure and improve prompt performance over time.","link":"https://en.wikipedia.org/wiki/Software_benchmarking"}]}]}', 0, 1, '2026-02-17 06:55:41.22');


--
-- Data for Name: Skill; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public."Skill" (id, level, "userId", "createdAt", category, phase, "proofUrl", "skillName", source) VALUES (1, 'intermediate', 1, '2026-04-02 06:55:57.07', 'Programmin Language', '1', 'xxx', 'C++', NULL);


--
-- Data for Name: TrackerSession; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public."TrackerSession" (id, "userId", "assignedDomain", metrics, "createdAt") VALUES ('acdb2c44-ee10-4067-bc23-7d508a99b298', '0SeJOK', 'AIML', '{"data_sort": {"speed_sec": 19.2, "total_drags": 9, "undos_hesitations": 1}, "data_stream": {"misclicks": 0, "speed_sec": 10.95, "accuracy_pct": 100, "avg_reaction_sec": 2.19}, "neural_link": {"speed_sec": 7.53, "accuracy_pct": 100, "correct_words": 3, "total_attempts": 3}, "odd_man_out": {"misclicks": 2, "accuracy_pct": 71.43, "avg_reaction_sec": 4.18}, "rapid_choice": {"choice_pattern": {"AIML": 2, "WebDev": -2, "DataScience": -2, "Cybersecurity": -2}, "avg_decision_sec": 1.86}}', '2026-04-01 12:52:43.429');
INSERT INTO public."TrackerSession" (id, "userId", "assignedDomain", metrics, "createdAt") VALUES ('478af7f6-de83-4f71-ba7f-755aa2191c3b', '0SeJOK', 'Cybersecurity', '{"data_sort": {"speed_sec": 42.32, "total_drags": 15, "undos_hesitations": 7}, "data_stream": {"misclicks": 6, "speed_sec": 29.61, "accuracy_pct": 60, "avg_reaction_sec": 1.97}, "neural_link": {"speed_sec": 25.76, "accuracy_pct": 37.5, "correct_words": 3, "total_attempts": 8}, "odd_man_out": {"misclicks": 16, "accuracy_pct": 23.81, "avg_reaction_sec": 3.3}, "rapid_choice": {"choice_pattern": {"AIML": 2, "WebDev": -2, "DataScience": 2, "Cybersecurity": -2}, "avg_decision_sec": 2.65}}', '2026-04-01 12:57:03.566');
INSERT INTO public."TrackerSession" (id, "userId", "assignedDomain", metrics, "createdAt") VALUES ('f6fe4886-5da1-4ef0-9766-30b4efa822e4', '0SeJOK', 'WebDev', '{"data_sort": {"speed_sec": 52.12, "total_drags": 17, "undos_hesitations": 9}, "data_stream": {"misclicks": 12, "speed_sec": 36.63, "accuracy_pct": 47.83, "avg_reaction_sec": 1.59}, "neural_link": {"speed_sec": 31.06, "accuracy_pct": 30, "correct_words": 3, "total_attempts": 10}, "odd_man_out": {"misclicks": 8, "accuracy_pct": 38.46, "avg_reaction_sec": 1.32}, "rapid_choice": {"choice_pattern": {"AIML": 2, "WebDev": -2, "DataScience": 2, "Cybersecurity": -2}, "avg_decision_sec": 1.96}}', '2026-04-01 13:00:22.988');
INSERT INTO public."TrackerSession" (id, "userId", "assignedDomain", metrics, "createdAt") VALUES ('d7498704-bf76-4f1a-abc7-5b42e471998c', '0SeJOK', 'DataScience', '{"data_sort": {"speed_sec": 66.78, "total_drags": 11, "undos_hesitations": 3}, "data_stream": {"misclicks": 2, "speed_sec": 10.08, "accuracy_pct": 77.78, "avg_reaction_sec": 1.12}, "neural_link": {"speed_sec": 15.37, "accuracy_pct": 25, "correct_words": 3, "total_attempts": 12}, "odd_man_out": {"misclicks": 12, "accuracy_pct": 29.41, "avg_reaction_sec": 1.15}, "rapid_choice": {"choice_pattern": {"AIML": 2, "WebDev": -2, "DataScience": -2, "Cybersecurity": -2}, "avg_decision_sec": 1.51}}', '2026-04-01 13:03:01.68');
INSERT INTO public."TrackerSession" (id, "userId", "assignedDomain", metrics, "createdAt") VALUES ('3c71b115-8d78-4951-b60a-98fdf34d234a', '0SeJOK', 'AIML', '{"data_sort": {"speed_sec": 42.44, "total_drags": 15, "undos_hesitations": 7}, "data_stream": {"misclicks": 3, "speed_sec": 17.86, "accuracy_pct": 72.73, "avg_reaction_sec": 1.62}, "neural_link": {"speed_sec": 118.35, "accuracy_pct": 75, "correct_words": 3, "total_attempts": 4}, "odd_man_out": {"misclicks": 7, "accuracy_pct": 41.67, "avg_reaction_sec": 1.94}, "rapid_choice": {"choice_pattern": {"AIML": 0, "WebDev": 2, "DataScience": -2, "Cybersecurity": 2}, "avg_decision_sec": 3.32}}', '2026-04-02 06:49:31.099');
INSERT INTO public."TrackerSession" (id, "userId", "assignedDomain", metrics, "createdAt") VALUES ('20e9bae0-a348-4f6c-bfb8-7e9b5d8ad099', '0SeJOK', 'WebDev', '{"data_sort": {"speed_sec": 17.09, "total_drags": 8, "undos_hesitations": 0}, "data_stream": {"misclicks": 1, "speed_sec": 9.89, "accuracy_pct": 85.71, "avg_reaction_sec": 1.41}, "neural_link": {"speed_sec": 59.07, "accuracy_pct": 60, "correct_words": 3, "total_attempts": 5}, "odd_man_out": {"misclicks": 9, "accuracy_pct": 35.71, "avg_reaction_sec": 2.2}, "rapid_choice": {"choice_pattern": {"AIML": 2, "WebDev": 2, "DataScience": 2, "Cybersecurity": 0}, "avg_decision_sec": 6.67}}', '2026-04-07 13:40:49.901');
INSERT INTO public."TrackerSession" (id, "userId", "assignedDomain", metrics, "createdAt") VALUES ('a93a20ec-1248-403f-a780-e29b392bcdbd', '0SeJOK', 'AIML', '{"data_sort": {"speed_sec": 25.19, "total_drags": 8, "undos_hesitations": 0}, "data_stream": {"misclicks": 5, "speed_sec": 17.65, "accuracy_pct": 64.29, "avg_reaction_sec": 1.26}, "neural_link": {"speed_sec": 27.46, "accuracy_pct": 75, "correct_words": 3, "total_attempts": 4}, "odd_man_out": {"misclicks": 9, "accuracy_pct": 35.71, "avg_reaction_sec": 1.21}, "rapid_choice": {"choice_pattern": {"AIML": 2, "WebDev": 2, "DataScience": 2, "Cybersecurity": 0}, "avg_decision_sec": 1.35}}', '2026-04-07 14:16:11.841');
INSERT INTO public."TrackerSession" (id, "userId", "assignedDomain", metrics, "createdAt") VALUES ('8664ccb6-64ab-4700-81a6-ac39c2e3ae68', '0SeJOK', 'Cybersecurity', '{"data_sort": {"speed_sec": 33.4, "total_drags": 13, "undos_hesitations": 5}, "data_stream": {"misclicks": 0, "speed_sec": 11.01, "accuracy_pct": 100, "avg_reaction_sec": 1.83}, "neural_link": {"speed_sec": 20.48, "accuracy_pct": 100, "correct_words": 3, "total_attempts": 3}, "odd_man_out": {"misclicks": 8, "accuracy_pct": 38.46, "avg_reaction_sec": 1.25}, "rapid_choice": {"choice_pattern": {"AIML": 2, "WebDev": 2, "DataScience": 2, "Cybersecurity": 2}, "avg_decision_sec": 0.78}}', '2026-04-07 14:48:27.885');
INSERT INTO public."TrackerSession" (id, "userId", "assignedDomain", metrics, "createdAt") VALUES ('0bb9e99d-3692-43ed-930d-a428f77e1ff3', '0SeJOK', 'WebDev', '{"data_sort": {"speed_sec": 22.75, "total_drags": 10, "undos_hesitations": 2}, "data_stream": {"misclicks": 4, "speed_sec": 22.03, "accuracy_pct": 69.23, "avg_reaction_sec": 1.69}, "neural_link": {"speed_sec": 20.28, "accuracy_pct": 75, "correct_words": 3, "total_attempts": 4}, "odd_man_out": {"misclicks": 4, "accuracy_pct": 55.56, "avg_reaction_sec": 3.39}, "rapid_choice": {"choice_pattern": {"AIML": -2, "WebDev": 2, "DataScience": -2, "Cybersecurity": -2}, "avg_decision_sec": 2.36}}', '2026-04-07 14:56:38.026');
INSERT INTO public."TrackerSession" (id, "userId", "assignedDomain", metrics, "createdAt") VALUES ('babe05df-2e6f-4c1b-8e28-a7cf311dd603', '0SeJOK', 'AIML', '{"data_sort": {"speed_sec": 22.22, "total_drags": 9, "undos_hesitations": 1}, "data_stream": {"misclicks": 5, "speed_sec": 15.74, "accuracy_pct": 58.33, "avg_reaction_sec": 1.31}, "neural_link": {"speed_sec": 135.91, "accuracy_pct": 37.5, "correct_words": 3, "total_attempts": 8}, "odd_man_out": {"misclicks": 13, "accuracy_pct": 27.78, "avg_reaction_sec": 1.54}, "rapid_choice": {"choice_pattern": {"AIML": 2, "WebDev": 2, "DataScience": 2, "Cybersecurity": 2}, "avg_decision_sec": 0.56}}', '2026-04-07 15:44:15.542');


--
-- Name: Achievement_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public."Achievement_id_seq"', 1, false);


--
-- Name: BlogInteraction_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public."BlogInteraction_id_seq"', 3, true);


--
-- Name: Blog_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public."Blog_id_seq"', 1, false);


--
-- Name: Challenge_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public."Challenge_id_seq"', 1, true);


--
-- Name: ClubMember_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public."ClubMember_id_seq"', 3, true);


--
-- Name: Club_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public."Club_id_seq"', 1, true);


--
-- Name: Event_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public."Event_id_seq"', 1, true);


--
-- Name: Roadmap_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public."Roadmap_id_seq"', 18, true);


--
-- Name: Skill_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public."Skill_id_seq"', 1, true);


--
-- Name: User_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public."User_id_seq"', 1, true);


--
-- PostgreSQL database dump complete
--

\unrestrict moOYIn7JQujQu54gf9eyF5GbjQVSgNk4qQmTRb4Wg4QzNeRCPD1TCpZqahlWjTx