How To Install Sql On Windows 10

SQLite offers a lot of unlike installation packages, depending on your operating systems. It also offers a lot of APIs for a broad range of programming languages.

In this tutorial, you will learn-

• Download & Install SQLite Package Installer
• SQLite Studio – Manager and Assistants
• Introducing Sample database

Download & Install SQLite Package Installer

Installation packages bachelor for Windows 10 users:

From the SQLite official website in the download section. The following screenshot allows you to download dissimilar SQLite's installation packages for Windows:

The control line beat out program:

The highlighted download bundle is chosen the Command-Line Plan (CLP). CLP is a command line application that let yous access the SQLite database direction system and all the features of the SQLite. Using CLP, you lot can create and manage the SQLite database. And information technology is the tool that we will use throughout the tutorial.

• 32-fleck DLL(x86): The SQLite Database system cadre library for x86 platforms.
• 64-chip DLL (x64): The SQLite Database system cadre library for x64 platforms.

Installing the Command-Line Program (CLP) on your machine:

In the following steps, you will find the steps for how to install the Control-Line Program (CLP) on your automobile:

Pace 1) Download the highlighted download package from the previous epitome to your PC. Information technology is a "zip" file.

Step 2) Extract the cypher file. You lot will find the "sqlite3.exe" in the extracted file as following:

Step three) Open My Calculator, and double-click the partition "C" to navigate to it:

Step 4) Create a new directory "sqlite":

Step five) Copy the file "sqlite3.exe" into it. This is what nosotros will apply through the tutorials to run SQLite queries:

However, there are some other packages for unlike purposes. They are not required. But you lot might need information technology if you are using a dissimilar OS than Windows yous can go the Linux or Mac OS version of SQLite.

Also, y'all can get the documentation or source code from in that location if you wish. You lot can besides get the API for Windows Phone 8 or .Net and other programming languages.

Hither are some other different packages for different purposes:

• The Source Code and some culling Source Code Formats – The complete source code that made up the SQLite.
• The documentation – The documentation of the SQLite as HTML pages. It is the same online documentation, but downloadable as HTML page so that yous can open them offline.
• Precompiled Binaries for Linux.
• Precompiled Binaries for Mac Os 10 (x86).
• Precompiled Binaries for Windows Phone 8 – SDK and components to develop an awarding for Windows Phone eight that uses SQLite databases.
• Precompiled Binaries for Windows Runtime – SDK and other components for developing an application to connect to SQLite databases for the Windows Runtime platforms.
• Precompiled Binaries for .Internet – these are some set of DLLs and .NET libraries that you can use them from .NET application to connect to SQLite databases.

SQLite Studio – Manager and Administration

At that place are lots of SQLite direction tools that make working with SQLite databases easier. Instead of creating and managing databases using a command line, these tools provide a set of GUI tools that allow you lot create and manage the database.

The official SQLite website has dozens of such tools listed; you tin view them from here: SQLite Management Tools. Here is the recommended 1

SQLite Studio: It is a portable tool that doesn't require an installation. It supports both SQLite3 and SQLite2. You lot can hands import and export information to various formats like CSV, HTML, PDF, JSON. Its open up source and supports Unicode.

Introducing Sample database

In the post-obit steps, we will create the sample database that we will use throughout the tutorials:

Pace 1) Open a text file and paste the following commands into it:

CREATE Tabular array [Departments] (       [DepartmentId] INTEGER  Non Zippo Chief Cardinal,       [DepartmentName] NVARCHAR(50)  NULL   );   INSERT INTO Departments VALUES(1, 'Information technology'); INSERT INTO Departments VALUES(2, 'Physics'); INSERT INTO Departments VALUES(iii, 'Arts'); INSERT INTO Departments VALUES(4, 'Math');  CREATE TABLE [Students] (       [StudentId] INTEGER  Principal KEY Not Zero,       [StudentName] NVARCHAR(50) Not NULL,       [DepartmentId] INTEGER  NULL,      [DateOfBirth] DATE NULL,     Foreign KEY(DepartmentId) REFERENCES Departments(DepartmentId) );   INSERT INTO Students VALUES(1, 'Michael', 1, '1998-10-12'); INSERT INTO Students VALUES(2, 'John', 1, '1998-10-12'); INSERT INTO Students VALUES(3, 'Jack', i, '1998-ten-12'); INSERT INTO Students VALUES(4, 'Sara', 2, '1998-10-12'); INSERT INTO Students VALUES(5, 'Sally', ii, '1998-ten-12'); INSERT INTO Students VALUES(6, 'Jena', NULL, '1998-ten-12'); INSERT INTO Students VALUES(seven, 'Nancy', 2, '1998-10-12'); INSERT INTO Students VALUES(8, 'Adam', 3, '1998-ten-12'); INSERT INTO Students VALUES(9, 'Stevens', three, '1998-x-12'); INSERT INTO Students VALUES(10, 'George', Zip, '1998-ten-12');  CREATE Table [Tests] (     [TestId] INTEGER Not Naught Primary KEY,     [TestName] NVARCHAR(50) NOT Nix,     [TestDate] Date NULL ); INSERT INTO [Tests] VALUES(i, 'Mid Term Information technology Examination', '2015-ten-18'); INSERT INTO [Tests] VALUES(2, 'Mid Term Physics Exam', '2015-10-23'); INSERT INTO [Tests] VALUES(three, 'Mid Term Arts Exam', '2015-10-10'); INSERT INTO [Tests] VALUES(4, 'Mid Term Math Test', '2015-10-xv');  CREATE Tabular array [Marks] (       [MarkId] INTEGER Not NULL Main KEY,     [TestId] INTEGER Not NULL,     [StudentId] INTEGER  Non Cipher,       [Marker] INTEGER  NULL,     Strange KEY(StudentId) REFERENCES Students(StudentId),     FOREIGN Key(TestId) REFERENCES Tests(TestId)  );    INSERT INTO Marks VALUES(1, 1, ane, 18); INSERT INTO Marks VALUES(2, ane, two, 20); INSERT INTO Marks VALUES(3, 1, iii, 16); INSERT INTO Marks VALUES(4, 2, four, 19); INSERT INTO Marks VALUES(5, 2, 5, 14); INSERT INTO Marks VALUES(6, 2, 7, 20); INSERT INTO Marks VALUES(7, 3, 8, xx); INSERT INTO Marks VALUES(eight, 3, 9, 20);

Pace two) Save the file as "TutorialsSampleDB.sql" in the following directory "C:\sqlite".

Step three) Open the Windows Command Line tool (cmd.exe) from the start menu, type "cmd" and open up it.

Step 4) It volition open in the default path, y'all need to navigate to the "C:\sqlite" folder we had created earlier in this tutorial past the following command "cd "C:\sqlite":

Stride five) Write the following control,

sqlite3 TutorialsSampleDB.db < TutorialsSampleDB.sql

The control should be completed successfully, and yous should see no output after that command as the following screenshot:

Footstep half dozen) Y'all should at present be able to meet the database file "TutorialsSampleDB.db" created in the directory "C:\sqlite":

Source: https://www.guru99.com/download-install-sqlite.html

Posted by: starkficiones99.blogspot.com

Share this post