Hi!
I bought Sams Teach Yourself SQL in 24 hours. There are some exercises that ask you to first download Oracle 10g Express edition, which is no longer listed as an available download, so I picked 11g Express edition. I downloaded the program and entered "system", then a password.
To set up your test database, the instructions tell you to navigate to the administration home page at http://127.0.0.1:8080/apex, which I did. It then asks you to log into the system using system as the username and the password that I set up during the installation. Then, from the administration screen, you can select SQL, SQL Commands, and Enter command. In the command window input the following command and click run: create user canaryairlines identified by canary_2015.
However, when I navigate to that webpage, it asks for a workspace, and since I haven't yet created one, it won't allow me to get past that without entering a workspace. I can't seem to get to the administration page to enter this SQL code to create it. On that webpage, towards the bottom, there's an administration link, which does not work when I type in my username (system) and password. I went to create application express workspace, but I didn't want to create a workspace that way, I wanted to enter the SQL as the book shows. I can find nowhere to enter any SQL to run this command.
I am a basic, basic beginner (as you can probably tell!!) and can't figure out what I am doing wrong. Can anyone help, or does anyone have this book (it says copyright 2016) and can let me know what I'm doing wrong based on your interpretation of it? Thanks in advance!!!