156 lines
9.4 KiB
SQL
156 lines
9.4 KiB
SQL
-- Seed skills catalog (for profile update skill selection)
|
|
-- Table is defined in database/schema/skills.pg.hcl - run make migrate-diff then migrate-apply first
|
|
-- Run: psql postgres://alinmeuser:password@localhost:5430/alinmedb -f database/scripts/seed_skills.sql
|
|
INSERT INTO "public"."skills" ("id", "name") VALUES
|
|
('0199d2ba-8be8-70fd-a496-d1600ff12333', 'Python'),
|
|
('0199d2ba-8be8-7101-81bc-f98d3576ba6e', 'R'),
|
|
('0199d2ba-8be8-7105-9684-a23a41178cb5', 'SQL'),
|
|
('0199d2ba-8be8-7109-a761-b9e15f2fb2ab', 'Scala'),
|
|
('0199d2ba-8be8-710d-b63c-e02c316e5dc3', 'Java'),
|
|
('0199d2ba-8be8-7111-a1fc-4ab0627faac5', 'C++'),
|
|
('0199d2ba-8be8-7115-8ee9-8f90305c389e', 'JavaScript'),
|
|
('0199d2ba-8be8-7116-9d42-925ac82d4ad0', 'TypeScript'),
|
|
('0199d2ba-8be8-7119-93f9-82cde5c8898c', 'Go'),
|
|
('0199d2ba-8be8-711d-b49a-60aa06a53764', 'Rust'),
|
|
('0199d2ba-8be8-7121-af5a-602e7c2ecfc3', 'Pandas'),
|
|
('0199d2ba-8be8-7122-8494-15ffb02b1e20', 'NumPy'),
|
|
('0199d2ba-8be8-7124-9f4a-cc45600720ba', 'Matplotlib'),
|
|
('0199d2ba-8be8-7125-9dbe-71785e32e4ba', 'Seaborn'),
|
|
('0199d2ba-8be8-7128-b430-b843a3ce2e4a', 'Plotly'),
|
|
('0199d2ba-8be8-7129-936d-5e2b6b199f19', 'Scikit-learn'),
|
|
('0199d2ba-8be8-712c-a718-014380b8e1d5', 'TensorFlow'),
|
|
('0199d2ba-8be8-7134-b32a-e03eab84b57f', 'Keras'),
|
|
('0199d2ba-8be8-7135-8641-ca42614fdd4c', 'PyTorch'),
|
|
('0199d2ba-8be8-7138-9974-120cc312d915', 'JAX'),
|
|
('0199d2ba-8be8-713c-b278-55750c9033d8', 'Hugging Face Transformers'),
|
|
('0199d2ba-8be8-713d-be12-e97011d461d8', 'LangChain'),
|
|
('0199d2ba-8be8-713e-94bd-1b472084ebd8', 'LlamaIndex'),
|
|
('0199d2ba-8be8-7140-a6b0-31e55fbdde00', 'OpenAI API'),
|
|
('0199d2ba-8be8-7144-b730-f836d14cac63', 'Claude API'),
|
|
('0199d2ba-8be8-7145-85f6-cbcdd0cfd4aa', 'Gemini API'),
|
|
('0199d2ba-8be8-7146-86dd-81f95b76d7b6', 'Vector Databases'),
|
|
('0199d2ba-8be8-7148-99ef-9628166a6a32', 'Pinecone'),
|
|
('0199d2ba-8be8-7149-96ba-192d5447f8ba', 'Weaviate'),
|
|
('0199d2ba-8be8-714c-bb23-0b0417143e9b', 'FAISS'),
|
|
('0199d2ba-8be8-714d-9612-2a1ef25cf4d6', 'ChromaDB'),
|
|
('0199d2ba-8be8-714e-b77a-e8b1cbac2db8', 'RAG (Retrieval-Augmented Generation)'),
|
|
('0199d2ba-8be8-714f-bbee-45b07e4c8dc8', 'LLMOps'),
|
|
('0199d2ba-8be8-7150-924c-6d8e7fb9bafa', 'MLflow'),
|
|
('0199d2ba-8be8-7153-a992-3a3639dc86fc', 'Weights & Biases (W&B)'),
|
|
('0199d2ba-8be8-7154-97e5-569b82e04a0f', 'DVC (Data Version Control)'),
|
|
('0199d2ba-8be8-7157-84a0-7e4abdf735ad', 'Docker'),
|
|
('0199d2ba-8be8-715b-a0d5-f0856f6ebdb4', 'Kubernetes'),
|
|
('0199d2ba-8be8-715c-9211-3d02d44f97cb', 'Apache Airflow'),
|
|
('0199d2ba-8be8-715f-8c96-9c698ae1db57', 'Prefect'),
|
|
('0199d2ba-8be8-7160-9aa4-ad1de612547e', 'Apache Spark'),
|
|
('0199d2ba-8be8-7161-b7ed-709bbd7dc190', 'Hadoop'),
|
|
('0199d2ba-8be8-7163-bebb-d6c51b1c9f64', 'Kafka'),
|
|
('0199d2ba-8be8-7164-b8b9-ceb730020e51', 'Data Pipeline Development'),
|
|
('0199d2ba-8be8-7167-9266-1c78ba9bc10d', 'ETL (Extract, Transform, Load)'),
|
|
('0199d2ba-8be8-7168-88ad-3d571e694161', 'Data Warehousing'),
|
|
('0199d2ba-8be8-7169-aa76-d6be8b6e084b', 'Data Modeling'),
|
|
('0199d2ba-8be8-716b-a70d-7466619ef39a', 'Data Architecture'),
|
|
('0199d2ba-8be8-716c-9c79-3733e2c2ec30', 'AWS Cloud'),
|
|
('0199d2ba-8be8-716f-b5b0-4162a7d0bf57', 'Azure Cloud'),
|
|
('0199d2ba-8be8-7170-b862-1b46d780941a', 'Google Cloud Platform (GCP)'),
|
|
('0199d2ba-8be8-7171-a5d6-823cc6c46e41', 'Cloud AI/ML Services'),
|
|
('0199d2ba-8be8-7173-ae15-5f4a3398b4cf', 'Data Visualization'),
|
|
('0199d2ba-8be8-7174-8304-f02588d5b29b', 'Tableau'),
|
|
('0199d2ba-8be8-7177-9411-1e9ee41180f5', 'Power BI'),
|
|
('0199d2ba-8be8-7178-9616-3ba751d92df9', 'Looker'),
|
|
('0199d2ba-8be8-717a-9e72-c687388bbeab', 'Excel for Data Analysis'),
|
|
('0199d2ba-8be8-717b-838b-043204d8f0c8', 'Statistics'),
|
|
('0199d2ba-8be8-717c-9a68-1c6149cba552', 'Probability'),
|
|
('0199d2ba-8be8-717e-b520-6bacb9ea8187', 'Linear Algebra'),
|
|
('0199d2ba-8be8-717f-ad87-873a66a695af', 'Calculus'),
|
|
('0199d2ba-8be8-7182-9890-f78acd585f27', 'Machine Learning'),
|
|
('0199d2ba-8be8-7183-896d-8838cb0f453d', 'Deep Learning'),
|
|
('0199d2ba-8be8-7184-b9d9-483478a62324', 'Reinforcement Learning'),
|
|
('0199d2ba-8be8-7186-add1-804f8b8cc7ba', 'Natural Language Processing (NLP)'),
|
|
('0199d2ba-8be8-7187-9574-f8bdf5b19dee', 'Computer Vision'),
|
|
('0199d2ba-8be8-718a-a97c-c9b08723e49d', 'Speech Recognition'),
|
|
('0199d2ba-8be8-718b-aab8-54035f6d4f34', 'Generative AI'),
|
|
('0199d2ba-8be8-718c-aa7f-00a847f047c8', 'Prompt Engineering'),
|
|
('0199d2ba-8be8-718e-9ab5-d45b6ef3e8bd', 'Model Fine-Tuning'),
|
|
('0199d2ba-8be8-718f-885e-6c1f3a0475a0', 'Data Cleaning'),
|
|
('0199d2ba-8be8-7192-ac44-fefd5a412f38', 'Feature Engineering'),
|
|
('0199d2ba-8be8-7196-9dc8-981b95bb6cf4', 'Model Training & Evaluation'),
|
|
('0199d2ba-8be8-7197-9da9-5fc46e582585', 'Model Deployment'),
|
|
('0199d2ba-8be8-719a-8aa7-acec647d1e6e', 'Model Monitoring'),
|
|
('0199d2ba-8be8-719b-a98b-2d64c7b03e7e', 'API Development'),
|
|
('0199d2ba-8be8-719e-870d-ada6e96b4364', 'Backend Development'),
|
|
('0199d2ba-8be8-719f-ac90-52aeb64617dc', 'Frontend Development'),
|
|
('0199d2ba-8be8-71a0-8f02-2a9008707dc1', 'Version Control (Git/GitHub)'),
|
|
('0199d2ba-8be8-71a1-96ac-b0070ec183d0', 'CI/CD Pipelines'),
|
|
('0199d2ba-8be8-71a2-bde3-3145230d461b', 'Software Engineering'),
|
|
('0199d2ba-8be8-71a5-a946-9065c969cb08', 'Microservices Architecture'),
|
|
('0199d2ba-8be8-71a6-af92-63b8c37e0fcd', 'Data Governance'),
|
|
('0199d2ba-8be8-71a7-a0ad-dada184b2d54', 'Data Privacy'),
|
|
('0199d2ba-8be8-71a9-aa08-0a4032d081a6', 'AI Ethics'),
|
|
('0199d2ba-8be8-71aa-be8e-6e516d17c667', 'AI Safety'),
|
|
('0199d2ba-8be8-71ad-9d78-765705dbc9eb', 'AI Governance'),
|
|
('0199d2ba-8be8-71ae-9a18-5b0d428ce609', 'Product Management'),
|
|
('0199d2ba-8be8-71af-ac84-0da3ed93129a', 'Project Management'),
|
|
('0199d2ba-8be8-71b1-993e-fca092ad393b', 'Agile / Scrum'),
|
|
('0199d2ba-8be8-71b2-b22d-7d704f78ddf6', 'Business Analysis'),
|
|
('0199d2ba-8be8-71b3-88cf-38b5af680eb9', 'Data Storytelling'),
|
|
('0199d2ba-8be8-71b5-81ce-e6b0b77e8602', 'Communication Skills'),
|
|
('0199d2ba-8be8-71b6-84f0-82b804071d56', 'Leadership'),
|
|
('0199d2ba-8be8-71b9-82a4-128ab42e19dd', 'Technical Writing'),
|
|
('0199d2ba-8be8-71ba-9830-ec53b4e67047', 'Content Creation'),
|
|
('0199d2ba-8be8-71bd-aed9-20178cc764d5', 'Public Speaking'),
|
|
('0199d2ba-8be8-71be-86c3-9fc39a68bd9b', 'Teaching & Mentorship'),
|
|
('0199d2ba-8be8-71bf-a724-4c6165e016a7', 'Open Source Contribution'),
|
|
('0199d2ba-8be8-71c1-b3f5-a21ac46b64ba', 'Research & Experimentation'),
|
|
('0199d2ba-8be8-71c2-a253-e96d7605252b', 'Academic Writing'),
|
|
('0199d2ba-8be8-71c3-ac3a-1b4985532fa1', 'Kaggle Competitions'),
|
|
('0199d2ba-8be8-71c5-be1b-9f55e24089fe', 'Entrepreneurship'),
|
|
('0199d2ba-8be8-71c6-beb0-e6c6c89d12fd', 'Startup Development'),
|
|
('0199d2ba-8be8-71c9-841a-65db45d08cff', 'Freelancing'),
|
|
('0199d2ba-8be8-71ca-8dbc-2a24e339e5ff', 'Community Building'),
|
|
('0199d2ba-8be8-71cb-a573-7919f5c2152e', 'AI Advocacy'),
|
|
('0199d2ba-8be8-71cc-b47b-b5c4cb301cc7', 'Data Security'),
|
|
('0199d2ba-8be8-71cd-a5a2-9f147e9f2271', 'API Integration'),
|
|
('0199d2ba-8be8-71d0-a8e4-fdcd1e9f6c02', 'Time Series Analysis'),
|
|
('0199d2ba-8be8-71d1-bea0-1f30a9467498', 'Experiment Tracking'),
|
|
('0199d2ba-8be8-71d2-b7aa-d1478882499c', 'Hyperparameter Tuning'),
|
|
('0199d2ba-8be8-71d4-8b05-b2e8266d3534', 'Model Optimization'),
|
|
('0199d2ba-8be8-71d5-9a9a-57c11bf499d4', 'Feature Selection'),
|
|
('0199d2ba-8be8-71d8-a72b-d633a1a6bada', 'Big Data Technologies'),
|
|
('0199d2ba-8be8-71d9-9b3c-f802602f2dd1', 'Distributed Computing'),
|
|
('0199d2ba-8be8-71da-be24-3aae458443d4', 'Cloud Computing'),
|
|
('0199d2ba-8be8-71dc-969b-db1e83e26873', 'NoSQL Databases'),
|
|
('0199d2ba-8be8-71dd-a6d4-282f52d79022', 'Graph Databases'),
|
|
('0199d2ba-8be8-71e0-a0e7-910b07fa8aaf', 'Data Lakes'),
|
|
('0199d2ba-8be8-71e1-8fb2-5db55b828b52', 'Automation'),
|
|
('0199d2ba-8be8-71e2-8628-5205aedb39c1', 'MLOps'),
|
|
('0199d2ba-8be8-71e4-a2b3-742d5fcec94a', 'DataOps'),
|
|
('0199d2ba-8be8-71e5-939a-055758f99616', 'AIOps'),
|
|
('0199d2ba-8be8-71e8-85eb-b7f0a8ff6bd3', 'Edge AI'),
|
|
('0199d2ba-8be8-71e9-9fee-2442574ac577', 'TinyML'),
|
|
('0199d2ba-8be8-71ec-a4cb-5e836d311be1', 'AutoML'),
|
|
('0199d2ba-8be8-71ed-adc3-53f58cc3b684', 'Explainable AI (XAI)'),
|
|
('0199d2ba-8be8-71ee-b476-fea7f9820fd4', 'Responsible AI'),
|
|
('0199d2ba-8be8-71f0-927b-cca53d78c140', 'AI Policy'),
|
|
('0199d2ba-8be8-71f1-b730-38d4effd4e5a', 'AI Regulation Compliance'),
|
|
('0199d2ba-8be8-71f4-8030-3174413315e6', 'AI Product Design'),
|
|
('0199d2ba-8be8-71f5-a473-3febc586b8d7', 'Human-Centered AI'),
|
|
('0199d2ba-8be8-71f6-ab07-34e9403f0d23', 'User Experience (UX)'),
|
|
('0199d2ba-8be8-71f7-ae8c-652f27106c74', 'Prototyping'),
|
|
('0199d2ba-8be8-71f8-b10a-14d1db35e819', 'Streamlit'),
|
|
('0199d2ba-8be8-71f9-aefe-fdba6ed47f11', 'Gradio'),
|
|
('0199d2ba-8be8-71fb-94a6-f01c963c55ef', 'FastAPI'),
|
|
('0199d2ba-8be8-71fc-b404-f201d4df49cd', 'Flask'),
|
|
('0199d2ba-8be8-71ff-bf1e-19a7a8151908', 'Dash'),
|
|
('0199d2ba-8be8-7200-b99d-232845111a56', 'Plotly Dashboards'),
|
|
('0199d2ba-8be8-7201-ba41-d85fd5a8bd57', 'Business Intelligence'),
|
|
('0199d2ba-8be8-7203-a3c1-69587b57a4c3', 'Kubernetes Helm'),
|
|
('0199d2ba-8be8-7204-be49-bf2ecbbf13ae', 'Terraform'),
|
|
('0199d2ba-8be8-7207-ac8f-3782663f1929', 'Serverless Functions'),
|
|
('0199d2ba-8be8-7208-935c-74fcba2ce66c', 'REST APIs'),
|
|
('0199d2ba-8be8-7209-b5a4-040fcb157631', 'GraphQL'),
|
|
('0199d2ba-8be8-720b-b2b8-a62282a620c8', 'Testing & QA'),
|
|
('0199d2ba-8be8-720c-98b1-be0802ddcfce', 'System Design'),
|
|
('0199d2ba-8be8-720d-be28-17dfb7d1f22d', 'Scalability Engineering')
|
|
ON CONFLICT (id) DO NOTHING;
|