ViewTube

Data is everywhere but too few businesses use it effectively. One of the reasons for this improvident state is time and ...

Ben talks about Opaleye, an extremely composable and typesafe haskell DSL for generating SQL against a Postgres database.

Andy Pavlo (https://www.cs.cmu.edu/~pavlo/) Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/03-storage1.pdf Notes: ...

From https://www.pgcon.org/events/pgcon_2020/schedule/session/101-avoiding-detecting-and-recovering-from-data-corruption/ ...

Keynote by Martin Kleppmann at the 15th ACM International Conference on Distributed and Event-based Systems (ACM DEBS ...

If you want optimum performance in SQL Server, you have to use indexes. But what if you already implemented indexes and your ...

Slides PDF: https://15445.courses.cs.cmu.edu/fall2018/slides/02-advancedsql.pdf Lecture Notes PDF: ...

It's hard to beat SQLite for quickly setting up a database on a project — but can it handle “real” projects? Glauber Costa teaches ...

This video features a mock SQL interview between Nikita and Dmitry. It was Dmitry's first mock interview, and while he was ...

Today's session is going to be going back to my roots with visual database design with pgModeler. I am a visual thinker and find ...

A detailed, deep-diving, in-the-deep-end and occasionally humorous whirlwind introduction and analysis of a suite of modern ...

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

Date describes the three-valued logic approach to missing information ("nulls") in depth. Both the underlying theory and SQL's ...

In this video, you'll learn **how to properly document a SQL project on GitHub**, even if you're a beginner. Writing SQL queries is ...

In hour 7 of AHKCon we discussed the pros & cons of using various storage types. Deciding on the "best" way to save user input is ...

New drops are live! Grab your favorite tees today at https://oridada.com/ Free SQL Course – Learn What Companies Want ...

… except when you should. :) Have you ever used a graph database? Probably not, and with good reason. For most projects a ...

Prof. Andy Pavlo (https://www.cs.cmu.edu/~pavlo/) Slides: https://15721.courses.cs.cmu.edu/spring2023/slides/20-databricks.pdf ...

This video features a mock SQL interview hosted by Nikita, with a special focus on BigQuery syntax. The session is designed for ...

Annotated Video: http://cmudb.io/15721-s16-lect01 Slides PDF: http://15721.courses.cs.cmu.edu/spring2016/slides/01.pdf ...