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.

01 - Introduction and Lab Setup

001 Introduction

002 Basic database concepts.encrypted

002 basic database concepts.encrypted.zip

003 Tools the Professional use.encrypted

003 tools the professional use.encrypted.zip

004 Oracle 11g Download and Installation.encrypted

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

006 unlocking sample hr schema account.encrypted.zip

007 Download and install Oracle SQL Developer.encrypted

007 download and install oracle sql developer.encrypted.zip

008 Connect SQL Developer to Oracle database.encrypted

008 connect sql developer to oracle database.encrypted.zip

009 Creating Account on Oracle Application Express.encrypted

009 creating account on oracle application express.encrypted.zip

010 Populating Sample HR Schema.encrypted

010 populating sample hr schema.encrypted.zip

011 Running Sample Application.encrypted

011 running sample application.encrypted.zip

012 Toad For Oracle Download and Installation.encrypted

012 toad for oracle download and installation.encrypted.zip

013 Toad Database Connection Setup.encrypted

013 toad database connection setup.encrypted.zip

014 Notepad++ Download and Installation.encrypted

014 notepad++ download and installation.encrypted.zip

015 What is an ERD.encrypted

015 what is an erd.encrypted.zip

016 How to generate ERD with TOAD.encrypted

016 how to generate erd with toad.encrypted.zip

017 How to generate ERD with SQL Developer.encrypted

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

02 - SQL Sub Languages

001 SQL Sub Languages

002 DDL CREATE PART 1.encrypted

002 ddl create part 1.encrypted.zip

003 DDL CREATE PART 2.encrypted

003 ddl create part 2.encrypted.zip

004 DDL ALTER TRUNCATE DROP.encrypted

004 ddl alter truncate drop.encrypted.zip

005 DML SELECT.encrypted

005 dml select.encrypted.zip

006 DML INSERT.encrypted

006 dml insert.encrypted.zip

007 DML UPDATE DELETE.encrypted

007 dml update delete.encrypted.zip

03 - Reading Data

001 Data Types And Constraints.encrypted

001 data types and constraints.encrypted.zip

002 Limiting And Sorting Data.encrypted

002 limiting and sorting data.encrypted.zip

003 Operators.encrypted

003 operators.encrypted.zip

004 Set Operators.encrypted

004 set operators.encrypted.zip

005 View And Dual Table.encrypted

005 view and dual table.encrypted.zip

04 - Table Joins

001 Table Joins.encrypted

001 table joins.encrypted.zip

002 Aliases.encrypted

002 aliases.encrypted.zip

003 Equi Join.encrypted

003 equi join.encrypted.zip

004 Non Equi Join.encrypted

004 non equi join.encrypted.zip

005 Cartesian Join.encrypted

005 cartesian join.encrypted.zip

006 Outer Join.encrypted

006 outer join.encrypted.zip

007 Self Join.encrypted

007 self join.encrypted.zip

05 - Functions

001 Functions.encrypted

001 functions.encrypted.zip

002 Character Functions.encrypted

002 character functions.encrypted.zip

003 Conversions.encrypted

003 conversions.encrypted.zip

004 Date Functions.encrypted

004 date functions.encrypted.zip

005 Numeric Functions.encrypted

005 numeric functions.encrypted.zip

006 Group Aggregate Functions.encrypted

006 group aggregate functions.encrypted.zip

06 - Analytic Functions

001 What are Analytic Functions.encrypted

001 what are analytic functions.encrypted.zip

002 Syntax.encrypted

002 syntax.encrypted.zip

003 Partition By Clause.encrypted

003 partition by clause.encrypted.zip

004 ORDER BY Clause.encrypted

004 order by clause.encrypted.zip

005 DENSE RANK Functions.encrypted

005 dense rank functions.encrypted.zip

006 First and LAST Function.encrypted

006 first and last function.encrypted.zip

007 LAG Function

008 LISTAGG Function.encrypted

008 listagg function.encrypted.zip

009 RANK Functions.encrypted

009 rank functions.encrypted.zip

010 ROW Number Functions.encrypted

010 row number functions.encrypted.zip

07 - Conclusion

001 Conclusion.encrypted

001 conclusion.encrypted.zip

002 Thank You.html

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy