For an instructor lead, in-depth look at learning SQL click below.
In today’s data-driven world, SQL (Structured Query Language) is an essential skill. SQL is a standard language for managing data held in a Relational Database Management System (RDBMS) or for stream processing in a Relational Data Stream Management System (RDSMS). SQL is crucial for creating, modifying, and extracting data from databases. This tutorial will guide beginners through setting up and querying a database.
Setting Up a Database
The first step in utilizing SQL is establishing a database. Here’s a simple example of SQL code that sets up an “Employees” table:
|
1 2 3 4 5 6 7 8 9 |
CREATE TABLE Employees ( ID INT PRIMARY KEY, name VARCHAR (20), birth_date DATE, role VARCHAR (20), salary DECIMAL (18, 2) ); |
This SQL code creates a table named “Employees” with five columns: ID, name, birth_date, role, and salary. Each column has a specified data type – INT,
VARCHAR, DATE, VARCHAR, and DECIMAL respectively.
Inserting Data into the Database
Now that you have a database and a table ready, let’s insert some data into the “Employees” table:
|
1 2 3 4 |
INSERT INTO Employees (ID, name, birth_date, role, salary) VALUES (1, 'John Doe', '1980-01-01', 'Manager', 55000.00); |
This SQL command adds a record into the table. The values in the record correspond to the columns listed after the table name.
Retrieving Data from the Database
Now, if you want to retrieve that data, you’ll use a SELECT statement. The following SQL command will return all data from the “Employees” table:
|
1 2 3 |
SELECT * FROM Employees; |
The * means “all columns”. If you want to select only some columns, replace * with the column names, separated by commas. For example, to only retrieve employee names and salaries:
|
1 2 3 |
SELECT name, salary FROM Employees; |
Conclusion
To sum up, learning SQL can unlock vast potentials in managing, analyzing, and transforming data. The snippets provided here offer a quick look into setting up a database, inserting data, and retrieving it. The world of SQL has much more in-store, such as updating data, deleting data, and creating complex queries.