Creating the Workspace in Oracle

A free video tutorial from Job Ready Programmer
Senior Software Engineers and Trainers
Rating: 4.5 out of 5Instructor rating
13 courses
483,382 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 December 2023

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 [CC]
Instructor: Hi there. In this lesson, we're gonna get up and running with our development environment, and we're gonna 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 gonna need to have internet access, okay? So as long as you have internet access and you wanna practice SQL, you can log in to APEX, and I'll show you how to set that up right now, okay? So you need to navigate over to this website, which is apex.oracle.com/en/learn/getting-started, okay? 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.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.com/en/learn/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. Okay? 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 gonna 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, okay? It needs to be something totally different. So what I'm gonna do is I'm just gonna, I'm just gonna call it TAZ_MAN_MINE. And yours should be totally different. Okay? So let's click on Next. And then it's 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. Okay? Click on Next. And here's the guidelines. You wanna make sure you read 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 online that you can access, okay? So I'm just gonna click on Submit Request. And there we go, Workspace Requested! You will receive an email to activate your workspace once this request has been approved. So now I'm gonna visit my inbox in Gmail, and I should have that link. Okay? 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, (indistinct) 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 the 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, okay? And the username is gonna be the email address that you used for this. And the password is, could be anything. When you enter that information, click on Apply Changes. And there we go, we're logged in. Okay? And that's it, that's pretty much all it takes. Most of the time we'll be involved with the 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 gonna be typing up all of the commands in this course, all of the SQL, and you're gonna basically master this technology using this course, hopefully. Okay? That's the idea. And I'm sure you can do it. And I'm gonna help you get there. Notice, if you wanna log out, click on this button on the top right. Before logging out, I just wanna 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 favorite 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, pls/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_man_mine, okay? 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 gonna 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. Okay? 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 SQL as well as 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, experiment with changing the names and stuff, you're gonna 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 explained in this course. All right? So with that being said, I'm gonna wrap it up. Thanks for watching. I'll see you in the next lecture.