top of page
_edited_edited.png)
Evergreen posts from some of our Ninjas...
May 12, 20213 min read
1,432 views
All Blogs
Search
Sheba Alice Prathab
Oct 155 min read
A Comprehensive Guide to SQL - Views
Welcome back to the SQL series! We now dive into a critical feature in SQL databases— Views . Views offer an abstraction over database...
Sheba Alice Prathab
Oct 125 min read
A Comprehensive Guide to SQL - Stored Procedures
Stored procedures in PostgreSQL provide a powerful way to encapsulate complex logic, manage transactions, and handle data efficiently. In...
Sheba Alice Prathab
Oct 124 min read
A Comprehensive Guide to SQL Triggers: DDL Triggers - PART II
In the previous blog, we learned about SQL triggers and discussed DML triggers in detail, covering all the combinations of BEFORE and...
Sheba Alice Prathab
Oct 1010 min read
A Comprehensive Guide to Indexes in SQL: From Basics to Advanced Usage
Indexes are vital components in SQL databases, enabling faster data retrieval and improving query performance. This blog explores what...
Sheba Alice Prathab
Oct 86 min read
A Complete Guide to SQL Operations: Inserting, Updating, Deleting - Rows, Dropping and Truncating -Tables
In the world of databases, SQL (Structured Query Language) is essential for performing various operations that allow users to manage...
Sheba Alice Prathab
Oct 84 min read
Understanding SQL Tables: A Comprehensive Guide to Data Types and Constraints
In the realm of data management, databases serve as structured collections of information. They enable the storage, retrieval, and...
keyuripalav
Sep 275 min read
Exploratory Data Analysis with SQL
Structured Query Language or SQL One of the most popular and easy-to-learn tools for data analysis is SQL. It let us retrieve , filter ,...
Sruthi Sudhagaran
Aug 296 min read
Data Granularity at its finest!
Data is everywhere and of course in every possible form of detail around us. Data has become the core of every aspect in our day to day...
Sruthi Sudhagaran
Aug 288 min read
Back to basics - SQL Joins
SQL (Structured Query Language) is the core of relational database systems that helps in handling of data. JOIN statement is used to...
Reena Pinto
Apr 56 min read
Exploring ETL in Data Analysis Using SQL
Introduction to ETL: Recently, we have seen that data analysis has become very important for decision-making across different businesses....
Smita Pinjan
Oct 10, 20233 min read
Negative Profit or Loss: Visualisation using Tableau
\ Tableau is one of the tools that helps in Data Analysis and Data Visualization. This tool helps to create a visual presentation to...
harshuscorp
Mar 17, 20236 min read
Onboard with Reports & Dashboards
Every business has questions and Salesforce data has the answers. When you get asked to build a report, the request typically comes in...
harshuscorp
Mar 13, 20235 min read
Data Modelling
To understand Data Modelling, we need to understand What is a Database? Database is an organized collection of information. In a...
Praveena Gs
Mar 10, 20237 min read
SQL Basic and its operations for Beginners
Structured Query Language or SQL is a standard Database language which is used to create, maintain and retrieve the data from relational...
harshuscorp
Mar 9, 20234 min read
Let's do Bucketing
Bucketing What is the Bucket Field in Salesforce? The Bucket Field in Salesforce is a valuable feature that allows you to rapidly...
harshuscorp
Mar 9, 20234 min read
Salesforce-multi cloud
Cloud computing is a way to access information and applications online instead of having to build, manage, and maintain them on your own...
harshuscorp
Mar 8, 20234 min read
Unique Record ID's in Salesforce
Record ID in Salesforce A Record is collection of data which clearly illustrates the Object. A record can have many fields which stores...
Naina Jophy
Nov 26, 20223 min read
How to use SQL Window Function - PostgreSQL
image source unsplash.com A window function performs calculations on table rows that are related to the current row and use of the window...
radha4radha
Oct 13, 20222 min read
File Extensions in Tableau
.twb .twbx .tds .tdsx .tde/hyper .tbm .tps 1).twb (Tableau Workbook) Tableau workbook means it can be a combination of data, worksheets,...
radha4radha
Oct 12, 20221 min read
Tableau — Products of Tableau
Tableau “Tableau is a Business Intelligence tool that is purposely used for making visualizations “ “Tableau is used to get insights out...
bottom of page