PostgreSQL When it’s not Your Job
This video explains (nearly) everything you need to know to bring up, tune, and keep a PostgreSQL database health. It covers installation, basic tuning, backups, disaster recovery, and helpful tools and techniques.
This video explains (nearly) everything you need to know to bring up, tune, and keep a PostgreSQL database health. It covers installation, basic tuning, backups, disaster recovery, and helpful tools and techniques.
Writing queries with date and time data types can be tricky! Learn tips and best practices for selecting the right data types, choosing the best performing functions to round (or truncate) values, and how to avoid common pitfalls with dates and times in SQL Server.
This video explains how to install SQLite3 on both Mac and Windows. It also covers how to use SQLite3 using the console. SQLite is an open source software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
This lecture provides an overview of what databases are and how they are used. It is concept based and just covers beginning database concepts. It is not a technical lecture and does not cover much outside of basic introduction to the database concept using Oracle as an example.
This short tutorial explains how to replace your MySQL database with a MariaDB database.
Rich Hickey is the creator of the Clojure programming language. He discusses new approach to database design and general purpose programmability. He presents Datomic, a database of flexible, time-based facts, supporting queries and joins, with elastic scalability, and ACID transactions. It is implemented in Clojure.