Related resources for query language
  • Connecting Grafana to Data Sources5/6/2024 5:19:15 AM. Connect Grafana to databases, APIs, and more for powerful data visualization. Link MySQL, PostgreSQL, or InfluxDB seamlessly and extend with plugins for MongoDB, Kafka, REST APIs, and cloud platforms
  • Why GraphQL Is An Alternative Over React API3/21/2024 6:26:24 AM. GraphQL offers a more flexible and efficient approach compared to traditional REST APIs, especially when integrated with React. With GraphQL, frontend developers can request only the data they need, r
  • Analysis of T-SQL and PL/SQL2/12/2024 4:03:24 AM. This article delves into the distinctions between Transact-SQL (T-SQL) and PL/SQL, examining their origins, syntax, functionality, and optimization strategies. Explore their unique features for effici
  • Supported File Types for Data Ingestion into KQL Database in Fabric2/6/2024 10:04:20 AM. This article is about Understanding the Supported File Types for Data Ingestion into the KQL Database in Fabric Real-time Analytics. Supported file types include JSON, CSV, XML, & Text. Note: XLSX
  • Mastering T-SQL Rank Functions2/6/2024 9:28:41 AM. SQL window functions like ROW_NUMBER, RANK, DENSE_RANK, and NTILE are vital for advanced data analysis. They organize, order, and rank data within result sets. ROW_NUMBER assigns unique sequential nu
  • Exploring Kusto Query Language (KQL): Uses, Queries, and Unique Features12/1/2023 5:09:29 AM. Kusto Query Language (KQL) is a potent tool developed by Microsoft for diverse data analytics needs. Uncover its applications across industries, from log analytics to IoT, and explore essential querie
  • Fetch Data from Azure Data Explorer of the Kusto Microsoft Fabric Database in Excel11/7/2023 5:19:43 AM. In this video, I demo how to fetch data from azure data explorer of the kusto Microsoft Fabric database in Excel.
  • What Is A Network Database?8/10/2023 7:00:36 AM. Network databases represent data in a tree-like structure. In this article, we'll learn basics of hierarchical database management systems and how data is represented and stored in a hierarchical
  • Object Relational Mapping (ORM) Using NHibernate - Part 5 - A of 88/4/2023 11:39:30 AM. This is Part 5A of the article series, which concentrates on Many-to-Many Entity Association with a commonly used example but the model and code is a little different.
  • Structured Query Language: Part 12/21/2023 5:54:37 AM. This article is an introduction to the Structured Query Language (SQL) and its most common commands.
  • What Is GraphQL12/30/2022 6:27:00 AM. This would be a series of articles, in this article, we would talk about GraphQL, its comparison with REST and how does it work, why it is used and its operation types
  • GraphQL | A Query Language For Your API | Rest API2/19/2021 4:21:20 PM. GraphQL is a query language(“QL” stands for) that described how exactly a client should be requested for an information thorough application programming interface called API. It is a syntax that devel
  • Real Life SQL And .NET - Part One12/6/2020 10:41:53 PM. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be req
  • Azure Data Explorer - Reading JSON Data Using Kusto11/28/2020 11:59:50 AM. This article demonstrates various ways of extracting data using Kusto.
  • Azure Data Explorer - Kusto Query - Transform Rows To Columns11/24/2020 10:45:32 PM. This article explains how to transform a set of rows to a set of columns based on given criteria.
  • Azure Data Explorer - Perform Calculation On Multiple Values From Single Kusto Input11/19/2020 2:44:41 AM. This article will explain how to perform multiple calculations, i.e. on single set of data.
  • Azure Data Explorer - Working With Kusto Case Sensitivity11/10/2020 9:04:40 PM. This article explains about various approaches to handle casing scenarios for kusto query.
  • Real Life SQL and .NET: Part V10/30/2020 4:33:05 AM. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be req
  • Real Life SQL and .NET : using SQL with C#: Part XI10/28/2020 1:12:45 AM. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be req
  • Azure Data Explorer - Kusto Query - Get Data For Last 20 Days10/22/2020 7:03:32 AM. This article explains on how to fetch logs for past number of days using Kusto from Azure Data Explorer
  • Azure Data Explorer - Kusto Query - Get Min/Max Within Each Category Filter10/22/2020 7:02:52 AM. This article will guide you on how to get maximum and the minimum values for each unique combination of given columns
  • Azure Data Explorer - Kusto Query - Get Categorial Count10/22/2020 7:01:35 AM. This article will talk about how to get the count based on defined criteria.
  • SQL For Beginners8/9/2019 11:42:01 AM. In this video series, we will learn dive deep into the concept of Structured Query Language (SQL) from the very basics. This article is ideal for beginners who want to learn SQL from scratch.
  • Real Life SQL and .NET :Using SQL with C#: Part VIII10/27/2006 1:15:53 AM. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part II2/8/2006 5:55:26 AM. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part IV2/8/2006 5:45:43 AM. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.