Skip to content

Instantly share code, notes, and snippets.

@ben-ng

ben-ng/1-README.md

Last active March 31, 2016 19:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ben-ng/dae910880301ee9830375ec754ba9eab to your computer and use it in GitHub Desktop.
Save ben-ng/dae910880301ee9830375ec754ba9eab to your computer and use it in GitHub Desktop.
Download ZIP
Test Spec
Raw
1-README.md

Tasks

Before you start

Depending on your assigned system, read the README-ORACLE.md or README-POSTGRES.md file.

You might need to configure user accounts and permissions to accomplish these tasks.

Tasks

Unless otherwise specified, accomplish these tasks using whatever method you see fit.

That means you can...

  • use a GUI
  • write code
  • copy snippets from Stack Overflow
  • Google for tutorials
  • call a friend

Just don't ask a fellow participant for help -- that would mess with the experiment!

  1. Create a new database table, customers with these columns:
    • Integer id (autoincrement)
    • String first_name
    • String last_name
    • Integer age
  2. Insert this data into the table
    • John, Smith, 23
    • Jane, Doe, 45
    • Andrew, Jackson, 87
  3. Write code that...
    1. Connects to the database
    2. Queries for the average age of the customers
    3. Prints the result
Raw
2-README-POSTGRES.md

PostgreSQL

Version 9.5 of PostGreSQL has been installed

Authentication Details

  • Username: postgres
  • Password: pdb

Configuration & Administration

Look at the "PostgreSQL 9.5" folder in "All Programs".

Driver Details

A node.js driver (pg) has been installed for your convenience. Feel free to install a different driver for your favorite language.

Raw
3-README-ORACLE.md

Oracle DB

Version 12c of Oracle DB has been installed.

Authentication Details

Oracle DB

  • Global DB Name (also called the SID/Service Name): ORCL

Oracle DB Admin Account:

  • Username: sys
  • Password: odb

Oracle DB Windows User Account:

  • Username: odb
  • Password: odb

Configuration & Administration

There is a web interface available at https://localhost:5500/em. The "https" is important. Ignore the security warning in Chome. Log in with the "sys" account.

For more Oracle-provided tools, look at the "Oracle - OraDB12Home1" folder in "All Programs"

Driver Details

Enough software has been installed and configured to compile Oracle DB Drivers.

  • Visual Studio Community
  • Windows 8.1 SDK
  • C++11
  • Oracle InstantClient

A node.js driver for Oracle DB (oracledb) has been compiled for your convenience. Feel free to install a different driver for your favorite language.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment