What is SQL?
SQL (Structured Query Language) is a standard programming language used to communicate with and manage databases. It is widely used to store, retrieve, update, and manipulate data in relational databases. SQL is essential for working with structured data organized into rows and columns.SQL is the backbone of many database systems like MySQL, PostgreSQL, Oracle Database, and Microsoft SQL Server.
What is SQL database?
A SQL database is a structured system for storing and managing data in tables using Structured Query Language (SQL). It organizes information into rows and columns, supports relationships between tables, and ensures data integrity with features like ACID compliance. Popular examples include MySQL, PostgreSQL, and Microsoft SQL Server, commonly used in applications like e-commerce, finance, and web development.
What is SQLITE 3
SQLite 3 is a lightweight, serverless, self-contained relational database management system. It is an updated version of SQLite, a widely used open-source database engine. Unlike traditional database systems, SQLite 3 does not require a separate server process, making it highly portable and simple to integrate into applications.
Key Features of SQLite 3:
1.Self-Contained: Entire database functionality is provided in a single library file.
2.Serverless: No need for a server process; the database is stored in a single file on disk.
3.Lightweight: Minimal setup and resource requirements.
4.ACID Compliance: Ensures reliable transactions with atomicity, consistency, isolation, and durability.
5.Cross-Platform: Works on various platforms, including Windows, macOS, Linux, and mobile operating systems.
Steps to install SQLITE 3
Step 1
Open your browser, search for SQLITE download and click and open the first link
Step 2
On the sqlite page, scroll down till you see Precompiled Binaries for Windows
Then, click on the third link to download sqlite 3 tools.
(wait for the download to complete)
Step 3
After downloading, create a new folder on your local c:/ drive, give it a name. Then move the downloaded file to the newly created folder and Right click on the zipped file and extract
(Note: image is after extraction)
Step 4
From the extracted file, Lauch the sqlite 3 application
How to create a table
Step 1
To create a table, enter the command
CREATE TABLE name of Table (
id INTEGER,
name TEXT,
model INTEGER
);
NOTE: the parameters depend on the number of rows and column you wish to create, here I will be creating a table of three columns and seven rows
Step 2
To add parameters to the table, enter the command
INSERT INTO name (id, name, model)
VALUES (1, 'Toyota', 'corolla');
Step 3
To show all Data, input the command
SELECT * FROM cars
Step 4
To add new column
ALTER TABLE cars
ADD COLUMN vehicle-type TEXT;
Step 5
To add data to the column
UPDATE cars
SET vehicle_type = 'salon'
WHERE id = 1
Step 6
To delete from the table
DELETE FROM cars
WHERE vehicle_type IS NULL
SELECT * FROM cars
Step 7
Finally to get the output of the table enter on the sqlite3 terminal
.headers on
.mode csv
.output cars.csv
Conclusion
In conclusion, SQL (Structured Query Language) is a standard programming language used to communicate with and manage databases and SQLite 3 is a lightweight, serverless, self-contained relational database management system. With the following simple steps and command we have downloaded sqlite 3 and create a table in it.
Top comments (0)