Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle Database 12c Installation For All Levels
Rating: 4.4 out of 5(29 ratings)
102 students

Oracle Database 12c Installation For All Levels

Installation guide to Oracle Database and SQL Developer.Creating users in SQL PLUS and granting them privileges.
Created byFelecia Mhonda
Last updated 5/2016
English
English [Auto],

What you'll learn

  • create an Oracle account.
  • use different ways to download software from an Oracle website.
  • create folders.
  • uncompress files and to extract files.
  • edit environment variables.
  • install an Oracle Database.
  • verify installation of an Oracle database.
  • start and stop Oracle services.
  • identify Oracle database home path and TNSNAMES path.
  • log into database using SQL PLUS.
  • create database users.
  • unlock a database user.
  • give privileges to users.
  • install SQL Developer.
  • create connections in SQL Developer.

Course content

8 sections • 14 lectures • 2h 24m total length

  • Welcome2:31

    Install Oracle database 12c on Windows 10, download from Oracle website, set up a free Oracle account, and learn basic database operations like creating users, querying data, and granting privileges.

  • Introduction1:53

    Install Oracle database on Windows 10 (and Windows 7) by covering hardware requirements, downloading from the Oracle website, extracting files, performing installation, verifying success, logging in, and installing SQL Developer.

  • Module 14:04

    Explore hardware and software requirements for Oracle database 12c installation on 64-bit systems, including 4 gb ram, 10 gb disk space, virtual memory guidelines, and compatible windows and server editions.

Requirements

  • We will go through how to get everything that you need to use in this course. No prior skills are needed, you will receive all the necessary training in this course.

Description

This course is a must have course for everyone who is or intending to go into a field that uses data. It is the foundation, whether you want to go into business intelligence or learn learn Oracle SQL, go into data warehousing or becoming an ETL developer or architecture. It gives you the installation of a database on your platform. You do not need any prior experience. I have structured the course in steps that everyone from beginner to expert level, should be able to follow. The modules are in the following order:

  • Hardware and software requirements
  • Creating Oracle account
  • Downloading software
  • Extracting files
  • Checking Enviroment variables
  • Installing Oracle Database 12c
  • Verifying database installation - checking services, tnsnames.ora file and database files
  • Using SQLPLus
  • Creating users and granting them privileges
  • Downloading SQL Developer installation files
  • Installing SQL Developer
  • Creating Connections in SQL Developer

Who this course is for:

  • This course is for everyone, beginners or professionals, who need to install an Oracle Database or SQL Developer on their systems.

Report abuse