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 ...

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

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

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

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

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

Ever wondered how Elasticsearch powers blazing-fast searches? In this video, we explore Elasticsearch — a scalable NoSQL ...

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, ...

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

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

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

In this Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse episode, I am going to walk you through how to ...

Join me as I demonstrate how to master SQL and Python integration, showing you essential techniques for database connectivity ...

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

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 ...

NYC Open Data Week 2024 48 Intro to SQL - March 16 2024 Meghan Maloy - Staff Analytics Engineer, Datadog SQL (Structured ...

This video is about combining data from multiple tables in SQL. And just like in dplyr we do this using joins. So let's write a query ...