Installing and Manipulating Oracle Database Using SQL

Installing and Manipulating Oracle Database Using SQL, available at $39.99, has an average rating of 4.35, with 21 lectures, based on 90 reviews, and has 3224 subscribers.

You will learn about Remove Data from a database Add Data into a database Update existing records inside a database Create Report from extracted data This course is ideal for individuals who are This course is meant for those that have a basic understanding of databases and some very basic SQL It is particularly useful for This course is meant for those that have a basic understanding of databases and some very basic SQL.

Enroll now: Installing and Manipulating Oracle Database Using SQL

Summary

Title: Installing and Manipulating Oracle Database Using SQL

Price: $39.99

Average Rating: 4.35

Number of Lectures: 21

Number of Published Lectures: 21

Number of Curriculum Items: 21

Number of Published Curriculum Objects: 21

Original Price: $64.99

Quality Status: approved

Status: Live

What You Will Learn

Remove Data from a database

Add Data into a database

Update existing records inside a database

Create Report from extracted data

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Introduction to Oracle Database and SQL

Lecture 1: Understanding Database Concepts

Lecture 2: Introduction to Oracle Database

Lecture 3: Understanding SQL and Its Role

Lecture 4: Benefits and Features of Oracle Database

Lecture 5: Overview of manipulating Oracle Databases with SQL

Chapter 2: Setting Up Your Database Environment

Lecture 1: Introduction

Lecture 2: Download Oracle Database

Lecture 3: Install Oracle Database

Lecture 4: Unlock Sample Database Tables

Lecture 5: Installing Java JDK

Lecture 6: Download Oracle SQL Developer

Lecture 7: Installing Oracle SQL Developer

Lecture 8: Oracle SQL Developer Tour

Chapter 3: Manipulating Oracle Database

Lecture 1: Adding New Data To A Database

Lecture 2: DDL Create Part1

Lecture 3: DDL Create -Part 2

Lecture 4: Deleting Data -DDL

Lecture 5: Changing Data

Lecture 6: Reading Data and Generating a Report

Lecture 7: Retrieving Unique Data Values From A Database

Lecture 8: Thank You

Instructors

Skill Tree
Skill based learning

Rating Distribution

1 stars: 0 votes

2 stars: 4 votes

3 stars: 12 votes

4 stars: 37 votes

5 stars: 37 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!