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
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
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
- Data Preview
- Data Mapping
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