SQL

SQL Indexes

Understanding Indexes in SQL Server Today, we're exploring the vital topic of indexes in SQL Server. Indexes are crucial for database performance, and understanding them can greatly improve your efficiency in...

Working with XML Data in T-SQL: Marvel Movies Example

XML (eXtensible Markup Language) remains a powerful and popular format for storing and exchanging structured data. In this blog post, we’ll explore how to work with XML data in T-SQL using an example that features Marvel movies and their directors. We'll cover how to...

Stored Procedures vs Functions

Stored procedures and functions are both important concepts in SQL used to encapsulate and reuse code. Many people don't seem to know the difference between the 2. I've realised that from interviewing many many people and asking them to explain the differences. Here...

How to be a Senior SQL Developer

If you're wondering if you have what it takes to be a Senior SQL Developer then this list will clear it up for you. Check out the video for more details. 10 Keys to Success as a Senior SQL Developer Mastery of SQL Syntax and Advanced Query Techniques Proficiency in...

Stop using IsNumeric for data validation

The infamous ISNUMERIC function! It seems helpful at first, but then you wake up…hopefully. Here's why you should ditch ISNUMERIC and join the TRY_CAST crew: ISNUMERIC - Returns true for '+', '-', and '.' - Thinks hexadecimal strings are numeric (um, ok!) - Says...

Can you run SQL Server on a Mac?

Introduction Apple Silicon, Apple's pioneering venture into ARM-based processors, has been met with widespread acclaim for its impressive performance and power efficiency. However, it is not without its challenges, especially when it comes to compatibility with...

Intro to SQL – More functions (4 of 4)

Intro to SQL – Views and Stored Procedures (3 of 4)

Intro to SQL – CREATE, SELECT, INSERT, UPDATE DELETE (2 of 4)

SQL Joins

Get your FREE SQL Joins Booklet This booklet is the perfect resource for everyone who wants to get to grips with JOINs in SQL. Get your copy today to supercharge your code. When working with relational databases, one of the most powerful features you have at your...

SQL Indexes

Aug 6, 2024

Working with XML Data in T-SQL: Marvel Movies Example

Jul 18, 2024

Data

Browse All

What is a Data Engineer

by Kevin Naidoo | 15 August 2023 | Data, Podcast | 0 Comments

Introduction to Data Engineering Data engineering is a comprehensive field of study and practice that concentrates on the vital task of collecting, preparing, and rendering data useful for a variety of purposes. This field forms the backbone of any data-driven...

What is Business Intelligence

by Kevin Naidoo | 15 August 2023 | Data, Podcast | 0 Comments

Business Intelligence (BI) is a technology-driven process used to analyze data and present actionable information to aid executives, managers, and other corporate end users in making informed business decisions. It encompasses the applications, infrastructure and...

What is a database?

by Kevin Naidoo | 8 January 2024 | Data, Podcast | 0 Comments

In the following sections, we will delve into various types of databases, including Microsoft Excel, Relational Databases, and NoSQL databases. Each of these databases serves different purposes and is utilized based...

What is a Data Mesh?

by Kevin Naidoo | 4 February 2024 | Data, Podcast | 0 Comments

Understanding Data Mesh and Its Impact on Businesses In the world of data management, the term 'data mesh' has been gaining traction. A data mesh is a decentralized data architecture that fundamentally treats data as a product. But what does this mean, and how does it...

7 most used terms in the data world 2024

by Kevin Naidoo | 4 February 2024 | Data, Podcast | 0 Comments

What is a data analyst?

by Kevin Naidoo | 4 February 2024 | Data, Podcast | 0 Comments

Data Analysts: Pioneers in the Data World Ever wondered who's behind the valuable insights derived from the overwhelming amounts of data generated every day? Meet the data analyst. They play a critical role in helping businesses make data-driven decisions and predict...

What is Data governance

Jul 17, 2024

Today, we’re diving into a topic that might sound dry but is absolutely crucial for any modern enterprise—Data Governance. So lets jump right into it. So, what is data governance? Imagine you’re the captain of a ship...

Telling stories with data

Jul 15, 2024

Today, we're diving into one of the most important skills in the data world – Storytelling with Data where you’ll learn how to Communicate Insights Effectively. From uncovering hidden trends to making data-driven decisions, telling a compelling story with data can be...

Podcast

Browse All

What is Data governance

Jul 17, 2024

Telling stories with data

Jul 15, 2024

What is a data warehouse and should you use it

Apr 11, 2024

What’s up peeps I remember when I started applying for jobs many many MANY years ago, I always came across Data Warehousing. In my mind I imagined a big warehouse with lots of data in boxes. Yes I know how dum this sounds but that’s what I thought. So, first things...