For an instructor lead, in-depth look at learning SQL click below.
Welcome, aspiring data adventurers! If you’re interested in dabbling in databases, wrestling with rows, or conquering columns, then this primer on SQL (Structured Query Language) is just for you. SQL is a staple in the toolkit of any data analyst or developer. In this post, we’ll journey through the basic concepts and commands to set you on your path to mastering SQL.
What is SQL?
SQL is a language engineered specifically for managing and manipulating databases. It allows you to communicate with a database to perform tasks like retrieving data, updating data, or creating and modifying tables.
Getting Started: Database and Tables
A database is like a big electronic filing cabinet. Inside this cabinet, your data is stored in separate ‘drawers’ or tables. Each table contains data about a particular type of object, such as customers or products.
To create a table in SQL, we use the CREATE TABLE command, like in the example below:
|
1 2 3 4 5 6 7 8 9 |
CREATE TABLE Employees( ID INT PRIMARY KEY, Name VARCHAR(30), Age INT, Address VARCHAR(255), Salary DECIMAL(18, 2) ); |
Basic SQL Commands
1. SELECT
The SELECT command allows you to fetch data from a database. You use it when you want to view data in the table. The basic syntax of a SELECT statement is as follows:
|
1 2 3 4 |
SELECT column1, column2,... FROM table_name; |
To select all columns, we use the “*”:
|
1 2 3 |
SELECT * FROM Employees; |
2. INSERT
The INSERT command is used to insert new data into a table. The basic syntax of the INSERT INTO statement can be either:
|
1 2 3 4 |
INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,...); |
For instance:
|
1 2 3 4 |
INSERT INTO Employees (ID, Name, Age) VALUES (1, 'John', 25); |
3. UPDATE
The UPDATE command is used to modify existing data within a table. The essential syntax for an UPDATE statement looks like this:
|
1 2 3 4 5 |
UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value; |
An example update can be:
|
1 2 3 4 5 |
UPDATE Employees SET Address = '123 Main St' WHERE ID = 1; |
4. DELETE
The DELETE command allows you to remove records from a table. Basic syntax is:
|
1 2 3 |
DELETE FROM table_name WHERE some_column = some_value; |
Example:
|
1 2 3 |
DELETE FROM Employees WHERE ID = 1; |
Remember, SQL is an incredibly powerful tool, and with great power comes great responsibility. So, be very careful when using the UPDATE and DELETE commands!
Conclusion
This is only just the beginning of your SQL journey. There’s so much more to learn, including commands like JOIN, GROUP BY, HAVING, and more complex SELECT queries. Don’t worry if it seems daunting right now – every master was once a beginner. Keep practicing and you’ll get there!