Learn SQL For Oracle Databases - Using Toad From Scratch

Focused View

Skill Tree

5:50:50

103 View

01 - Introduction and Lab Setup

001 Introduction.mp4

07:10

002 Basic database concepts.encrypted.mp4

07:09

002 basic database concepts.encrypted.zip

003 Tools the Professional use.encrypted.mp4

08:39

003 tools the professional use.encrypted.zip

004 Oracle 11g Download and Installation.encrypted.mp4

08:11

004 oracle 11g download and installation.encrypted.zip

005 Oracle 11g Setup file download.html

005 setup.zip

006 Unlocking Sample HR Schema Account.encrypted.mp4

05:04

006 unlocking sample hr schema account.encrypted.zip

007 Download and install Oracle SQL Developer.encrypted.mp4

08:55

007 download and install oracle sql developer.encrypted.zip

008 Connect SQL Developer to Oracle database.encrypted.mp4

06:05

008 connect sql developer to oracle database.encrypted.zip

009 Creating Account on Oracle Application Express.encrypted.mp4

03:28

009 creating account on oracle application express.encrypted.zip

010 Populating Sample HR Schema.encrypted.mp4

05:33

010 populating sample hr schema.encrypted.zip

011 Running Sample Application.encrypted.mp4

03:01

011 running sample application.encrypted.zip

012 Toad For Oracle Download and Installation.encrypted.mp4

07:09

012 toad for oracle download and installation.encrypted.zip

013 Toad Database Connection Setup.encrypted.mp4

06:38

013 toad database connection setup.encrypted.zip

014 Notepad++ Download and Installation.encrypted.mp4

04:37

014 notepad++ download and installation.encrypted.zip

015 What is an ERD.encrypted.mp4

05:32

015 what is an erd.encrypted.zip

016 How to generate ERD with TOAD.encrypted.mp4

03:59

016 how to generate erd with toad.encrypted.zip

017 How to generate ERD with SQL Developer.encrypted.mp4

13:02

017 how to generate erd with sql developer.encrypted.zip

02 - SQL Sub Languages

001 SQL Sub Languages.mp4

03:05

002 DDL CREATE PART 1.encrypted.mp4

08:49

002 ddl create part 1.encrypted.zip

003 DDL CREATE PART 2.encrypted.mp4

08:03

003 ddl create part 2.encrypted.zip

004 DDL ALTER TRUNCATE DROP.encrypted.mp4

08:38

004 ddl alter truncate drop.encrypted.zip

005 DML SELECT.encrypted.mp4

09:15

005 dml select.encrypted.zip

006 DML INSERT.encrypted.mp4

09:32

006 dml insert.encrypted.zip

007 DML UPDATE DELETE.encrypted.mp4

07:02

007 dml update delete.encrypted.zip

03 - Reading Data

001 Data Types And Constraints.encrypted.mp4

09:37

001 data types and constraints.encrypted.zip

002 Limiting And Sorting Data.encrypted.mp4

07:18

002 limiting and sorting data.encrypted.zip

003 Operators.encrypted.mp4

09:57

003 operators.encrypted.zip

004 Set Operators.encrypted.mp4

09:20

004 set operators.encrypted.zip

005 View And Dual Table.encrypted.mp4

06:06

005 view and dual table.encrypted.zip

04 - Table Joins

001 Table Joins.encrypted.mp4

04:11

001 table joins.encrypted.zip

002 Aliases.encrypted.mp4

06:06

002 aliases.encrypted.zip

003 Equi Join.encrypted.mp4

07:46

003 equi join.encrypted.zip

004 Non Equi Join.encrypted.mp4

07:26

004 non equi join.encrypted.zip

005 Cartesian Join.encrypted.mp4

06:19

005 cartesian join.encrypted.zip

006 Outer Join.encrypted.mp4

08:14

006 outer join.encrypted.zip

007 Self Join.encrypted.mp4

09:53

007 self join.encrypted.zip

05 - Functions

001 Functions.encrypted.mp4

02:05

001 functions.encrypted.zip

002 Character Functions.encrypted.mp4

07:50

002 character functions.encrypted.zip

003 Conversions.encrypted.mp4

06:48

003 conversions.encrypted.zip

004 Date Functions.encrypted.mp4

05:02

004 date functions.encrypted.zip

005 Numeric Functions.encrypted.mp4

05:25

005 numeric functions.encrypted.zip

006 Group Aggregate Functions.encrypted.mp4

05:26

006 group aggregate functions.encrypted.zip

06 - Analytic Functions

001 What are Analytic Functions.encrypted.mp4

06:43

001 what are analytic functions.encrypted.zip

002 Syntax.encrypted.mp4

04:07

002 syntax.encrypted.zip

003 Partition By Clause.encrypted.mp4

08:04

003 partition by clause.encrypted.zip

004 ORDER BY Clause.encrypted.mp4

05:48

004 order by clause.encrypted.zip

005 DENSE RANK Functions.encrypted.mp4

05:57

005 dense rank functions.encrypted.zip

006 First and LAST Function.encrypted.mp4

08:56

006 first and last function.encrypted.zip

007 LAG Function.mp4

03:37

008 LISTAGG Function.encrypted.mp4

06:14

008 listagg function.encrypted.zip

009 RANK Functions.encrypted.mp4

06:04

009 rank functions.encrypted.zip

010 ROW Number Functions.encrypted.mp4

09:26

010 row number functions.encrypted.zip

07 - Conclusion

001 Conclusion.encrypted.mp4

02:29

001 conclusion.encrypted.zip

002 Thank You.html

Description

Learn how to communicate with oracle databases using Toad for Oracle . Learn how to create,read,update and delete data.

What You'll 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 is this for?

IT professionals who want to gain extra valuable skills

Internet Marketers

Anyone who wants to learn how to communicate with databases.

What You Need to Know?

Sample Oracle 11g Database (Free download)

Toad For Oracle (Free 30 days Trial)

Notepad++ (Optional)

More details

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 this course is for:
IT professionals who want to gain extra valuable skills
Internet Marketers
Anyone who wants to learn how to communicate with databases.

User Reviews

Rating

average 0

Total votes0

Focused display

We are experienced company that provides quality video based training .Our courses are easy to follow and understand and will take you froman 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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.