SQL Basics - SQL Strategy - A site to master SQL while executing it on the Web

This section provides an overview of the SQL we will be studying.

1. SQL functions

SQL is a database language standardized for working with relational databases and has three major functions.

1. Data definition
2. data manipulation
3. data control

Among these functions, the contents that appear in the Basic Information and IT Passport exams are mainly data manipulation in 2. For this reason, this site provides explanations focusing on these functions and a hands-on training environment.

2. data manipulation

Data manipulation in SQL consists of the following four operations

SELECT statement・・・Extract data from the table.
INSERT statement・・・Add a record to the table.
UPDATE statement・・・Update the data contents of the records in the table.
DELETE statement・・・Delete a record in a table.

Among these, the SELECT statement appears in a very large number of questions. In the Basic Information and IT Passport examinations, it is possible to score almost perfectly if you know how to extract data with the SELECT statement and the syntax of the INSERT statement, UPDATE statement, and DELETE statement.

Point

In order to answer SQL questions on the Basic Information and IT Passport exams, make sure to keep the SELECT statement, INSERT statement, UPDATE statement, and DELETE statement in mind.