ViewTube

See why left joins can create duplicate rows in your base table. Two easy methods to avoid those duplicates: Aggregating results ...

SQL Databases are powerful for data analysis, and in the world of Finance, we handle massive amounts of data, often scattered ...

Quickly make SQL Statements easier to understand by inserting spaces and line breaks where it makes sense. Untangle logic ...

The portal.sqlite file can be downloaded here: https://ndownloader.figshare.com/files/11188550 Notes on how to create a file like ...

Try Chat2DB here: https://bit.ly/3Zit8Hc In this video, I explore Chat2DB – an AI-powered SQL tool that helps you generate, ...

SQL (the language) is not a third generation language, where the developer tells the computer every step it needs to take.

Improve hybrid workloads with updates to SQL Server 2022, now generally available. Watch the full video here: ...

This is CS50's introduction to databases using a language called SQL. Learn how to create, read, update, and delete data with ...

This video is about aggregating or grouping data in SQL. In SQL we can break the data into groups and summarize the data in ...

Remember that web application you wrote when you where first learning PHP? Ever wonder how vulnerable that code base is?

The "SQL on FHIR" specification addresses the challenge of making large-scale analysis of FHIR (Fast Healthcare Interoperability ...

In this end-to-end data engineering video, I am going to walk you through the comprehensive steps to efficiently and seamlessly ...

In this last video in the SQL Review series, the focus is on writing queries in the real-world. A significant portion of the video is ...

Creating a new database? Make sure you don't fall into these traps! In this video, I go over the most common mistakes ...

Welcome back to another intermediate-advanced SQL tutorial! Let us talk about Stored Procedures in SQL, more specifically, ...

Creating a new database? Make sure you don't fall into these traps! In this video, I go over the most common mistakes ...

osquery is a free and open source tool that turns your computers (endpoints) into queryable "things" using SQL. For example ...

This video is about how to select columns in SQL. Now that we're set up to run SQL queries in the 'portal.sqllite' database we'll ...

In this Databricks video, I covered how to use the Databricks SQL QUALIFY with window functions in SELECT list and in QUALIFY ...