Learn SQL For Oracle Databases - Using Toad From Scratch

Learn how to communicate with oracle databases using Toad for Oracle . Learn how to create,read,update and delete data.
3.8 (15 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.
514 students enrolled
$165
Take This Course
  • Lectures 38
  • Contents Video: 4 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 6/2014 English

Course Description

What is this course about?

This course teaches how to use SOL to communicate with Oracle database using Toad for Oracle editor.

What Kind of Course material is included?

All the contents are video based there are 38 video lectures that includes :

  • Database Concepts
  • SQL Sub Languages (DDL,DML)
  • Data Types and Constraints(Varchar2,Number,Date,NOT Null,Primary Key)
  • Reading ,Limiting and Sorting Data
  • Table Joins (Extract data from several tables)
  • Aliases
  • Functions (Character,Group).

How Long is this course?

The course is approximately four hours long and is structured in a logical easy to follow functional way .

Why take this course?

Taking this course will give you a well sort after skill that will last many years. Databases are vital and to have the skill to talk to them is invaluable.

What are the requirements?

  • Sample Oracle 11g Database (Free download)
  • Toad For Oracle (Free 30 days Trial)
  • Notepad++ (Optional)

What am I going to get from this course?

  • After taking this course you will be able to communicate with an oracle database to create,read,update and delete data from a database. This course will teach you how to write your own SOL queries that will enable you communicate and get data from an oracle database using Toad for oracle editor as an interface.

What is the target audience?

  • IT professionals who want to gain extra valuable skills
  • Internet Marketers
  • Anyone who wants to learn how to communicate with databases.

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: Introduction and Lab Setup
Introduction
Preview
07:10
Database Concepts Part 1
04:31
Database Concepts Part 2
10:16
Tools Required
Preview
00:56
Oracle 11g Download and Installation
07:18
Unlocking Sample HR Schema Account
04:53
Creating Account on Oracle Application Express
03:28
Populating Sample HR Schema
05:33
Running Sample Application
03:01
Toad For Oracle Download and Installation
05:21
Toad Database Connection Setup
03:40
Notepad++ Download and Installation
04:37
Section 2: SQL Sub Languages
SQL Sub Languages
Preview
03:05
DDL CREATE PART 1
08:49
DDL CREATE PART 2
08:03
DDL ALTER ,TRUNCATE ,DROP
08:38
DML SELECT
09:15
DML INSERT
09:32
DML UPDATE , DELETE
07:02
Section 3: Reading Data
Data Types And Constraints
09:37
Limiting And Sorting Data
07:18
Operators
09:57
Set Operators
09:20
View And Dual Table
06:06
Section 4: Table Joins
Table Joins
04:11
Aliases
06:07
Equi Join
07:46
Non Equi Join
07:26
Cartesian Join
06:19
Outer Join
08:14
Self Join
09:53
Section 5: Functions
Functions
02:05
Character Functions
07:50
Conversions
06:48
Date Functions
05:02
Numeric Functions
05:25
Group / Aggregate Functions
05:26
Section 6: Conclusion
Conclusion
02:29

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