Solved problems in SQL - SET 5

Solved problems in SQL - SET 5

This is the third set of solved exercises to master the use of select, GROUP BY, HAVING, INTERSECT

Read more
Solved problems in SQL - SET 4

Solved problems in SQL - SET 4

This is the third set of solved exercises to master the use of select, GROUP BY, HAVING, INTERSECT

Read more
Solved problems in SQL - SET 3

Solved problems in SQL - SET 3

This is the third set of solved exercises to master the use of select, GROUP BY, HAVING, INTERSECT

Read more
Solved problems in SQL - SET 2

Solved problems in SQL - SET 2

Given the database called "project_management" allowing to manage projects related to software development. It is described by the following simplified text representation:

Read more
Solved problems in SQL - SET 1

Solved problems in SQL - SET 1

given the database of a music festival: In one performance can participate one or more musicians. A musician can only participate in one performance.

Read more
Data modeling method

Data modeling method

Once the analysis is complete, the next step is to develop a series of models, based on the analysis document. These models will allow us later to implement a database, which will contain all the information necessary for the proper functioning of the computerized system.

Read more
Definition and representation of an information system

Definition and representation of an information system

An information system does not necessarily have to be computerized. Although most of today's systems are based on computer technology, there are still information systems where information is stored, manipulated and communicated using "traditional" means such as cupboards, filing cabinets, calculators, paper charts, etc.

Read more
Introduction to Information systems analysis

Introduction to Information systems analysis

The competitiveness of a company and its value on the market are determined by several elements, of different importance depending on the sector of activity. We can generally group these elements into two classes

Read more
Retrieve data from the database - SELECT

Retrieve data from the database - SELECT

SELECT is the most commonly used statement in SQL. The SELECT statement in SQL is used to extract data from a database. We can recover the entire table or according to certain specified rules. The returned data is stored in a results table. This result table is also called a result set.

Read more
Insert and modify records - INSERT, UPDATE and DELETE

Insert and modify records - INSERT, UPDATE and DELETE

The INSERT INTO statement is used to add new rows of data to a table in the database. The UPDATE query is used to modify existing records in a table. You can use the WHERE clause with the UPDATE query to update the selected rows, otherwise all the rows would be affected.

Read more