in this video i'll show you how to set up and run sqlite on visual studio code by the way if you want to master sqlite then i'm planning to create a course on sqlite so what you can do is you can just subscribe to our channel so that if i release that course you will get notification so without wasting much time let's get started [Music] okay the first thing which you should be doing is installing vs code if you do not have it go to code.visualstudio.com and depending on your operating system you can download vs code after you download during installation make sure that you check all these four options all right now what i've done is i've created a folder on which i will be having my sql file and my database for this the folder name is for hyphen sqlite you can give any other name as per your choice just give right click and click on open with code so that i will open this particular folder in vs code now you see that i have this particular folder that is for sqlite just click on this plus button to create a new file and i'll just give the name of the database on which i will be having all my tables so the name i can just give for example mydb dot db so dot db is for database right so this extension is important and you can give any particular name of the database in my case i have given mydb if you want you can give any other name again what i'll do is i'll just click on this plus button and i'll just create a sql file on which i mean using which i will create some queries so i'll just give for example my sql dot sql so dot sql is the extension for sql file just give enter and now what i'll do is first i will install a particular extension and i'll just go to extensions here i'll just search for sqlite and just wait for some time you see i have this particular extension the first one that is sqlite by lxcv just click on this install button if you have not installed so at this moment it is already installed on my vs code so let me just show you if i just uninstall it and you see you will be having options that is install just click on this install button if you have not installed it every time you install a particular extension make sure you reload your vs code for that just open your command palette for which you can just give shift ctrl np so this is the shortcut and you just search for reload and you see the first one it is developer colon reload window so if you just click on this it will reload your vs code and now you just open your sql file so the sql file is mysql.sql and first i will create a table so for that i'll just give create table and you can give a particular name of the table so let's say that i want to create a table for employees so i'll just give emp and i'll be having let's say three columns employee id employee name and let's say email all right and i'll just give create table table name employee id and this will be my integer field and it will be not null right and i'll also make this as primary key all right it is better i'll just make it as capital later okay so actually sql is not case sensitive but it is better to give in capital letters so all the keywords if you give in capital letters it will be a better format all right and employee name will be text field so i'll just give text not null i also want to make sure that this particular field is also not containing null values and email i'll just say not null right and to run a particular query first i'll just save this file so i'll just give control s to save this and i'll just open the command palette again and i'll just give sqlite and you see it is saying sqlite run query if i just click on this sqlite run query now it is asking me to choose database and we have created this particular database that is mydb.db select this and it is going to create this table you see towards your right it has created this table and let me do one thing now what i'll do is i'll just comment it out so i'll just use the shortcut that is control and forward slash and now this time what i'm gonna do is i'll just add some records into this table so i'll just give insert okay so insert into emp and i'll just give employee id comma employee name comma email and i'll just give values and i'll just add employer id for example one employee name for example i'll just give sam and email i'll just give test one at the rate test dot com so this is the dummy name i have given just save this file and to run it just give right click and you can just give control shift key or you can open the command palette and you can just give run query all right so i'll just give run query here and now again i'll just comment it out right so let me just comment it out and i'll just give select all from emp and let me just save it and i'll just run it again and you see that i have one record that is one sam and test one at the red test.com if you want you can add more number of records so i'll just add more number of records here so i'll just give now this time two and instead of sam i'll just give tom and i'll just give test test2 let me just save it and if i just run it now again let me just comment it out and again let me just uncomment the select statement save it click on run and you see i have two records so in this way you can create tables in your sqlite database and if i just click on this particular option now you see that we have mydb and if you mysql.sql here just give right click and you have lot of other options for example open database and you can also create a query directly like new query and so on right and at the bottom you see if i just show you actually if i just open this particular database now you see at the bottom i have mydb.db and you can see that the name of the table is emp so at this moment it contains one table if you add multiple tables it will show up here and if i just click on this particular table it is showing that it has three columns employee id which is integer employee name which is text and then we have email so just give right click and you can also say show table you click on this and it will show the table so first let me just close this i will also close this as well and let me just close this as well now you see if i just give right click and click on show table it will show the table so you see that this is a table and this contains this particular record so you see we have used the sqlite in visual studio code so that's it in this video if this video was helpful to you please click on the like button subscribe to our channel and make sure that if you use the coupon code use it seriously otherwise you are wasting someone's else opportunity in the same way i have created a lot of videos in which i have shown lot of other programming languages which are used in visual studio code and the next video which i am going to publish is html and if you want to access that premium html course for free then please make sure that you use the coupon code and only the first thousand students will be able to access that premium course for free so make sure you subscribe to our channel and you can also see the description of the video so that you will get more updates regarding that particular video and this particular video [Music] you