{"tag":{"id":"56744723958ef13879b953ed","name":"SQL","logo":"https://res.cloudinary.com/hashnode/image/upload/v1501338352/cv7owxtxvr39rjzxoolr.png","slug":"sql","tagline":"SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.","__typename":"Tag"},"publication":{"__typename":"Publication","id":"6426e8edaf5048c992b6d316","url":"https://dhananjaykulkarni.hashnode.dev","canonicalURL":"https://dhananjaykulkarni.hashnode.dev","urlPattern":"SIMPLE","title":"Dhananjay Kulkarni","displayTitle":"Dhananjay Kulkarni - DevOps ,cloud computing and cyber security","hasBadges":true,"descriptionSEO":"","publicMembers":{"totalDocuments":1,"__typename":"PublicationMemberConnection"},"about":null,"features":{"proTeam":{"isEnabled":false,"__typename":"ProTeamFeature"},"newsletter":{"isEnabled":true,"__typename":"NewsletterFeature"},"viewCount":{"isEnabled":true,"__typename":"ViewCountFeature"},"readTime":{"isEnabled":true,"__typename":"ReadTimeFeature"},"textSelectionSharer":{"isEnabled":true,"__typename":"TextSelectionSharerFeature"},"customCSS":{"isEnabled":false,"published":null,"draft":null,"__typename":"CustomCSSFeature"},"gptBotCrawling":{"__typename":"GPTBotCrawlingFeature","isEnabled":true},"__typename":"PublicationFeatures"},"metaTags":"\n\n\n\n\n\n\n","ogMetaData":{"image":null,"__typename":"OpenGraphMetaData"},"author":{"__typename":"User","id":"6426e8b29bf2b1c9c2b0e603","name":"Dhananjay kulkarni","username":"DhananjayKulkarni","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1685615237640/Er7gTTRYh.jpg"},"preferences":{"__typename":"Preferences","logo":null,"darkMode":{"__typename":"DarkModePreferences","logo":null,"enabled":true},"navbarItems":[],"enabledPages":{"__typename":"PagesPreferences","badges":false,"newsletter":true,"members":true},"layout":"stacked","disableFooterBranding":false,"isSubscriptionModalDisabled":false},"favicon":null,"headerColor":"#2962FF","integrations":{"fbPixelID":"","fathomSiteID":"","fathomCustomDomainEnabled":null,"fathomCustomDomain":"","hotjarSiteID":"","matomoSiteID":null,"matomoURL":"","gaTrackingID":"UA-265631682-1","gTagManagerID":null,"plausibleAnalyticsEnabled":true,"wmPaymentPointer":"","koalaPublicKey":null,"msClarityID":null,"__typename":"PublicationIntegrations"},"imprintV2":null,"postsCount":{"totalDocuments":111,"__typename":"PublicationPostConnection"},"isTeam":true,"links":{"twitter":"","instagram":"","github":"https://github.com/Dhananjaykul","website":"","hashnode":"https://hashnode.com/@DhananjayKulkarni","youtube":"","dailydev":"","linkedin":"https://www.linkedin.com/in/dhananjay-kulkarni-ba54a81b0/","mastodon":"","facebook":null,"bluesky":null,"__typename":"PublicationLinks"},"domainInfo":{"__typename":"DomainInfo","hashnodeSubdomain":"dhananjaykulkarni","domain":null,"wwwPrefixedDomain":null},"redirectionRules":[],"totalRecommendedPublications":0,"sponsorship":{"content":null,"stripe":{"connected":true,"accountId":"acct_1Mwc6iSBgzrc0zYg","country":"IN","__typename":"StripeConfiguration"},"__typename":"PublicationSponsorship"},"allowContributorEdits":true,"posts":{"edges":[{"node":{"__typename":"Post","id":"6693bd0757fa119bdafe3d4c","title":"Part 4: Advanced SQL Concepts - Joins, Subqueries, and Indexes","slug":"part-4-advanced-sql-concepts-joins-subqueries-and-indexes","publishedAt":"2024-07-14T11:56:55.793Z","cuid":"clyli35v500030aij7xccfqul","url":"https://dhananjaykulkarni.hashnode.dev/part-4-advanced-sql-concepts-joins-subqueries-and-indexes","subtitle":"Master Advanced SQL: Joins, Subqueries, and Indexes Explained","brief":"Welcome to the fourth part of our SQL series. In this installment, we will explore more advanced SQL concepts, including joins, subqueries, and indexes. These concepts are essential for efficient data retrieval and manipulation, allowing you to handl...","readTimeInMinutes":9,"views":24,"author":{"__typename":"User","id":"6426e8b29bf2b1c9c2b0e603","username":"DhananjayKulkarni","name":"Dhananjay kulkarni","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1685615237640/Er7gTTRYh.jpg","followersCount":142},"coverImage":{"__typename":"PostCoverImage","url":"https://cdn.hashnode.com/res/hashnode/image/upload/v1720957534217/e24e72bc-ae39-4269-bbd7-75ab554be96f.jpeg","isPortrait":false,"isAttributionHidden":false}},"cursor":"NjY5M2JkMDc1N2ZhMTE5YmRhZmUzZDRjXzIwMjQtMDctMTRUMTE6NTY6NTUuNzkzWg==","__typename":"PostEdge"},{"node":{"__typename":"Post","id":"668f9d194ed5f8bc0cf95e8f","title":"Part 3: Advanced SQL Concepts and Commands","slug":"part-3-advanced-sql-concepts-and-commands","publishedAt":"2024-07-11T08:51:37.684Z","cuid":"clyh15b2s000o0ajm54gl8scm","url":"https://dhananjaykulkarni.hashnode.dev/part-3-advanced-sql-concepts-and-commands","subtitle":"Learn Advanced SQL Commands and Concepts","brief":"In this part of our SQL series, we will delve into more advanced concepts and commands, focusing on the HAVING clause, table-related queries, foreign keys, cascading operations, and altering table schemas. We will also go through examples and demonst...","readTimeInMinutes":6,"views":12,"author":{"__typename":"User","id":"6426e8b29bf2b1c9c2b0e603","username":"DhananjayKulkarni","name":"Dhananjay kulkarni","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1685615237640/Er7gTTRYh.jpg","followersCount":142},"coverImage":{"__typename":"PostCoverImage","url":"https://cdn.hashnode.com/res/hashnode/image/upload/v1720687641548/24b6efbe-a919-4e39-b449-f4ab17883291.jpeg","isPortrait":false,"isAttributionHidden":false}},"cursor":"NjY4ZjlkMTk0ZWQ1ZjhiYzBjZjk1ZThmXzIwMjQtMDctMTFUMDg6NTE6MzcuNjg0Wg==","__typename":"PostEdge"},{"node":{"__typename":"Post","id":"6688d5c945a7c9a61c1fcdcc","title":"SQL Tutorial Part 2: Keys, Constraints, and Advanced Queries","slug":"sql-tutorial-part-2-keys-constraints-and-advanced-queries","publishedAt":"2024-07-06T05:27:37.781Z","cuid":"cly9onpdg000609l7dvu65xtc","url":"https://dhananjaykulkarni.hashnode.dev/sql-tutorial-part-2-keys-constraints-and-advanced-queries","subtitle":"Understanding Keys, Constraints, and Advanced Queries in SQL","brief":"Welcome to the second part of our comprehensive SQL tutorial. In this section, we'll dive deeper into keys, constraints, and advanced SQL queries. We'll also include practice exercises to help solidify our understanding.\nKeys in SQL\nPrimary Keys\nA pr...","readTimeInMinutes":9,"views":13,"author":{"__typename":"User","id":"6426e8b29bf2b1c9c2b0e603","username":"DhananjayKulkarni","name":"Dhananjay kulkarni","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1685615237640/Er7gTTRYh.jpg","followersCount":142},"coverImage":{"__typename":"PostCoverImage","url":"https://cdn.hashnode.com/res/hashnode/image/upload/v1720240384191/0e7914df-d9db-4179-b8a4-06ab260ed46b.jpeg","isPortrait":false,"isAttributionHidden":false}},"cursor":"NjY4OGQ1Yzk0NWE3YzlhNjFjMWZjZGNjXzIwMjQtMDctMDZUMDU6Mjc6MzcuNzgxWg==","__typename":"PostEdge"},{"node":{"__typename":"Post","id":"6687bd08fbcdace7fe035f50","title":"SQL Tutorial Part 1: Introduction to SQL Databases and Basic Operations","slug":"sql-tutorial-part-1-introduction-to-sql-databases-and-basic-operations","publishedAt":"2024-07-05T09:29:44.415Z","cuid":"cly8hv7j300070al60zov8h7k","url":"https://dhananjaykulkarni.hashnode.dev/sql-tutorial-part-1-introduction-to-sql-databases-and-basic-operations","subtitle":"Introduction to SQL Databases: Basic Operations Explained","brief":"Welcome to the first part of this comprehensive SQL tutorial. This tutorial is for beginners who want to brush up on their SQL skills and get hands-on experience with SQL commands.\nUnderstanding SQL Databases\nA database is a structured collection of ...","readTimeInMinutes":5,"views":22,"author":{"__typename":"User","id":"6426e8b29bf2b1c9c2b0e603","username":"DhananjayKulkarni","name":"Dhananjay kulkarni","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1685615237640/Er7gTTRYh.jpg","followersCount":142},"coverImage":{"__typename":"PostCoverImage","url":"https://cdn.hashnode.com/res/hashnode/image/upload/v1720171696342/74f7b9f8-bade-4ed2-943d-4aafd96d2b10.png","isPortrait":false,"isAttributionHidden":false}},"cursor":"NjY4N2JkMDhmYmNkYWNlN2ZlMDM1ZjUwXzIwMjQtMDctMDVUMDk6Mjk6NDQuNDE1Wg==","__typename":"PostEdge"},{"node":{"__typename":"Post","id":"667f7e75f5d4c46ac1807348","title":"How to Prevent SQL Injection Vulnerabilities","slug":"how-to-prevent-sql-injection-vulnerabilities","publishedAt":"2024-06-29T03:24:37.065Z","cuid":"clxzk6jpl000008mjb0jp1g7a","url":"https://dhananjaykulkarni.hashnode.dev/how-to-prevent-sql-injection-vulnerabilities","subtitle":"Day 5: Methods to Prevent SQL Injection Issues","brief":"Now that you know what a SQL injection vulnerability is, how to find it, and how to exploit it, the next essential skill is learning how to prevent SQL injection vulnerabilities. This knowledge is crucial, especially when writing pentesting reports a...","readTimeInMinutes":3,"views":6,"author":{"__typename":"User","id":"6426e8b29bf2b1c9c2b0e603","username":"DhananjayKulkarni","name":"Dhananjay kulkarni","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1685615237640/Er7gTTRYh.jpg","followersCount":142},"coverImage":{"__typename":"PostCoverImage","url":"https://cdn.hashnode.com/res/hashnode/image/upload/v1719591412484/4c089eaf-1fd6-4c0c-95ed-6957f4985224.jpeg","isPortrait":false,"isAttributionHidden":false}},"cursor":"NjY3ZjdlNzVmNWQ0YzQ2YWMxODA3MzQ4XzIwMjQtMDYtMjlUMDM6MjQ6MzcuMDY1Wg==","__typename":"PostEdge"}],"pageInfo":{"endCursor":"NjY3ZjdlNzVmNWQ0YzQ2YWMxODA3MzQ4XzIwMjQtMDYtMjlUMDM6MjQ6MzcuMDY1Wg==","hasNextPage":false,"__typename":"PageInfo"},"__typename":"PublicationPostConnection"}}}