Learn SQL For Oracle Databases – Using Toad From Scratch

Learn SQL For Oracle Databases – Using Toad From Scratch, available at $64.99, has an average rating of 4.64, with 59 lectures, based on 531 reviews, and has 3671 subscribers.

You will learn about Write SQL Queries on Oracle Databases Create,read,update and delete data from a database. Connect to Oracle databases using TOAD Execute SQL Queries in TOAD Editor Extract data from multiple tables using SQL This course is ideal for individuals who are IT professionals who want to gain extra valuable skills or Internet Marketers or Anyone who wants to learn how to communicate with databases. It is particularly useful for IT professionals who want to gain extra valuable skills or Internet Marketers or Anyone who wants to learn how to communicate with databases.

Enroll now: Learn SQL For Oracle Databases – Using Toad From Scratch

Summary

Title: Learn SQL For Oracle Databases – Using Toad From Scratch

Price: $64.99

Average Rating: 4.64

Number of Lectures: 59

Number of Published Lectures: 56

Number of Curriculum Items: 59

Number of Published Curriculum Objects: 56

Original Price: $139.99

Quality Status: approved

Status: Live

What You Will Learn

Write SQL Queries on Oracle Databases
Create,read,update and delete data from a database.
Connect to Oracle databases using TOAD
Execute SQL Queries in TOAD Editor
Extract data from multiple tables using SQL

Who Should Attend

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

Target Audiences

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

What is this course about?

This course teaches how to use SOL to communicate with Oracledatabase 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.

Course Curriculum

Chapter 1: Introduction and Lab Setup

Lecture 1: Introduction

Lecture 2: Basic database concepts

Lecture 3: Tools the Professional use

Lecture 4: Oracle 11g Download and Installation

Lecture 5: Oracle 11g Setup file download

Lecture 6: Unlocking Sample HR Schema Account

Lecture 7: Download and install Oracle SQL Developer

Lecture 8: Connect SQL Developer to Oracle database

Lecture 9: Creating Account on Oracle Application Express

Lecture 10: Populating Sample HR Schema

Lecture 11: Running Sample Application

Lecture 12: Toad For Oracle Download and Installation

Lecture 13: Toad Database Connection Setup

Lecture 14: Notepad++ Download and Installation

Lecture 15: What is an ERD

Lecture 16: How to generate ERD with TOAD

Lecture 17: How to generate ERD with SQL Developer

Chapter 2: SQL Sub Languages

Lecture 1: SQL Sub Languages

Lecture 2: DDL CREATE PART 1

Lecture 3: DDL CREATE PART 2

Lecture 4: DDL ALTER ,TRUNCATE ,DROP

Lecture 5: DML SELECT

Lecture 6: DML INSERT

Lecture 7: DML UPDATE , DELETE

Chapter 3: Reading Data

Lecture 1: Data Types And Constraints

Lecture 2: Limiting And Sorting Data

Lecture 3: Operators

Lecture 4: Set Operators

Lecture 5: View And Dual Table

Chapter 4: Table Joins

Lecture 1: Table Joins

Lecture 2: Aliases

Lecture 3: Equi Join

Lecture 4: Non Equi Join

Lecture 5: Cartesian Join

Lecture 6: Outer Join

Lecture 7: Self Join

Chapter 5: Functions

Lecture 1: Functions

Lecture 2: Character Functions

Lecture 3: Conversions

Lecture 4: Date Functions

Lecture 5: Numeric Functions

Lecture 6: Group / Aggregate Functions

Chapter 6: Analytic Functions

Lecture 1: What are Analytic Functions

Lecture 2: Syntax

Lecture 3: Partition By Clause

Lecture 4: ORDER BY Clause

Lecture 5: DENSE RANK Functions

Lecture 6: First and LAST Function

Lecture 7: LAG Function

Lecture 8: LISTAGG Function

Lecture 9: RANK Functions

Lecture 10: ROW Number Functions

Chapter 7: Conclusion

Lecture 1: Conclusion

Lecture 2: Practice Exercises

Lecture 3: Answers to Practice Exercises

Lecture 4: Thank You

Instructors

Skill Tree
Skill based learning

Rating Distribution

1 stars: 8 votes
2 stars: 10 votes
3 stars: 68 votes
4 stars: 175 votes
5 stars: 270 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!

Menu