Installing and Manipulating Oracle Database Using SQL

Hands-On Practical Examples
3.9 (79 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.
3,206 students enrolled
Instructed by Skill Tree Development / Databases
$19
$75
75% off
Take This Course
  • Lectures 15
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course Description

Oracle Databases are among the most widely used in the world. You will find oracle databases in large to medium size organizations to store various types of information. This course will teach you how to install an oracle database step by step from scratch with no steps skipped. You will also be getting access to a sample schema object and database tables. But before you can access the tables in the schema it has to be unlocked. I will show you the special code used to unlock that in this course.

Once the database is installed you will need a tool to connect to it and perform data manipulation. The tool you will need to install is Oracle SQL developer developed by oracle. This is a free tool that can sometimes be tricky to install. I will show you how to install it step by step.

You will be using SQL (Structured Query Language) to talk to and give instructions to the database to perform various types of data manipulation.

This course is for those who have some very basic knowledge of database fundamentals as well as basic SQL knowledge. However the course is also easy enough for anyone who just has a basic knowledge of how to use a computer.

This format of this course is video based and the duration of the course is under 2hours long

The examples are practical hands on easy to follow and resembles a real life environment.

.What You Learn in this course:

  • How to add new data into a database
  • How to remove data from a database
  • How to update existing data in a database
  • How to get data from a database and create a report from it
  • How to Get Unique Data Values from a database

What are the requirements?

  • You should have a sample database and connection to the database.We 'll cover this in section one of this course

What am I going to get from this course?

  • Remove Data from a database
  • Add Data into a database
  • Update existing records inside a database
  • Create Report from extracted data

What is the target audience?

  • This course is meant for those that have a basic understanding of databases and some very basic SQL

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Setting Up Your Database Environment
Introduction
Preview
03:24
Download Oracle Database
Preview
04:58
Install Oracle Database
Preview
04:47
Unlock Sample Database Tables
05:09
Installing Java JDK
05:24
Download Oracle SQL Developer
04:55
Installing Oracle SQL Developer
06:07
Oracle SQL Developer Tour
03:40
Section 2: Manipulating Oracle Database
Adding New Data To A Database
09:12
DDL Create Part1
08:50
DDL Create -Part 2
08:03
Deleting Data -DDL
05:11
Changing Data
11:07
Reading Data and Generating a Report
12:44
Retrieving Unique Data Values From A Database
06:24

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Skill Tree, Skill based learning

We are experienced company that provides quality video based training .
Our courses are easy to follow and understand and will take you from
an absolute beginner with no technical skills to being efficient and confident with various technical skill like SQL and databases.
We have worked with companies of various sizes and provided consultancy services at various levels.
Thank you for learning with us and we hope your experience will be pleasant.

Ready to start learning?
Take This Course