In this article, we will learn how to set up an Oracle instance, create sample data and understand the use of the substring function.
Read more »
Gauri Mahajan
Gauri is a SQL Server Professional and has 6+ years experience of working with global multinational consulting and technology organizations. She is very passionate about working on SQL Server topics like Azure SQL Database, SQL Server Reporting Services, R, Python, Power BI, Database engine, etc. She has years of experience in technical documentation and is fond of technology authoring.
She has a deep experience in designing data and analytics solutions and ensuring its stability, reliability, and performance. She is also certified in SQL Server and have passed certifications like 70-463: Implementing Data Warehouses with Microsoft SQL Server.
View all posts by Gauri Mahajan
She has a deep experience in designing data and analytics solutions and ensuring its stability, reliability, and performance. She is also certified in SQL Server and have passed certifications like 70-463: Implementing Data Warehouses with Microsoft SQL Server.
View all posts by Gauri Mahajan
Latest posts by Gauri Mahajan (see all)
- Oracle Substring function overview with examples - June 19, 2024
- Introduction to the SQL Standard Deviation function - April 21, 2023
- A quick overview of MySQL foreign key with examples - February 7, 2023
Introduction to the SQL Standard Deviation function
April 21, 2023
In this article, we will learn about one of the important statistical functions, the SQL Standard Deviation function.
Read more »
A quick overview of MySQL foreign key with examples
February 7, 2023In this article, we will learn how to work with MySQL foreign keys with a few examples.
Read more »
Overview of the SQL Median function
January 4, 2023In this article, we will learn how to implement the median functionality and wrap it into a SQL median function
Read more »
PostgreSQL Join overview with examples
December 2, 2022In this article, we will learn about different types of PostgreSQL joins with examples.
Read more »
Getting started with procedures in Azure Database for PostgreSQL
October 26, 2022In this article, we will learn how to work with procedures in Azure Database for PostgreSQL.
Read more »
Managing schema in Azure Database for PostgreSQL using pgAdmin
October 25, 2022In this article, we will learn how to use the features of pgAdmin for tasks like schema comparison and schema management.
Read more »
Reporting data from Azure Database for PostgreSQL using Power BI
October 12, 2022In this article, we will learn how to use Power BI to source data from an instance of Azure Database for PostgreSQL, transform this data and load it into Power BI for reporting.
Read more »
Data Modeling with ERD features in pgAdmin
October 11, 2022In this article, we will learn how to use the ERD Project feature of pgAdmin to work with an instance of Azure Database for PostgreSQL for data modeling.
Read more »
Querying data from Azure Database for PostgreSQL using psql
October 3, 2022In this article, we will learn how to query the data as well as database objects hosted in an instance of Azure Database for PostgreSQL using psql and export the results of the query to a file.
Read more »
Introduction to basic psql commands
September 30, 2022In this article, we will take a basic walkthrough of the psql environment and learn the commands to get acquainted with this tool.
Read more »
Integrating Azure Data Explorer cluster with Azure Synapse
September 19, 2022This article will show how to create an Azure Data Explorer cluster, and then configure it to be used with the Azure Synapse Analytics instance.
Read more »
Ingesting data into Azure Synapse Data Explorer Pool
September 16, 2022In this article, we will learn how to configure a newly created Data Explorer pool in Azure Synapse followed by data ingestion into the same pool.
Read more »
Getting started with Data Explorer pools in Azure Synapse
September 5, 2022In this article, we will learn how to set up and configure Azure Data Explorer based data processing capability on Azure Synapse.
Read more »
Template Gallery in Azure Synapse Lake Database
August 29, 2022In this article, we will learn how we can create tables in the Azure Synapse Lake Database instance first and bind it with data later.
Read more »
Configuring tables and relationships in Azure Synapse Lake Database
August 26, 2022In this article, we will learn how to configure properties and relationships in Azure Synapse Lake Database.
Read more »
Getting started with Azure Synapse Lake Database and Lake tables
August 19, 2022This article will get you started with Azure Synapse Lake Database and Lake tables.
Read more »
Import data using R in Power BI
July 27, 2022In this article, we will learn how to configure Power BI to work with R and source the required datasets from it for reporting in Power BI Reports.
Read more »
How to perform Process Mining using Power BI
July 20, 2022In this article, we will learn how to perform Process Mining with Power BI.
Read more »
Analyzing spatial data with Azure Maps in Power BI
July 14, 2022In this article, we will learn how to represent spatial data on Azure Maps visualization and explore the features to effectively format the data to make it intuitive for the end-user.
Read more »
Analyzing key influencers in data with Power BI
June 29, 2022In this article, we will use Power BI Desktop to analyze key influencers in a dataset and learn how to use the corresponding visualization as well.
Read more »
Generating smart narratives in Power BI
June 28, 2022In this article, we will learn how to use smart narratives in Power BI to generate textual narratives that summarize the key highlights of the data presented in the report.
Read more »
Using psql tool with Azure Database for PostgreSQL
May 27, 2022In this article, we will learn how to connect the pSQL tool with Azure Database for PostgreSQL.
Read more »
Introduction to Azure Synapse Lake Database in Azure Synapse Analytics
May 23, 2022
In this article, we will learn what is an Azure Lake Database conceptually, and the different components of this solution, followed by its practical implementation in upcoming articles.
Import data using Python in Power BI
May 11, 2022In this article, we will learn how to use Python to source data in Power BI using the python programming language.
Read more »