BDD

Solve crimes and mysteries using SQL queries in this detective-themed SQL learning game.

Learn how to design systems at scale and prepare for system design interviews - karanpratapsingh/system-design: Learn how to design systems at scale and prepare for system design interviews

NoSQL was the next big thing in system architecture in 2011, but overall interest in it has plateaued recently. What is NoSQL, what does it have to do with modern development, and is it worth implementing in your project?

Databases are fabulous resources. Of course, we’ll abuse them in ways that cause challenges.

Everything you need to know about designing an efficient database, including an overview of the processes and principles to follow.

Identify Problems Before They Become Disasters

Applications, even databases come and go, but data is the most important part of the story. Usually, data is the purpose of the system exists in the first place. That’s why we should consider…

The on-line encyclopedia of databases systems from Carnegie Mellon University.

Here’s a list of reasons why SELECT * is bad for SQL performance, assuming that your application doesn’t actually need all the columns. When I write production code, I explicitly specify the columns of interest in the select-list (projection), not only for performance reasons, but also for application reliability reasons. For example, will your application’s data processing code suddenly break when a new column has been added or the column order has changed in a table? - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

This guide is intended to help you gain a true understanding of SQL query speeds. It includes research that demonstrates the speed of slow and fast query typ...

Items edition,position,headline,text,links,hattips 2015.10.21,1,Every place name in the United States.,Sometimes, bureaucracy creates poetry. Since 1890, the U.S. Board on Geographic Names has been cataloguing, standardizing, and promulgating official names for the places we hike, swim, work, an...

Learn how databases work, how to choose the right one, and how to use databases with your applications to their full potential.

With MySQL, common configuration mistakes can cause serious performance problems. In fact, if you misconfigure just one of the many config parameters, it

Longtemps, les bases de données relationnelles ont régné en maîtres sur le stockage de données structurées... Cette époque est désormais révolue, et une foule de solutions s'attaquent aux différents problèmes liés à l'explosion des données massives. Vive le NoSQL !

Simple, beautiful database diagram editor for developers to create, collaborate and visualize their entity relationship diagrams.

Notre tutoriel pour apprendre à sauvegarder facilement tout ou partie d'une base de données Mysql ainsi que les commandes pour restaurer une sauvegarde

SQL Police Department is an online game where you solve crimes using SQL (and learn SQL in the process). Learn SQL while playing a game!

By Zachary Thomas (zthomas.nc@gmail.com, Twitter, LinkedIn)

A free test data generator and API mocking tool - Mockaroo lets you create custom CSV, JSON, SQL, and Excel datasets to test and demo your software.

This tutorial provides instructions on how to install the PostgreSQL database software on an Ubuntu 18.04 server. It also includes instructions for basic database management.