Скачать или смотреть Oracle Live SQL | Practice Oracle SQL Online | No Installation Required

Oracle Live SQL | Practice Oracle SQL Online | No Installation Required
MySQL Download & Installation :-    • How to Download MySql & Install free on Wi...  

Hello friends welcome back to TEK Solutions in our last video we have seen that how to install MySQL on our laptop if you have not watched that video please find the link in the description below or you can browse our Channel so in this video if you don't want to install the MySQL and still you want to do some SQL practice or you want to learn SQL we have another way where we can use the Oracle cloud for that we need to create a cloud account on Oracle and it will give us the some sample schemas where we can fire our queries we can execute our queries even it gives us opportunity to create some tables on our own schema and we can create own tables we can create our own relationships and everything so let's see how to create that account and how to use that tool it has some drawbacks definitely but what are all those we will see in this video next so first of all just open live sql.oracle.com I'll provide the link in the description below here you can see start coding now so now you need to create your own account here by using the create account option just fill up all these details and once you are done with this all the details it will create a account for you once that is done we can simply sign into our account once you are signed in this is the space worksheet SQL worksheet where we can execute our own queries so let's understand this tool this is on a cloud definitely and on this navigation click on this navigation we will see the different options so this SQL worksheet will give us option to execute the sqls how to do that and all I'll just let you know my sessions will keep your all the sessions uh history here so this is and these are the schemas so now by default we are on my my schema means our own schema otherwise it will list all the schemas which which are available to us for the query we will try to query some of the tables from one of this schema from here then my scripts it's something you can save your own Scripts and keep it with you tutorials it's very good thing is that you can learn the learn some coding sequels from here by adding the tutorial to here and code Library code library is simple this is a available freely you can simply click on the library and copy those needed if you want to create some tables or something you can just copy it from here from the code Library so let's go back to the SQL worksheet here now we don't have any tables in our schema that's why it won't show us anything but let's see let's say we have a schema here HR schema and if you click here it will list all the tables available in the HR schema so let's try to query one of the table here so countries so go back to SQL worksheet select star from countries let's execute this query run this query uh sorry I think that spelling has some issues Co even tries here we are on our own schema that's the reason we need to qualify it with the HR schema HR dot countries so let's run it you can see now see we have the query created here so we are actually executing the query on HR HR schema table now let's say we want to create our own table so let me create one table create table ABC I'm just giving some random name ABC and one column is the column and its type is integer now let's execute this one let me select this and only execute that one otherwise it will execute all the statements table is created now let's select star from ABC let's run this query so actually it has no record so let's try to insert something here insert into ABC values don't worry if you don't know all this um statements SQL syntax um I am going to

Oracle Live SQL | Practice Oracle SQL Online | No Installation Required

CHAPTERS
0:00 | Introduction
0:36 | Oracle Live Account Setup

Search
oracle, oracle database, oracle live sql, live,sql, install oracle free, live sql, sql tutorial, sql for beginners, oracle tutorial, mysql tutorial, oracle training, mysql training, oracle for beginners, mysql installation, free oracle installation, sql queries training, nandkishor choudhari, nks entertainment, tableau queries, oracle cloudworld 2022, oracle cloud, oracle sql, oracle, oracle database, oracle live sql, live,sql, install oracle free, live sql, sql tutorial, sql for beginners, oracle tutorial, mysql tutorial, oracle training, mysql training, oracle for beginners, mysql installation, free oracle installation, sql queries training, nandkishor choudhari, nks entertainment, tableau queries, oracle cloudworld 2022, oracle cloud, oracle sql, oracle, oracle database, oracle live sql, live,sql, install oracle free, live sql, sql tutorial, sql for beginners, oracle tutorial, mysql tutorial, oracle training, mysql training, oracle for beginners, mysql installation, free oracle installation, sql queries training, nandkishor choudhari, nks entertainment, tableau queries, oracle cloudworld 2022, oracle cloud, oracle sql,