{"id":37595,"date":"2024-10-09T03:28:47","date_gmt":"2024-10-08T17:28:47","guid":{"rendered":"https:\/\/database.guide\/?p=37595"},"modified":"2024-10-09T03:28:48","modified_gmt":"2024-10-08T17:28:48","slug":"7-sql-statement-examples-for-beginners","status":"publish","type":"post","link":"https:\/\/database.guide\/7-sql-statement-examples-for-beginners\/","title":{"rendered":"7 SQL Statement Examples for Beginners"},"content":{"rendered":"\n

SQL<\/a> (Structured Query Language) is the standard language for managing and manipulating relational databases. Whether you’re just starting your journey in data management or looking to refresh your skills, understanding the basic SQL statements is crucial. <\/p>\n\n\n\n

This article will walk you through seven fundamental SQL statement examples that are pretty much standard across most major Relational Database Management Systems (RDBMS<\/a>s).<\/p>\n\n\n\n\n\n\n\n

The SELECT<\/code> Statement: Retrieving Data<\/h2>\n\n\n\n

The SELECT<\/code> statement<\/a> is used to query data from one or more tables. It’s the most common SQL statement, and it’s the foundation for data retrieval.<\/p>\n\n\n\n

Example:<\/p>\n\n\n\n

SELECT first_name, last_name, email\nFROM customers\nWHERE country = 'USA';<\/code><\/pre>\n\n\n\n
This query selects three columns from the customers<\/code> table. Specifically, it selects the first_name<\/code>, last_name<\/code>, and email<\/code> columns. The WHERE<\/code> clause filters the results to just customers from the USA.<\/p>\n\n\n\n
The INSERT<\/code> Statement: Adding New Records<\/h2>\n\n\n\n
The SQL INSERT<\/code> statement<\/a> is used to add new rows of data into a table.<\/p>\n\n\n\n
Example:<\/p>\n\n\n\n
INSERT INTO products (product_name, price, category)\nVALUES ('Wireless Mouse', 29.99, 'Electronics');<\/code><\/pre>\n\n\n\n
When we use the INSERT<\/code> statement, we specify the table name, followed by the column names in parentheses. We then follow this up with the VALUES<\/code> clause, which consists of the VALUES<\/code> keyword followed by the actual values to insert into the respective columns, also enclosed in parentheses.<\/p>\n\n\n\n
So with that in mind, we can see that the above statement inserts a new product into the products<\/code> table, specifying values for the product_name<\/code>, price<\/code>, and category<\/code> columns.<\/p>\n\n\n\n
The UPDATE<\/code> Statement: Modifying Existing Data<\/h2>\n\n\n\n
The UPDATE<\/code> statement<\/a> is used to modify existing records in a table.<\/p>\n\n\n\n
Example:<\/p>\n\n\n\n
UPDATE employees\nSET salary = salary * 1.1\nWHERE department = 'Sales' AND years_of_service >= 5;<\/code><\/pre>\n\n\n\n
This query increases the salary by ten percent for all employees in the Sales department who have been with the company for five or more years.<\/p>\n\n\n\n
The DELETE<\/code> Statement: Removing Records<\/h2>\n\n\n\n
The DELETE<\/code> statement is used to remove one or more rows from a table.<\/p>\n\n\n\n
Example:<\/p>\n\n\n\n
DELETE FROM orders\nWHERE order_date < '2023-01-01' AND status = 'Canceled';<\/code><\/pre>\n\n\n\n
This statement deletes all canceled orders placed before January 1, 2023, from the orders table.<\/p>\n\n\n\n
Be very careful when deleting data. If we omit the WHERE<\/code> clause it will delete everything in the table. The thing about SQL is that the less specific we are, the more data that is affected. <\/p>\n\n\n\n
The CREATE TABLE<\/code> Statement: Defining a New Table<\/h2>\n\n\n\n
The CREATE TABLE<\/code> statement<\/a> is used to create a new table in the database. We specify the table name, followed by its definition inside parentheses. The definition consists of column names, their data types, and any constraints to be placed on the column. There are other things we can do too, but let’s not get ahead of ourselves.<\/p>\n\n\n\n
Here’s a basic example of creating a table:<\/p>\n\n\n\n
CREATE TABLE students (\n    student_id INT PRIMARY KEY,\n    first_name VARCHAR(50),\n    last_name VARCHAR(50),\n    date_of_birth DATE,\n    enrollment_date DATE,\n    major VARCHAR(100)\n);<\/code><\/pre>\n\n\n\n
This statement creates a new table called students<\/code> with six columns. We can see all the columns listed inside the parentheses along with their data types. The first column has a primary key constraint<\/a>, which ensures that this column contains a unique identifier for the table. It’s usually a good idea to include a primary key in your tables. A primary key can consist of a single column or multiple tables combined (to form a composite primary key<\/a>).<\/p>\n\n\n\n
The ALTER TABLE<\/code> Statement: Modifying Table Structure<\/h2>\n\n\n\n
The ALTER TABLE<\/code> statement<\/a> is used to add, modify, or delete columns in an existing table.<\/p>\n\n\n\n
Example:<\/p>\n\n\n\n
ALTER TABLE products\nADD COLUMN description TEXT;<\/code><\/pre>\n\n\n\n
This statement adds a new column called description<\/code> to the existing products<\/code> table. We can also use the ALTER TABLE<\/code> statement to drop columns or change their definitions.<\/p>\n\n\n\n
The JOIN<\/code> Clause: Combining Data from Multiple Tables<\/h2>\n\n\n\n
In SQL, JOIN<\/a><\/code> clauses can be used to combine rows from two or more tables based on a related column between them. While joins aren’t actually SQL statements themselves, they do allow us to create more sophisticated queries that pull data from multiple places across our databases. <\/p>\n\n\n\n
Example:<\/p>\n\n\n\n
SELECT o.order_id, c.customer_name, p.product_name, o.quantity\nFROM orders o\nJOIN customers c ON o.customer_id = c.customer_id\nJOIN products p ON o.product_id = p.product_id\nWHERE o.order_date >= '2024-01-01';<\/code><\/pre>\n\n\n\n
This query retrieves order information along with customer and product details for all orders placed since January 1, 2024. It demonstrates an INNER JOIN<\/a><\/code> between three tables: orders<\/code>, customers<\/code>, and products<\/code>. <\/p>\n\n\n\n
We know it’s an INNER JOIN<\/code> because, when we omit the INNER<\/code> part, it automatically becomes an INNER JOIN<\/code>. There are other join types, such as the LEFT JOIN<\/a><\/code>, the RIGHT JOIN<\/a><\/code>, the FULL OUTER JOIN<\/a><\/code>, the CROSS JOIN<\/a><\/code>, the NATURAL JOIN<\/a><\/code>, and the SELF JOIN<\/a><\/code>.<\/p>\n\n\n\n
See my SQL Joins Tutorial<\/a> for an introduction to the various join types, along with examples of each.<\/p>\n\n\n\n
Tips for Writing SQL Statements<\/h2>\n\n\n\n