Creating the Workspace in Oracle

A free video tutorial from Imtiaz Ahmad
Senior Software Engineer & Trainer @ Job Ready Programmer
Rating: 4.5 out of 5Instructor rating
12 courses
397,599 students
Creating the Workspace in Oracle

Learn more from the full course

The Complete Oracle SQL Certification Course

Don't Just Learn the SQL Language, Become Job-Ready and Launch Your Career as a Certified Oracle SQL Developer!

16:27:26 of on-demand video • Updated November 2022

Become Job Ready to Start Contributing as a Database Developer Day 1
Program in the SQL Language to Solve a Variety of Database Problems
Code along with me to PRACTICE and IMPLEMENT everything you learn
Become a SQL Ninja and Understand How the Oracle Database Works
MASTER the Content Required to Pass the Oracle 1Z0-071 Database SQL Exam
Obtain the Skills that are Necessary to Land a Job as a SQL Developer
Have the Ability to Solve any SQL Problem
English [Auto]
Hi there. In this lesson, we're going to get up and running with our development environment and we're going to be using this tool called Apex, which is owned by Oracle. And it's basically a place where you get this virtual database where you can just practice your SQL commands right in your browser. So you're going to need to have Internet access. So as long as you have Internet access and you want to practice SQL, you can log in to Apex and I'll show you how to set that up right now. So you need to navigate over to this website, which is Apex Dot, Oracle slash, n slash, learn slash getting started. And let me just actually Google this for you so that you know exactly where to go if you don't have the link, if you just type in Oracle Apex. The first link right here. Click on this. Apex oracle dot com. This is the main page, right. And then you click on Get Started for Free. And here is that link that I spoke about apex oracle dot com slash n slash learn slash getting started. And when you get to this page, there's a couple of options. There's this Oracle free cloud account that you can set up. You don't need to do that. You go further down and you click on request a free workspace. This is what you need to click on this second option right here. So click on this. And here is where you set up your workspace. And so I'm going to give a name. I'll just say, Taz, man, I already have an account, so I'm simulating how to create one right now. And so the email address. So I'll just use another email address that I have and then the workspace name. Notice it says This workspace name uniquely identifies your development environment and is used when signing in. So this needs to be a unique workspace, right? So you cannot have the same workspace name as I have. It needs to be something totally different. So what I'm going to do is I'm just going to I'm just going to call it Taz, underscore man, underscore mine. And yours should be totally different. Okay, so let's click on next and then it gives some questions, sort of a survey. Are you new to Oracle Express? Let's say yes. Do you plan to use this workspace for university class training? Yes. And then click on next. And then here's where you give some kind of justification. Learning for Oracle certification. Click on next. And here's the guidelines. You want to make sure you read this this agreement. Click on I accept the terms and just click next. And here is the confirmation page where you can now submit the request for your own virtual workspace, your own database on online that you can access. So I'm just going to click on Submit Request and there you go. Workspace requested. You will receive an email to activate your workspace once this request has been approved. So now I'm going to visit my inbox in Gmail and I should have that link. So let me go ahead and log in there. And now I'm logged into my Gmail account. Notice we got an email from Oracle Application Express and it says Action Required. So click on this email and you should have say notice. It says workspace request approved. So now we can officially create the workspace we and notice the environment. This is the you know, just keep a record of this. You have it in an email. So let's click on Create Workspace. And it's now creating the workspace. Workspace successfully created. Click on continue to sign in screen and here is where you provide a new password. And the username is going to be the email address that you used for this. And the password could be anything. When you enter that information, click on Apply Changes. And there we go. We're logged in and that's it. That's pretty much all it takes. Most of our most of the time will be involved with this SQL Workshop section. When you log into Oracle Apex like we just did, you click on SQL Workshop and you click on SQL Commands, click here, and this is where you're going to be typing up all of the commands in this course, all of the SQL. And you're going to basically master this technology using this course. Hopefully, that's the idea, and I'm sure you can do it and I'm going to help you get there. Notice, if you want to log out, you click on this button on the top right before logging out. I just want to remind you that your workspace name is this. I chose this. You should have a different workspace name and the email account is also shown here. Okay, so let me sign out and let's go to return to sign in page. You can save this page in your favorites so that you don't have to figure out how to get here every time. Your email also tells you how to get to that place, which is right here. Environment Apex Oracle plz slash apex. So if you click here it'll take you to the same page and you need to provide your workspace name, right? So the workspace name that I had chosen was Taz Mann Mine, and the username is going to be the email address that I was working with. Right? And so that's going to be this horrific email address that I have here. And the password is going to be whatever I chose. So of course, I'm going to enter it here. And once you see the green lights here, you can click on, sign in, and you'll be able to access that same account. And that's it. That's all that's required to set up your environment and work with all the lectures in this course. I need you to be typing all of the commands with me and running them and feel free to change the commands around, experiment with them. Whatever I type on the screen. You also need to be typing on your screen to get the full practice that you need. Because practice is everything in in SQL as well as any any coding language you need to practice. Otherwise you will not learn a thing no matter what you do. If you don't get the practice. So literally copy everything that I type, run it in your own environment, change things around, maybe change the commands and you know, try to go beyond what I'm doing. If you want to experiment with changing the names and stuff, you'll you're going to run into the commands. I want you to run into errors and experience this because that's how you really learn. And so don't be afraid to experiment with this and enter the commands that we explain in this course. All right. So with that being said, I'm to wrap it up. Thanks for watching. I'll see you in the next lecture.