Welcome to the Adunni Data Blog.
Navigating Time With SQL DATE Functions – Part 3
Working with dates is a fundamental aspect of database management and data analysis. SQL provides a rich…
Navigating Time With SQL DATE Functions – Part 2
Working with dates is a fundamental aspect of database management and data analysis. SQL provides a rich…
Navigating Time With SQL DATE Functions – Part 1
Working with dates is a fundamental aspect of database management and data analysis. SQL provides a rich…
Mastering SQL STRING Functions – Part 3
Imagine trying to analyze customer feedback, product descriptions, or user comments without the ability to manipulate text…
Mastering SQL STRING Functions – Part 2
In the world of SQL, numbers often get all the glory, but it’s the humble string functions…
Mastering SQL STRING Functions – Part 1
Text data is everywhere, from customer reviews to email addresses, and even a slight misstep in handling…
Dealing With NULL Values in SQL
In SQL, NULL is a special marker used to indicate that a data value in a database…
Manipulating Data With the SQL CASE Statement
Whether you’re assigning conditional values, performing conditional aggregation, implementing complex sorting, or handling conditional joins, the CASE…
Extracting Unique Values Using The DISTINCT Keyword
When it comes to refining and simplifying queries, the DISTINCT keyword proves to be invaluable. In this…
Building Bridges with SQL JOINS
The JOIN operation combines rows from two or more tables based on a related column between them.…
Understanding the HAVING clause
While the WHERE clause filters individual rows before they are grouped, the HAVING clause filters groups of…
How to use SQL Aggregate Functions
The `GROUP BY` clause in SQL is used to AGGREGATE identical data into groups based on one…
Organising data with the ORDER BY clause
In SQL, the ORDER BY clause is a crucial feature that allows you to sort the result…
Filtering using the WHERE clause
In this blog post, we will dive into the details of the WHERE clause in SQL and…
Understanding the SELECT and FROM clause
There are a ton of resources available on the internet to build SQL competency so we have…
SQL Practice Guide
Hello Fellow Challengers! We believe that practice truly makes perfect, hence we created this practical guide to…
Data Analytics and the Age of AI
As we hurtle through the era of artificial intelligence, the landscape of data analytics is undergoing a…
The Sweet Symphony of Salary Bands
If you’ve ever wondered about the financial rewards of diving into the world of data analysis, you’re…
Navigating the Job Market and Hiring Process
Understanding the job market and the hiring process is key to unlocking your dream role. Join us…
Responsibilities and Qualities of a Data Analyst
Greetings, data enthusiasts and aspiring analysts! If you’re reading this, chances are you’re intrigued by the world…
The Different Paths to Becoming a Data Analyst
Data analysts are the unsung heroes of the data world, translating raw information into actionable insights that…
Demystifying Data and Analytics Job Titles
A myriad of job titles related to data and analytics have emerged since data analytics became popular.…
A Guide to Different Data Roles
Data-related roles have become increasingly diverse, each with its unique responsibilities and skill sets. Whether you’re a…
Understanding the Different Types of Analytics
Data is often referred to as the new oil of the 21st century. However, like crude oil,…
A Brief History of Data Analytics
Data analytics is a field that has undergone remarkable evolution over the past few decades. From its…
A Journey to Mastery
In the ever-evolving landscape of technology and business, Data Analytics has emerged as a superpower. The ability…
OLDER POSTS
- A Journey to Mastery
- A Brief History of Data Analytics
- Understanding the Different Types of Analytics
- A Guide to Different Data Roles
- Demystifying Data and Analytics Job Titles
- The Different Paths to Becoming a Data Analyst
- Responsibilities and Qualities of a Data Analyst
- Navigating the Job Market and Hiring Process
- The Sweet Symphony of Salary Bands
- Data Analytics and the Age of AI
- SQL Practice Guide