How to install SQL Developer on Windows 10 | Create Database connection using SQL Developer Tutorial

hi in this video tutorial we will discuss all your problem which include how to install oracle sql developer how to connect sql developer to your database how to create a new connection and how to unlock the hr schema in oracle 11g so for the same you need to download the oracle sql developer and just go on your browser and type oracle sql developer after that just go on the first link which operating system you need to download so just click here on the download so here you can download for mac uh windows 32 mac os linux so i'm going to download for windows 64-bit so click on download and when you are going to click it is going to accept all the license agreement and click on download so at the first time it will ask you to login if you haven't created a account so you can just create an account for the oracle and here you can just put up audio details like email id phone number and everything and phone number can be anything you can put it a dummy phone number and the company name can also be dummy so only the thing is the email id should be correct and apart from that everything can be fine i'm going to log into my account and i'm going to pause the video when i click on the sign in so see once you sign it from the sql developer will get started and it will be downloaded in a system so it's a large file so it will take some time now the file has been downloaded and you can check the file in the download section so in the download section we got the file that is a zip file so either you can use any of the system like um 7-zip or you can extract the file using the winrar so i'm going to unzip it right now so you can also do it with the help of a winrar in your system and the file will be extracted here so only to install sql developer just you need to extract the file nothing else after the file has been extracted so go to the folder and at the bottom you will find out our application to run your sql developer application so double click here and the application will be started so after your application gets started you need to make a connection so after a successful extracting of file you can run the application after running the application you can start making a connection with your oracle sql developer so on the right hand side everything is related to oracle and on the left and now first of all we will be login to the system administrator or a sys user okay so since user is a system administrator and we are going to create a uh so first click on the plus sign on the left hand panel just type name as cis as says dba means you wanted to log in as a css dba put the password says as says dba put the password which you have given for the installation if you don't know how to install oracle 11g you can refer the above link so just put the password which you have given for the root user or the system user and make sure you come in the service name and just you put capital xe okay xe means express edition and just click on test if you click on test and you get success in the last means here so that means you have successfully created a connection with the system administrative user so this is the user who will be responsible to create a new user because it has all the permission it has all the privileges so click on connect and you see the connection has been established now you have to click on uh this is ssdbs so our worksheet will be open and in this worksheet we will be writing down some commands to see whether the user has been the hr user or the hr schema has been unlocked or not so for the first thing you have to say alter user hr account unlock this is the first command that you have to run that is alter user hr account unlock and run it so you see at the bottom you get alter user hr account altered so that means we have unlocked the hr user successfully after that now the one thing is how to run this particular command if you are interested to run this command you have to select this whole line and you can click on this screen icon okay otherwise you can also use a shortcut key like put your cursor on the same line and put control enter so it will execute this particular command again now you need to set the password for the hr user that you have created now to set the password so just again run a command alter user hr so i am interested to alter the hr user then say identified by hr so means you have to set the password of this hr user to hr only so the user name is hr and the password will be hr and run this command using the control enter and you see the user hr account has been altered now we have to create a connection for this hr user and now we can login to this hr file looking at the demo schema that we have so give a name as any name that you like hr user make sure the username is hr and the password is again in hr then go on the service name and again put capital xc and click on test so you see success so that means you have successfully unlocked the hr schema and you have set the password for it and in the last click on connect so when you click on connect every time a new worksheet will be created and you can see the hr connection has been established and if you click on the plus sign you can see the lot of tables the filters the view that you have on the table so you see i have some dummy tables i have some database so everything is there what are the views that i have created already that are present so might be in your system the views and other things might not be present but you can create it later on so that is how we create the connection we we unlock the hr user and we made the connection with it now in case you are interested to run a query so you can run any query to see whether the things are working fine so you can select all the data from the employees table to see whether the employees table is present or not and make sure you get the output so this is how we unlock the user if you think okay if you have any issues you can put that issues in the comment and i hope everyone has enjoyed this video so kindly like and subscribe to our video youtube channel for more updates in the future [Music] you

Channel: REGex Software

Views: 31,081

Keywords: how to install sql developer on Windows 10, how to install sql developer in windows 10, oracle sql developer, sql developer, download sql developer, install sql developer, how to install sql developer, sqldeveloper, installing sql developer, oracle tutorial for beginners, oracle, oracle sql developer 21.4.1 installation, yt:cc=on, sql developer tutorial for beginners, oracle database, how to download sql developer on windows 10, how to install sql developer in windows

Id: te2JSDKFnHM

Length: 7min 33sec (453 seconds)

Published: Sun Mar 13 2022