Post 1 of 2 – ADW

With my favorite team from my home town, the Milwaukee Bucks, leading the way and in first place in the NBA this season 2019-2020 I was curious about how this season was comparing to prior seasons.
In franchise history, they only have 1 lonely title and that was back in 1971!

Using a Dataset – via Basketball Reference
Season Totals by Player – All-time NBA statistics.
Also includes statistics for ABA + BAA players and seasons. https://www.basketball-reference.com/


Create ADW DB

First, I wanted to create an account that I could use with my own data, etc. And interested in the Always Free Tier to simply learn more

Create an account – https://www.oracle.com/cloud/free/
. ‘Start for free’
. Enter your information, etc.
. Get confirmation email that the account is created from Oracle Cloud

And away you go ..

Next is time to login and see what is there.
And onto Steps to create a database a part of Autonomous Data Warehouse

Create an Autonomous Data Warehouse Autonomous Database
. Click the BIG BLUE BUTTON ‘Create Autonomous Database’

Enter the basic information required
Choose a workload type
Choose a deployment type
Configure the database
Create administrator credentials
Choose network access
Choose a license type
– Show Advanced Options gives you the ability to add
Tag namespace (Oracle-Tags), Tag key (CreatedBy) and value
. Click ‘Create Autonomous Database’

Now time to get in and start loading data
. Click on the Display Name URL of the new database that was just created once the State shows as ‘Available’

Next, navigate to the ‘Tools’ tab
. Click on the ‘Open SQL Developer Web’ button

Use SQL Developer WebConnect with Built-in SQL Developer Web
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/sql-developer-web.html

Sign In with your Username and Password administrator credentials

In this case, I have the files locally so these are the steps that I followed
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-sqldeveloper-web.html#GUID-C06A4E05-CCD1-4241-A8FB-76A19F5F727F

Navigate the the Worksheet tab
Right-click the table that you want to load data
Go to ‘Data Loading’, ‘Upload Data…’

Choose the file and Follow 3 easy steps

  1. Data Preview
  2. Data Mapping
  3. Review
Step 1 of 3 – Data Preview
Step 2 of 3 – Table definition
Step 3 of 3 – Review
Step 3 of 3 – Review

Click ‘Finish’ and your data will begin the loading process

After a few brief moments, data is now loaded into the database

But just to make sure
Simple SELECT statement FROM the database created
AND THERE IS DATA!


Next post 2 of 2 OAC
– will take us over to the Oracle Analytics Cloud side