SQL.sh - Guide SQL en Français

Unofficial based application SQL.sh website, thematic access in 3 main categories:

   - SQL Courses

   - SQL Function

   - The DBMS in general

Manage your searches and favorites to have everything at hand.

Here is the introduction of the site SQL.sh

Learn SQL

SQL (Structured Query Language) is a language to communicate with a database. This programming language is particularly widely used by web developers to communicate with the data from a website. SQL.sh identifies over SQL and explanations of the main commands to read, insert, edit and delete data in a database.

Course

The courses are designed to teach the main SQL commands such as SELECT, INSERT INTO, UPDATE, DELETE, DROP TABLE ... Each SQL statement is presented with clear and concise examples. These tutorials can help you to make your own SQL training.

In addition to the list of SQL commands, classes present mnemonic sheets presenting SQL functions such as AVG (), COUNT (), MAX () ...

Database management system (DBMS)

Each DBMS has its own specificities and characteristics. To present these differences, database management software are listed, such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server or Oracle.

NoSQL DBMS type are also presented, such as Cassandra, Redis and MongoDB.

Optimization

Know perform queries is not too difficult, but it should truly understand how the data storage and the way they are read to optimize performance. Optimizations are based in two categories: the right choice to make when defining the database structure and the most appropriate methods to read data.