Task 1: Download Oracle XE

• https://www.oracle.com/in/database/technologies/xe-downloads.html
• Install Oracle XE 18c or 11g

Task 1.1 Oracle XE Versions ( 18c)

• https://www.oracle.com/in/database/technologies/xe-downloads.html
• Oracle Database 18c Express Edition for Windows x64

Task 1.2 Oracle XE Version (11g)

• https://www.oracle.com/in/database/technologies/xe-prior-releases.html
• Oracle Database 11gR2 Express Edition for Windows x64

Task 2: Install Oracle XE

• Set credentials - system/password
• Default Port: 3306
• Machine : localhost

Note: Java Installation Path ( e.g: C:\Program Files\Java\jdk-8)

Task 3: Install SQLDeveloper

• https://www.oracle.com/tools/downloads/sqldev-downloads.html
• Windows 64-bit with JDK 8 included

Task 3.1 : Open SQL Developer and Create new connection

• New Connection

  • Connection Name: xe
  • Hostname: 127.0.0.1
  • Port: 1521
  • Username: system
  • Password: password

• Test Connection

• Connect