Insert skills

DECLARE @json nvarchar(MAX) = N'[
  {
    "key": "KS120RM619V18NJXTHV1",
    "title": "HTML5"
  },
  {
    "key": "KS1200771D9CR9LB4MWW",
    "title": "JavaScript (Programming Language)"
  },
  {
    "key": "KSDJCA4E89LB98JAZ7LZ",
    "title": "React.js (Javascript Library)"
  },
  {
    "key": "ESD3D2440C1EA13521F1",
    "title": "ASP.NET Core"
  },
  {
    "key": "KS121F45VPV8C9W3QFYH",
    "title": "Cascading Style Sheets (CSS)"
  },
  {
    "key": "KS127296VDYS7ZFWVC46",
    "title": "Node.js (Javascript Library)"
  },
  {
    "key": "KS125LS6N7WP4S6SFTCK",
    "title": "Python (Programming Language)"
  },
  {
    "key": "KS120076FGP5WGWYMP0F",
    "title": "Java (Programming Language)"
  },
  {
    "key": "KS440W865GC4VRBW6LJP",
    "title": "SQL (Programming Language)"
  },
  {
    "key": "KS441LF7187KS0CV4B6Y",
    "title": "TypeScript"
  },
  {
    "key": "KS1219N6Z3XQ19V0HSKR",
    "title": "C# (Programming Language)"
  },
  {
    "key": "KS120H6772VQ0MQ5RLVD",
    "title": "Angular (Web Framework)"
  },
  {
    "key": "KSGDZ4VMK1WCGQCE1KUT",
    "title": "Vue.js (Javascript Library)"
  },
  {
    "key": "KS1232D6PH6SBVWWPQWC",
    "title": "Django (Web Framework)"
  },
  {
    "key": "ESD07FEE22E7EC094EB8",
    "title": "Ruby (Programming Language)"
  },
  {
    "key": "KS1200C5XQWW78VQ5ZYL",
    "title": "PHP (Scripting Language)"
  },
  {
    "key": "KSR5V7LNG1DL3C5O790P",
    "title": "Swift (Programming Language)"
  },
  {
    "key": "KSGQ9QZ5IFB2Q2JYUENP",
    "title": "Kotlin"
  },
  {
    "key": "ESA5839C44D0970CF79F",
    "title": "Go (Programming Language)"
  },
  {
    "key": "ESF139240EAD62841F23",
    "title": "Rust (Programming Language)"
  },
  {
    "key": "ESCCBE34B2E1EC324862",
    "title": "Flutter (Software)"
  },
  {
    "key": "KSPSGF5MXB6568UIQ4BK",
    "title": "React Native"
  },
  {
    "key": "ES6D557B9D5BE598FD74",
    "title": "Spring Boot"
  },
  {
    "key": "KSOPDDN3W5WZ7TE785BL",
    "title": "GraphQL"
  },
  {
    "key": "KS61ZX00TEDMBSZ60YHX",
    "title": "Docker"
  },
  {
    "key": "KSJF3PBD3995K6E0OF1Z",
    "title": "Kubernetes"
  },
  {
    "key": "KS120FG6YP8PQYYNQY9B",
    "title": "AWS"
  },
  {
    "key": "ESB856D0E5C4EFC8D884",
    "title": "Azure Blob Storage"
  },
  {
    "key": "ESC7869CF7378283E0AA",
    "title": "Google Cloud Platform (GCP)"
  },
  {
    "key": "KS1261Z68KSKR1X31KS3",
    "title": "Machine Learning"
  },
  {
    "key": "ESBAAA6244437165D77B",
    "title": "Artificial Intelligence Development"
  },
  {
    "key": "KS7LO8P3MXB93R3C9RWL",
    "title": "Data Science"
  },
  {
    "key": "ESFDECCC61A3DE32E933",
    "title": "DevOps Engineering"
  },
  {
    "key": "KS122MK65TBR6RDBZL1P",
    "title": "Cybersecurity"
  },
  {
    "key": "KS2DSDNSP4UY5VRHV2CM",
    "title": "Blockchain"
  },
  {
    "key": "KSCK7UOCSNOZGW1Y1TSS",
    "title": "IoT"
  },
  {
    "key": "ESFEFEFDBA0B3BC39881",
    "title": "SASS"
  },
  {
    "key": "ES5A281A8917181656AD",
    "title": "Leaner Style Sheets (LESS)"
  },
  {
    "key": "KS1214R5XG4X4PY7LGY6",
    "title": "Bootstrap (Front-End Framework)"
  },
  {
    "key": "ES3FE1FDE838BAE7DEB4",
    "title": "Tailwind CSS"
  },
  {
    "key": "BGS2494A58FC350CFDED",
    "title": "Redux"
  },
  {
    "key": "ES7CA4F00390885DBAAB",
    "title": "Next.js (Javascript Library)"
  },
  {
    "key": "ES4F554703C4BC7BAB1C",
    "title": "Gatsby.js (Javascript Library)"
  },
  {
    "key": "KS123F262HK4XY6K72CQ",
    "title": "Electron"
  },
  {
    "key": "KSUDU9T83UZ7CK5THOYD",
    "title": "Terraform"
  },
  {
    "key": "KSYO45M6II0E15Y5RP67",
    "title": "Jenkins"
  },
  {
    "key": "ESA91D8112EB9ECA3570",
    "title": "Git (Version Control System)"
  },
  {
    "key": "KS126PF6PJY1N0ZX5R0P",
    "title": "MongoDB"
  },
  {
    "key": "KS125TB6YR6236RKM563",
    "title": "PostgreSQL"
  },
  {
    "key": "KS440W76J3DH5DJCNPQ7",
    "title": "SQLite"
  },
  {
    "key": "KS1H7C2ZC7LXQQ6UN22I",
    "title": "Firebase"
  },
  {
    "key": "KSICLZ93977I6WBJL2AL",
    "title": "Heroku"
  },
  {
    "key": "ESBED74B0A7B2BABC8B0",
    "title": "Netlify"
  },
  {
    "key": "KS4424P6G7QVWXC3B756",
    "title": "WordPress"
  },
  {
    "key": "KS440K266YPXFVKMWMCR",
    "title": "Shopify"
  },
  {
    "key": "ESC1478B482505BFF81F",
    "title": "Magento"
  },
  {
    "key": "KS4407N6CMTCYT0NYSVM",
    "title": "Salesforce"
  },
  {
    "key": "KS440846S8J6KMVGG8CH",
    "title": "SAP"
  },
  {
    "key": "KS9E9IJGQ0HOYSRYTQVP",
    "title": "Oracle"
  },
  {
    "key": "KSGWPO6DSN70GRY20JFT",
    "title": "Pandas (Python Package)"
  },
  {
    "key": "KS1274P66LZKSR1F2YCT",
    "title": "NumPy"
  },
  {
    "key": "KS440BZ74QCKGSWF5W3P",
    "title": "SciPy"
  },
  {
    "key": "KS2GHRCYA6TRT29F1HOO",
    "title": "TensorFlow"
  },
  {
    "key": "ESEBE7F9DAD5C5E6ADE9",
    "title": "PyTorch"
  },
  {
    "key": "KS12791657JTS84RWLVQ",
    "title": "OpenCV"
  },
  {
    "key": "ES75B9158E483AE29AAE",
    "title": "Tableau"
  },
  {
    "key": "KS13USA80NE38XJHA2TL",
    "title": "Power BI"
  },
  {
    "key": "KS1261G6FLXL70JW7G42",
    "title": "MATLAB"
  },
  {
    "key": "KS124DQ6JX0NX9DBFDM8",
    "title": "R"
  },
  {
    "key": "KS123QD6KPN9TV140LGZ",
    "title": "Excel"
  },
  {
    "key": "KSZ0RLJB71GNDLXM8DIN",
    "title": "VBA"
  },
  {
    "key": "BGS5FB1F8881279F41D5",
    "title": "Spark"
  },
  {
    "key": "KS124KS624R3L2W8RKM6",
    "title": "Hadoop"
  },
  {
    "key": "ESF44F4A6FCFF59B1133",
    "title": "Kafka"
  },
  {
    "key": "KS123CZ6V1JC5FBNXX42",
    "title": "Elasticsearch"
  },
  {
    "key": "KS128G66RG96FZNHFCXY",
    "title": "Redis"
  },
  {
    "key": "KSKQAOQWXI50O1JWMNF7",
    "title": "Cassandra"
  },
  {
    "key": "KS128BL6BPTLYCNXSGRS",
    "title": "RabbitMQ"
  },
  {
    "key": "KSV4REFUP1SYE0VHZN98",
    "title": "Kafka Streams"
  },
  {
    "key": "ES46B2FBE34B5D3E45D5",
    "title": "Flask"
  },
  {
    "key": "ES4654925D2963CB73D7",
    "title": "FastAPI"
  },
  {
    "key": "KSH1J6VQ87586YYTYWGC",
    "title": "Hugo"
  },
  {
    "key": "KS125JD6VC77X06P8K3V",
    "title": "Jekyll"
  },
  {
    "key": "ES19C0298E9F1393714A",
    "title": "WordPress Themes"
  },
  {
    "key": "ESE44723221274FB5FC9",
    "title": "WordPress Plugins"
  },
  {
    "key": "BGS84E092793CD917AD3",
    "title": "Shopify Themes"
  },
  {
    "key": "BGS48A6213BBA1D9ED2B",
    "title": "Shopify Apps"
  },
  {
    "key": "ES852186EE721E4A4C95",
    "title": "Magento Themes"
  },
  {
    "key": "KS125H76VR036DKW6DXL",
    "title": "Magento Extensions"
  },
  {
    "key": "KSIPQQ67DRZTLLPV4N2L",
    "title": "OpenCart"
  },
  {
    "key": "KS1280H77TJPN22PCNNM",
    "title": "PrestaShop"
  },
  {
    "key": "KS1235W6HWFKFTM31M45",
    "title": "Drupal"
  },
  {
    "key": "ESB67262F65D682C543A",
    "title": "Joomla"
  },
  {
    "key": "KS126NT6TBHJR1F8ZX9P",
    "title": "MODX"
  },
  {
    "key": "KS440L86B3CKC47JGSDZ",
    "title": "SilverStripe"
  },
  {
    "key": "KS441LG5YKKV68JKLCWF",
    "title": "Typo3"
  },
  {
    "key": "KSXQ4VKGR2DMY7F1N2KG",
    "title": "Bitrix"
  },
  {
    "key": "KS122BR6XX4NL3P998MM",
    "title": "Contentful"
  },
  {
    "key": "ES6B5444F4B1BC2FAF7E",
    "title": "Strapi"
  },
  {
    "key": "KS4408074ZY7LHX0FWLB",
    "title": "Sanity"
  },
  {
    "key": "KS122W06HYQVB622GZZZ",
    "title": "KeystoneJS"
  },
  {
    "key": "KS128146MTD75KNHVPJV",
    "title": "Prismic"
  },
  {
    "key": "ESC1D3A0F8B99D270F69",
    "title": "Storyblok"
  },
  {
    "key": "KS440L264S9NBT1L5GH5",
    "title": "SignalR"
  },
  {
    "key": "KSUJ8JCMIZ0PTUVKFRG3",
    "title": "C++"
  },
  {
    "key": "KS44175614LXCVMRTHP8",
    "title": "Tauri"
  },
  {
    "key": "KS440JG6WST2V8SD4K2Y",
    "title": "Microsoft SharePoint"
  },
  {
    "key": "ESEF7DE047CD02DA1397",
    "title": "Svelte"
  },
  {
    "key": "KS5GL10CTGHE17ECC7U3",
    "title": "Three.js"
  },
  {
    "key": "KS4420V6TJB5DBNK1K6D",
    "title": "WebGL"
  },
  {
    "key": "ESD38F5B5546F673E19D",
    "title": "NestJS"
  },
  {
    "key": "BGSB9A5A49020C6E0886",
    "title": "gRPC"
  },
  {
    "key": "KS122FS64JBPZR7CST0B",
    "title": "CouchDB"
  },
  {
    "key": "KS26BVAZEM0MFCVFST66",
    "title": "Ansible"
  },
  {
    "key": "KSNUYKM5DSD1620VQEID",
    "title": "Unity (C#)"
  },
  {
    "key": "KS441NT6J6WCV9YYZ7LV",
    "title": "Unreal Engine (C++)"
  },
  {
    "key": "BGS6CDD5F9889D21966E",
    "title": "Godot"
  },
  {
    "key": "ESCEB4A1294B617D3ECF",
    "title": "Selenium"
  },
  {
    "key": "ES3C319BB4A5C8824768",
    "title": "Cypress"
  },
  {
    "key": "KS125L96T4S80STJV8RP",
    "title": "Jest"
  },
  {
    "key": "KSU84TAPVFC5I20FBD7V",
    "title": "Deno"
  },
  {
    "key": "ES145CAC43BC56F9EB80",
    "title": "Vite"
  },
  {
    "key": "ES1A2175859F80D25163",
    "title": ".NET MAUI (Multi-Platform App UI)"
  },
  {
    "key": "ESA7227DA81369A6346A",
    "title": "SharePoint Framework (SPFx)"
  },
  {
    "key": "KS126HY6YLTB9R7XJC4Z",
    "title": "Microsoft Office SharePoint Server"
  },
  {
    "key": "KS67ISPJZ6PVAIGDR0AP",
    "title": "Windows SharePoint Services 3.0"
  },
  {
    "key": "ESD9C6F39952FADBE0EB",
    "title": "Azure Functions"
  },
  {
    "key": "KS1200B62W5ZF38RJ7TD",
    "title": ".NET Framework"
  },
  {
    "key": "ES88B57ED66145A4A23A",
    "title": "Sassy Cascading Style Sheets (SCSS)"
  },
  {
    "key": "KSQOOX1S2DYD0E1VVZ5X",
    "title": "React Redux"
  },
  {
    "key": "ES6982476D9ED5E7AEEF",
    "title": "Blazor"
  },
  {
    "key": "KS1204L6HNLVRQVG3JHR",
    "title": "Spring Security"
  },
  {
    "key": "BGS6837680F34EC86853",
    "title": "Entity Framework (EF) Core"
  },
  {
    "key": "KSN97GEUHPNGNAQFDCGY",
    "title": "Apache Kafka"
  },
  {
    "key": "KS1264H6GVR1FW7B62YZ",
    "title": "Manual Testing"
  },
  {
    "key": "KS1245B69S835T6C8KB4",
    "title": "Functional Testing"
  },
  {
    "key": "KS7G7RG6HZ6DJGX617R2",
    "title": "Performance Testing"
  },
  {
    "key": "KS1203K6FQ749NJNRBBX",
    "title": "Acceptance Testing"
  },
  {
    "key": "KS128HD6KJSZMPK72WSF",
    "title": "Regression Testing"
  },
  {
    "key": "ESF1F410BAA4D2BC75A8",
    "title": "API Testing"
  },
  {
    "key": "KS1219X6NTQGYNV145GG",
    "title": "C# Fundamentals"
  },
  {
    "key": "ESD4982D421A230195E2",
    "title": "Kendo UI (User Interface Framework)"
  },
  {
    "key": "ES5269FD2583B0B9875C",
    "title": "Figma (Design Software)"
  },
  {
    "key": "ES26F70DE1799788D6F9",
    "title": "Canva (Software)"
  },
  {
    "key": "ES93374D273ED49FAFEA",
    "title": "Google Sheets"
  },
  {
    "key": "KS1206Y6W7F5JS3VBTFL",
    "title": "Adobe Photoshop"
  },
  {
    "key": "ESAC4A094237C52BB369",
    "title": "Azure Synapse Analytics"
  },
  {
    "key": "KS1277S6782C7WBYM1Y5",
    "title": "OLAP Cube"
  },
  {
    "key": "KS440W86BCX0F0Y96HVJ",
    "title": "SQL Server Reporting Services"
  },
  {
    "key": "ES3ED27455FB8FE5653B",
    "title": "Azure Service Fabric"
  },
  {
    "key": "KS1206V6K46N1SDVJGBD",
    "title": "Adobe Illustrator"
  },
  {
    "key": "KS1206V5WFXYXG27QYFD",
    "title": "Adobe After Effects"
  }
]';

;WITH j AS (
    SELECT
        LTRIM(RTRIM([KEY]))   AS [KEY],
        LTRIM(RTRIM([title])) AS [title]
    FROM OPENJSON(@json)
    WITH ([KEY] nvarchar(100) '$.key', [title] nvarchar(400) '$.title')
)
INSERT INTO dbo.Skills ([KEY],[Title])
SELECT j.[KEY], j.[title]
FROM j
WHERE NOT EXISTS (
    SELECT 1 FROM dbo.Skills s WHERE s.[KEY] = j.[KEY]
);