M. ESSADDOUKI

M. ESSADDOUKI Mostafa

Founder-CEO and CS Teacher

Many people realize their hearts desires late in life. Continue learning, never stop striving and keep your curiosity sharp, and you will never become too old to appreciate life.

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
Constraints in SQL

Constraints in SQL

Constraints allow you to limit the type of data to insert into a table. These constraints can be specified when creating the table using the CREATE TABLE statement, or after creating the table using the ALTER TABLE statement. Constraints can be at the column or table level. Column level constraints are applied to only one column, while table level constraints apply to the entire table.

Read more
Modify the structure of a table - ALTER TABLE

Modify the structure of a table - ALTER TABLE

ALTER TABLE is the command used to add, delete or modify columns in an existing table. This command is also used to add and remove various constraints on an existing table.

Read more
Creation and deletion of tables in SQL

Creation and deletion of tables in SQL

In SQL to create a table you need to provide its name and its columns and the data type of each column. to delete a table definition as well as all the data, indexes, triggers, constraints and permission specifications for this table, we use the keyword DROP TABLE

Read more
SQL data types

SQL data types

Data types are used to represent a kind of data that can be stored in the database. The data type is the set of representable values. It is also known as an attribute which specifies a data type of the object. Each column, variable and expression has the associated data type in the SQL code when the table was created.

Read more
Introduction to SQL

Introduction to SQL

SQL is a language for operating databases; it includes creating, deleting, extracting lines, modifying lines, etc. databases. SQL is an American National Standards Institute (ANSI) standard language

Read more
Matrices in Python

Matrices in Python

A matrix is a two-dimensional data structure in which numbers are organized in rows and columns. Python has no built-in type for matrices. However, we can treat a list list as a matrix.

Read more
Creation and deletion of a database

Creation and deletion of a database

The CREATE DATABASE statement is used to create a new SQL database. The DROP DATABASE statement is used to drop an existing database from an SQL schema. When you have several databases in your SQL schema, before starting your operation, you must select a database on which all the operations will be performed.

Read more
SQL Operators

SQL Operators

An operator is a reserved word or character used primarily in the WHERE clause of an SQL statement to perform operations, such as comparisons and arithmetic operations. These operators are used to specify conditions in an SQL statement and to serve as conjunctions for multiple conditions in a statement.

Read more