Blog

 

 
 

 

Get inspired by my articles

I give people clear, functional, and proven instructions. I gently guide them so that they can fulfill their IT dreams.

Cate Richter, web author
 
 

GROUP BY

SQL
If we need to group rows with the same values into…

DELETE

SQL
The DELETE statement allows you to delete data from a table.…

SELF JOIN

SQL
Selft join is a particular type of join. The difference is…

UPDATE

SQL
The UPDATE statement allows you to change the data in a…

TRUNCATE TABLE

SQL
The TRUNCATE statement deletes a table from the database. This means…

FULL JOIN

SQL
Returns records when we have the corresponding foreign key in the…

DROP TABLE

SQL
The DROP statement deletes a table from the database. Neither data…

ALTER TABLE

SQL
With ALTER we can modify an existing table. We can add,…

RIGHT JOIN

SQL
Returns records when we have the corresponding foreign key in the…

Data types

SQL
The database has defined data types that express the nature of…

INSERT INTO

SQL
The INSERT INTO statement allows us to insert new data into…

CREATE TABLE

SQL
Creating a table is the creation of a data structure into…