Sql

Sql posts, videos, courses, and more

Bobby Iliev · 1 week ago

How to connect Laravel to Materialize and build a live dashboard?

Introduction Materialize is a streaming database that takes data coming from different sources like Kafka, PostgreSQL, S3 buckets, and more and allows users to write views that aggregate/mat...
2

Bobby Iliev · 2 weeks ago

How to create a simple event streaming in Laravel?

Introduction Event streams provide you with a way to send events to the client without having to reload the page. This is useful for things like updating the user interface in real-time chan...
6

Bobby Iliev · 2 weeks ago

How to use dbt with Materialize and Redpanda

Introduction This is a self-contained demo using Materialize. This demo shows you how to use dbt together with Materialize. For this demo, we are going to monitor the reviews left by users o...
5

Bobby Iliev · 1 month ago

How to join MySQL and Postgres in a live materialized view

Introduction This is a self-contained demo using Materialize. This demo would show you how to use Materialize to join MySQL and Postgres in a live materialized view. For this demo, we are go...
4

Bobby Iliev · 1 month ago

What is the difference between DATETIME and TIMESTAMP data type in MySQL?

Introduction If you have ever worked with MySQL and had to create your table structure, you have probably noticed that the DATETIME and TIMESTAMP data types are quite similar at a first glan...
4

Bobby Iliev · 2 months ago

Building a real-time web application with Materialize and AdonisJS

Introduction In this tutorial, we are going to build a web application using AdonisJS and integrate it with Materialize to create a real-time dashboard based on streaming data using standard...
10

Bobby Iliev · 2 months ago

How to Find Duplicate Values in a SQL Table?

Introduction In this quick tutorial, you will learn how to find the duplicate values in a SQL table with a single SQL query. Let's say that we have a table called users with the following da...
7

Bobby Iliev · 2 months ago

What is the difference between UNION and UNION ALL in SQL?

Introduction If you've ever used SQL, you probably know that UNIONs can be quite confusing at first. In this quick post we are going to learn what the difference between UNION and UNION ALL...
4

Bobby Iliev · 2 months ago

Learn Materialize by running streaming SQL on your nginx logs

Introduction In this tutorial, I will show you how Materialize works by using it to run SQL queries on continuously produced nginx logs. By the end of the tutorial, you will have a better id...
7

Bobby Iliev · 2 months ago

What is the difference between JOIN and INNER JOIN in SQL?

Introduction If you've ever used SQL, you probably know that JOINs can be very confusing. In this quick post we are going to learn what the difference between JOIN and INNER JOIN is! Differe...
8

Bobby Iliev · 2 months ago

How to import an SQL file using the command line in MySQL?

Introduction In some cases if you have a really large .sql file, it is best to import it via the command line. You might need to do this in case that you are using a tool like PHPmyAdmin, wh...
6

Bobby Iliev · 2 months ago

How to Add a Default Value to an Existing Column in MySQL

Introduction In this quick tutorial, you will learn how to add a default value to an existing column in MySQL. Prerequisites You always need to be careful, when changing the structure of an...
5

Bobby Iliev · 2 months ago

The top 10 Linux Commands that Every Data Engineer Should Know

Introduction No matter if you are a data analyst or a system administrator when working with unstructured files in Linux there are a set of commands that would help you a lot in your daily t...
5

Bobby Iliev · 3 months ago

The Data Engineer Roadmap 🗺

Introduction With the ever growing data volumes and demands, the data engineering career has been one of the fastest growing jobs for the past few years. According to the 2021 Stack Overflow...
7

Bobby Iliev · 4 months ago

🚀 The Missing SQL Basics Crash Course

Introduction No matter if you are a DevOps/SysOps engineer, developer, or just a Linux enthusiast, you will most likely have to use SQL at some point in your career. The guide is suitable fo...
8

Bobby Iliev · 7 months ago

How to limit the result with Laravel Eloquent?

Introduction The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations an...
9

Bobby Iliev · 7 months ago

How to Delete All Entries in a Table Using Laravel Eloquent?

Introduction The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations an...
11

Bobby Iliev · 7 months ago

How to Order the Results of all() in Laravel Eloquent?

Introduction The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations an...
8

Bobby Iliev · 7 months ago

How to Count and Detect Empty Laravel Eloquent Collections?

Introduction The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations an...
9

Bobby Iliev · 7 months ago

How to Remove a Migration in Laravel?

Introduction Adding columns or tables to your database manually could be an intimidating process and would more often than not lead to database inconsistencies between your different environ...
9

Bobby Iliev · 7 months ago

How to Select Specific Columns in Laravel Eloquent?

Introduction The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations an...
9

Bobby Iliev · 8 months ago

Opensource Introduction to SQL eBook 💡

This is an open-source introduction to SQL guide that will help you learn the basics of SQL and start using relational databases for your SysOps, DevOps, and Dev projects. No matter if you a...
11

Bobby Iliev · 11 months ago

How to get the Laravel Query Builder to Output the Raw SQL Query?

Introduction The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations an...
8

Carter Brooksby · 11 months ago

Transactional Replication on SQL Server: How it Works

One day at work, when I was still learning about replication, we set up a game: I would create a transactional replication on a dummy database and make a job that inserts and updates entri...
3

Tony Lea · 6 years ago

What is Sequel Pro

If you've worked with databases in the past then it is probably certain that you have worked with PHPMyAdmin. PHPMyAdmin is a great web tool for interacting with your database; however, sinc...

Tony Lea · 10 years ago

SQL Replace String

Have you ever wanted to replace a particular part of a string in SQL and you don't want to go through the hassle of coding the query and using PHP functions to parse and replace that specifi...

Loading More Content