X
 
  • Filter
  • الوقت
  • عرض
مسح الكل
مشاركات جديدة

    السلام عليكم

    اخواني اريد كورس تعليم الاوراكل من الصفر حتى الاحتراف وتكون الروابط سليمة رجاءا

    لاني تعبت ماحصلت بالبوابة

    وشكرا

    #2
    من مشاركة الأخ mshaz


    Learn Oracle Performance Tuning from Scratch



    MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 6 Hours | Lec: 81 | 603 MB
    Genre: eLearning | Language: English

    Learn Performance tuning in easy way
    Oracle is one of the most popular database systems in use today. Yet many developers do not understand how Oracle works or the principles behind developing high performance Oracle applications.

    This Course includes below topics:

    Understanding how Oracle is processing your SQL statements through generating and interpreting execution plans,
    To designing and using indexes to speed up the data access of your application.
    How to use Oracle dynamic performance views to view real time information about Oracle performance, including which SQL statements are the most costly to run.
    The use of bind variables,
    Use of connection pooling,
    Application best practices round out the topics
    SCREENSHOTS

    *

    =======================

    Learn Oracle SQL from Scratch - Step by Step Approach



    Learn Oracle SQL from Scratch - Step by Step Approach
    MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours | 162 MB
    Genre: eLearning | Language: English



    One-stop shop to learn SQL from Scratch, become Oracle certified and earn $100K in IT Industry

    This unique introductory SQL tutorial not only provides easy-to-understand Oracle SQL instructions, but it allows you to prepare for SQL Interviews and Oracle Certifications. This course bundles Basic + Intermediate + Advanced SQL + SQL Interview Questions + Oracle Certification Preparation.

    This Course is for beginners who doesn't have any knowledge about SQL. I have taught the course in such a way that any non-technical person will understand easily all Database Concepts and SQL Commands.

    In this course, you will learn:

    Oracle Database 11g Installation
    Databases Concepts
    Retrieving & Filtering Data from Database
    Using various Database Functions
    Creating Tables and modifying its structure
    Joining Data from various Tables
    Grouping Data and calculating summaries
    Enforcing Constraints on Tables
    Softwares used in Course

    Oracle Database 11g
    SQL Developer

    On course completion, You will be Mastered in SQL and can implement Successfully it in your work place or will surely land on High Paying Job

    *



    ===========================

    Learn Oracle Database: Become an oracle database administra



    Learn Oracle Database: Become an oracle database administra
    MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2.5 Hours | 257 MB
    Genre: eLearning | Language: English


    This course walks you through easy to follow guides to learn the basics of Oracle Databases.

    This course will walk you through the basics of an Oracle Database. The course material is all videos with a duration of just over two hours long. The course is structured in a very easy to follow way and also logical.

    This course is a fast and easy way to know about the basics of an oracle database.

    This course walks you through some database concepts and includes the following

    ·Data Types and Constraints

    ·View and Dual Tables

    ·ERD (Entity Relationship Diagram)

    ·SQL

    ·Operators

    ·SQL SUB Languages

    ·Sample Oracle Database Installation

    ·Viewing ,limiting and sorting data from an oracle database

    *


    ======================

    Learn SQL For Oracle Databases - Using Toad From Scratch




    Learn SQL For Oracle Databases - Using Toad From Scratch
    MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 4 Hours | 484 MB
    Genre: eLearning | Language: English


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

    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.

    *


    ================================

    Learn Advanced SQL For Oracle Databases




    Learn Advanced SQL For Oracle Databases
    MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3.5 Hours | 760 MB
    Genre: eLearning | Language: English


    Hands-On Advanced SQL Skills For Oracle Databases

    Learn the advanced SQL skills necessary to design and code complex queries against Oracle databases. Design, code and test the most efficient query to solve a given business problem.

    In this course you will have a choice of either using Toad or SQL developer to connect to the oracle database. The course will show you how to setup connection to the database.
    This advanced Oracle SQL course covers the design of more complex SQL statements and the strategies available for implementing them, it covers topics like SET operators and Analytic functions. It also introduces you to views because these are useful for hiding the complexity of queries and also can act as a security mechanism

    Who is This Course For?

    This course is designed for anyone who has some basic SQL knowledge and can write and understand simple SQL Queries. Also knowing the basics of relational database management systems (RDBMS) would be an advantage.

    What You Will Learn:

    How to Create Views
    How to check the structure of a table
    How to use Flashback to Rollback Data
    How to use Analytic Functions
    How to use SET operators to query data
    How to set database environment
    How to connect to the database
    How to write advanced SQL queries

    *



    تعليق
    Working...
    X