SQL Oracle Training-Full Course

Discussion in 'E-Books & Tutorials' started by RMTeam, Mar 8, 2012.

  1. RMTeam

    RMTeam Active Member

    Feb 18, 2012
    Likes Received:
    Trophy Points:
    SQL Oracle Training-Full Course


    English | 7 Session | 2.42GB
    Genre: eLearning


    Operation and close the Oracle databases
    Run the application server iSQL * Plus
    SQL Language Basics

    Introduction to the SQL language
    Data types, Oracle Data types
    Transactions Operators
    Values ??Literals
    Select simple sentences

    Simple queries Simple Queries
    Where use of the phrase
    Boolean Logical Operators
    Different parameters
    Sort rows
    Use expressions Expressions
    SQL * PLUS principles

    Make a connection to the tool SQL * PLUS
    Use the SQL * PLUS
    Memory usage SQL Buffer Part 1
    Memory usage SQL Buffer Part 2
    Use the files Scripts
    Customize the environment tool SQL * PLUS
    Coordinate the results of queries

    Format the results and generate reports (1)
    Format the results and generate reports (2)
    Division results for the sets and perform calculations
    Add a header and remove the page
    Save reports and delete formats
    Create reports using the files Scripts
    Variables Variables

    Uses variables Variables 1
    Uses variables Variables 2
    Use the command Accept
    Tool iSQL * PLUS
    Use the iSQL * PLUS
    Single Row Functions Functions

    Dealing with Nulls values
    The use of text functions Character Functions 1
    The use of text functions Character Functions 2
    The use of text functions Character Functions 3
    Numeric Functions Numerical Functions
    Date functions Date Functions 1
    Date functions Date Functions 2
    Transfer Functions Conversion Functions 1
    Transfer Functions Conversion Functions 2
    Miscellaneous functions, Miscellaneous Functions
    Data collection and aggregation functions

    Functions Group Functions assembly
    Group By statement
    Having the words
    Use the commands Rollup and Cube
    Overlapping functions Nesting Functions
    Sub queries and subqueries Joins links

    Link between the tables
    Link between the tables by using the Join
    The link between more than two tables
    Link is conditional Cartesian Join
    Links Outer Joins
    Link Self Join
    Link Non-Equality
    Use transactions Set Operators
    Subqueries Subqueries 1
    Subqueries Subqueries 2
    Modify data

    Use sentences DML
    Modify the data Updating Data
    Use of the phrase Merge
    Delete data from tables
    Close rows and tables
    Sentences Transaction Control
    Data Types to identify the types of data

    Review on the database elements
    Data Types Data Types
    Data Types History (1)
    Data Types History (2)
    Calculations on the history
    Types of binary data Binary Data types
    ROWID data types
    Constraints and restrictions Tables Tables

    Create the tables (1)
    Create tables (2)
    Temporary tables Temporary Tables
    Adjustments to the tables
    Delete columns and tables
    Constraints Constraints
    UNIQUE and CHECK constraints
    Restrictions Primary KEY and FOREIGN KEY
    Activate and delete constraints Constraints
    Restrictions Deferred Deferred Constraints
    Views virtual tables

    Create virtual tables Creating Views 1
    Create virtual tables Creating Views 2
    Modify the virtual tables Modifying Views
    The use of virtual tables Using the VIEWS
    Virtual tables JOIN VIEWS
    Virtual tables Inline Views
    Other elements of the databases

    The establishment of numerical strings Sequences
    Modified chains Numerical Sequences
    Synonyms Synonyms
    Types of Synonyms Synonyms
    Indexes Indexes
    Programs stored Stored Programs
    Users and confidential data

    Create and modify user accounts, User Accounts
    Documentation Authentication
    Add attributes to user accounts (1)
    Add attributes to user accounts (2)
    Control permits the user accounts
    Prevention grants and privileges Privileges
    Privileges Object Privileges elements
    System Privileges System privileges
    Create and use groups of privileges Roles
    Create and set the forms Profiles

    Creating a Database Connection
    Working with Database Objects
    Creating Tables
    Modifying Tables
    Managing Constraints
    Removing Tables
    Accessing Data
    Building Simple Queries
    Accessing Multiple Tables
    Using Functions to Customize Output
    Working With Groups of Data
    Manipulating Data
    Adding Data
    Modifying Data
    Removing Data
    Saving and Discarding Changes
    Exporting Data
    Importing Data
    Adding PL/SQL Components
    PL/SQL Blocks
    Using Triggers
    Using Procedures and Functions
    Using Packages
    Building Reports
    Producing a User Defined Report
    Using Source Code Control
    Versioning Files

    Note: Videos Explanation in Arabic, with English.

Share This Page