Learn SQL For Oracle Databases - Using Toad From Scratch
3.9 (33 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.
570 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL For Oracle Databases - Using Toad From Scratch to your Wishlist.

Add to Wishlist

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.9 (33 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.
570 students enrolled
Created by Skill Tree
Last updated 6/2014
English
Current price: $10 Original price: $165 Discount: 94% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • Sample Oracle 11g Database (Free download)
  • Toad For Oracle (Free 30 days Trial)
  • Notepad++ (Optional)
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
38 Lectures
04:02:27
+
Introduction and Lab Setup
12 Lectures 01:00:44

Database Concepts Part 1
04:31

Database Concepts Part 2
10:16


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
+
SQL Sub Languages
7 Lectures 54:24

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
+
Reading Data
5 Lectures 42:18
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
+
Table Joins
7 Lectures 49:56
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
+
Functions
6 Lectures 32:36
Functions
02:05

Character Functions
07:50

Conversions
06:48

Date Functions
05:02

Numeric Functions
05:25

Group / Aggregate Functions
05:26
+
Conclusion
1 Lecture 02:29
Conclusion
02:29
About the Instructor
Skill Tree
4.0 Average rating
233 Reviews
7,157 Students
17 Courses
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.