Oracle Database 12c Installation For All Levels
4.5 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
35 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle Database 12c Installation For All Levels to your Wishlist.

Add to Wishlist

Oracle Database 12c Installation For All Levels

Installation guide to Oracle Database and SQL Developer.Creating users in SQL PLUS and granting them privileges.
4.5 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
35 students enrolled
Created by Felecia Mhonda
Last updated 5/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
  • This course is for everyone, beginners or professionals, who need to install an Oracle Database or SQL Developer on their systems.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
14 Lectures
02:24:22
+
Introduction
3 Lectures 08:28
+
Software Downloads
2 Lectures 24:07

Downloading Database 12c Installation Files
17:17
+
Extracting Files
1 Lecture 11:24
Extracting Oracle Database 12c Installation Files
11:24
+
Oracle Database 12c Installation
3 Lectures 36:03
Installation Notes.
07:08

Oracle Database 12c Installation Part 1
18:53

Oracle Database 12c Installation Part 2
10:02
+
Verifying Oracle Database Installation
1 Lecture 14:22
Verifying Oracle Database Installation
14:22
+
SQL PLUS
1 Lecture 11:55
logging into SQL PLUS and creating users
11:55
+
SQL Developer
2 Lectures 29:58
SQL Developer Installation files download
15:16

SQL Developer Installation and Database Connection
14:42
+
Oracle Database SQL Plus and SQL Developer
1 Lecture 08:05
Oracle Database SQL Plus and SQL Developer
08:05
About the Instructor
Felecia Mhonda
4.5 Average rating
5 Reviews
35 Students
1 Course
Business Intelligence Developer

My name is Felecia Mhonda and i am an Oracle Certified Specialist. I specialize  in Database, Repository Creation Utility and Oracle Business Intelligence Implementation, OBIEE back end and front end. I am providing this training so that i can be able to share my knowledge and help the world at large.