Steps to install SQLITE 3 on windows and and create a table.

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



(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

Step 2

To add parameters to the table, enter the command

INSERT INTO name (id, name, model)

VALUES (1, 'Toyota', 'corolla');

Step 4

To add new column

ALTER TABLE cars

ADD COLUMN vehicle-type TEXT;

Step 6

Finally to delete from the table

DELETE FROM cars

WHERE vehicle_type IS NULL

SELECT * FROM cars

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.