Practicing some standard SQL commands in SQLite over a XAMPP Server.

SQLite is a database engine. It is software that allows users to interact with a relational database. In SQLite, a database is stored in a single file — a trait that distinguishes it from other database engines. This fact allows for a great deal of accessibility: copying a database is no more complicated than copying the file that stores the data, sharing a database can mean sending an email attachment.

What is a xampp server?How it installed? XAMPP (XAMPP Apache + MariaDB + PHP + Perl) is a free and open-source cross-platform web server solution stack package developed by Apache Friends, consisting mainly of the Apache HTTP Server, MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages. The download link for the Xampp server (Windoes)- xampp-win32-7.2.1-0-VC15-installer.exe

Downloading sample SQLite Database.The sample SQLite database used for the practise purpose in this repository is 'Chinook.db'. The link to download the database and the database diagrams is here- https://www.sqlitetutorial.net/sqlite-sample-database/. The downloaded database can be copied to to database folder under the htdocs folder inside xampp folder on your computer. C:\xampp\htdocs\db.

what is SID.php? how to install it. command to start xampp server with SID.php->just open your browser and type- http:https://localhost/SID/sid.php- press enter-locate the Chinook database and then start trying out the commands listed in the file attched with this repository. Happy Learning !!