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

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 18802
    حجم: 1468 مگابایت
    مدت زمان: 351 دقیقه
    تاریخ انتشار: ۱۴ شهریور ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید