آموزش تصویری Oracle (زبان اصلی)

[shmp30]

http://pic.azardl.com/images/52343148230830328586.jpg (http://pic.azardl.com/)

VTC - Oracle :Introduction to Oracle SQL & PL/SQL Tutorials

http://www.okz-okz.com/images/isk7htg6b7bxdtp4bp2h.png
Course: Oracle: Introduction to Oracle SQL and PL/SQL
Author: Gavin Powell
SKU: 33418
ISBN: 1932072241
Release Date: 2003-03-12
Duration: 12 hrs / 165 tutorials
Details:
Virtual Training Company's Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience. Gavin Powell, your instructor, will begin teaching you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and Oracle Enterprise Manager. This tutorial will explain how to maintain the Logical Database, and the difference between the Logical Database and the Physical database. You will be guided, in great detail, in the following areas: retrieving, changing, adding, and deleting data from the Database. From there, you will learn about Logical Database objects, Security, Select Statements, and much more. Introduction to Oracle SQL and PL/SQL will cover areas for the Oracle Certification course (1Z0-007).

Welcome
Welcome (02:27)
Useful Web Sites (04:56)
What is Oracle Software? (03:10)
The History of Databases (06:06)
The History of Oracle (05:07)
About this Course (05:10)

The Relational Database Model
The Relational Database Model (04:57)
The Concerts Schema (02:57)
Normalization pt. 1 (07:38)
Normalization pt. 2 (04:06)
Denormalization pt. 1 (05:22)
Denormalization pt. 2 (06:09)

Oracle SQL and PL/SQL Tools
What are the Oracle SQL and PL/SQL Tools? (02:42)
SQL Plus (05:08)
Formatting Output (05:34)
SQL Plus Worksheet (03:59)
iSQL Plus (02:35)
Oracle Enterprise Manager pt. 1 (04:46)
Oracle Enterprise Manager pt. 2 (01:11)

The Architecture of Oracle
The Oracle Database and Oracle Instance pt. 1 (04:10)
The Oracle Database and Oracle Instance pt. 2 (01:54)
Control Files, Logging, Archiving and Recoverability (02:49)

Creating Database Objects
Oracle Simple Datatypes pt. 1 (04:10)
Oracle Simple Datatypes pt. 2 (05:00)
Oracle Complex and Object Datatypes (03:22)
Types of Tables (05:10)
Methods of Table Creation (06:03)
Create Table Syntax (02:00)
Example Table Creations pt. 1 (05:09)
Example Table Creations pt. 2 (04:59)
Altering and Dropping Tables pt. 1 (04:53)
Altering and Dropping Tables pt. 2 (02:23)
What are Constraints? (05:40)
Creating, Changing and Dropping Constraints (06:21)
Types of Indexes pt. 1 (07:37)
Types of Indexes pt. 2 (04:10)
Creating, Altering and Dropping Indexes (05:36)
Sequence Counters (05:02)
Synonyms (01:02)
Views pt. 1 (02:08)
Views pt. 2 (01:47)
Metadata Views and Error Messages (06:02)

Users and Security
Schemas, Users, Privileges and Roles pt. 1 (04:37)
Schemas, Users, Privileges and Roles pt. 2 (04:49)
Schemas, Users, Privileges and Roles pt. 3 (07:38)
Types of Users (04:06)
Creating Users pt. 1 (05:52)
Creating Users pt. 2 (07:08)
Altering and Dropping Users (02:09)
Security (03:35)
System Privileges (04:26)
Object Privileges (00:58)
Granting and Revoking Privileges pt. 1 (06:22)
Granting and Revoking Privileges pt. 2 (02:13)
Grouping Privileges Using Roles pt. 1 (06:59)
Grouping Privileges Using Roles pt. 2 (02:16)
Setting Roles (01:35)

Retrieving Data from the Database
The SELECT Statement pt. 1 (03:14)
The SELECT Statement pt. 2 (07:08)
The SELECT Statement pt. 3 (03:18)
Types of SELECT Statement pt. 1 (06:53)
Types of SELECT Statement pt. 2 (01:45)
The DUAL Table pt. 1 (02:59)
The DUAL Table pt. 2 (03:15)
What is a NULL? (06:25)
Pseudo-Columns pt. 1 (04:19)
Pseudo-Columns pt. 2 (02:58)
More About SQL Plus Formatting pt. 1 (04:15)
More About SQL Plus Formatting pt. 2 (05:25)
More About SQL Plus Formatting pt. 3 (06:10)

Oracle Built In Functions
Types of Functions pt. 1 (04:32)
Types of Functions pt. 2 (04:37)
String Functions pt. 1 (04:58)
String Functions pt. 2 (07:42)
String Functions pt. 3 (05:40)
Number Functions (05:51)
Date Functions pt. 1 (04:11)
Date Functions pt. 2 (04:24)
Other Functions pt. 1 (02:55)
Other Functions pt. 2 (05:53)
Datatype Conversion Functions pt. 1 (05:21)
Datatype Conversion Functions pt. 2 (02:07)
Custom Functions Using PL/SQL (00:46)

Filtering SELECT Statements
The WHERE Clause (01:42)
Conditional Comparisons (01:20)
Using the WHERE Clause (01:26)
Using Logical Operators pt. 1 (05:06)
Using Logical Operators pt. 2 (01:37)
Using Conditional Comparisons pt. 1 (05:30)
Using Conditional Comparisons pt. 2 (06:01)

Sorting SELECT Statements
The ORDER BY Clause (03:49)
Sorting Methods pt. 1 (03:23)
Sorting Methods pt. 2 (06:36)
Sorting Methods pt. 3 (03:32)

Joining Multiple Tables
What is a Join? (06:55)
Two Join Syntax Formats (04:13)
Types of Joins pt. 1 (02:32)
Types of Joins pt. 2 (05:55)
Types of Joins pt. 3 (02:55)
Cross Join or Cartesian Product (04:04)
Natural or Inner Join pt. 1 (05:34)
Change the Concerts Schema pt. 1 (03:35)
Change the Concerts Schema pt. 2 (04:45)
Outer Join pt. 1 (03:49)
Outer Join pt. 2 (06:33)
Self Join (01:25)
Equi-Joins, Anti-Joins and Range-Joins (03:07)
Mutable and Complex Joins (03:24)

Summarizing with GROUP BY
What does GROUP BY Do? (05:25)
The GROUP BY Clause (03:36)
Types of Grouping Functions pt. 1 (03:34)
Types of Grouping Functions pt. 2 (04:49)
Special Behavior pt. 1 (04:46)
Special Behavior pt. 2 (04:45)
Summary Functions (04:49)
Statistical Functions (02:30)
Other Functions (04:00)
Filtering GROUP BY with the HAVING Clause (03:17)
Extending the GROUP BY Clause pt. 1 (04:52)
Extending the GROUP BY Clause pt. 2 (03:56)

Subqueries and Other Advanced Queries
What is a Subquery? (01:20)
Types of Subqueries (06:57)
Comparison Conditions Revisited pt. 1 (05:34)
Comparison Conditions Revisited pt. 2 (04:51)
Comparison Conditions Revisited pt. 3 (03:13)
Regular vs. Correlated Subqueries (01:15)
Nested Subqueries and Replacing Joins (06:27)
Where Can Subqueries be Used? (04:38)
Hierarchical Queries (04:51)
Set Operators and Composite Queries (04:14)

Oracle Data Manipulation Language (DML)
What is DML? (03:39)
Adding Data with INSERT (04:45)
Multiple Table INSERT pt. 1 (02:20)
Multiple Table INSERT pt. 2 (07:03)
Changing Data with UPDATE pt. 1 (04:32)
Changing Data with UPDATE pt. 2 (05:51)
Remove Data with DELETE or TRUNCATE pt. 1 (04:19)
Remove Data with DELETE or TRUNCATE pt. 2 (04:23)
Merging Tables with MERGE pt. 1 (06:50)
Merging Tables with MERGE pt. 2 (00:57)
Transactional Control (03:55)
Locking and Visibility of Data Changes (04:57)
COMMIT vs ROLLBACK (04:27)

PL/SQL (Programming Language SQL)
What is PL/SQL? (03:51)
Anonymous Procedures (02:56)
Modular Structure (04:27)
Named Procedures (07:05)
Functions (03:23)
Packages (07:10)
Triggers pt. 1 (07:02)
Triggers pt. 2 (05:06)
Variables and Types in PL/SQL pt. 1 (05:12)
Variables and Types in PL/SQL pt. 2 (05:06)
Objects and Object Datatypes (03:49)
More About Objects pt. 1 (06:16)
More About Objects pt. 2 (07:38)
Programming Control Structures (05:55)
Simple Database Access in PL/SQL (06:13)
Cursors and Implicit Cursors pt. 1 (02:11)
Cursors and Implicit Cursors pt. 2 (07:03)
Explicit Cursors pt. 1 (03:20)
Explicit Cursors pt. 2 (06:43)
Dynamic SQL (05:02)
Provided (DBMS_) Packages (01:58)

Credits
About the Author (02:00)

http://rapidshare.com/files/147149410/v.T.c.Intro.2.O.racl.e.s.q.l.n.P.L.S.Q.L.Tutls-virTuAlZin.rar

[shmp30]

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

Introduction
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.

http://www.wupload.com/file/5340114/SQL.Oracle.part1.rar
http://www.wupload.com/file/5340115/SQL.Oracle.part2.rar
http://www.wupload.com/file/5340116/SQL.Oracle.part3.rar
http://www.wupload.com/file/5340117/SQL.Oracle.part4.rar
http://www.wupload.com/file/5340118/SQL.Oracle.part5.rar
http://www.wupload.com/file/5340119/SQL.Oracle.part6.rar

[Orca]

اینو خودت دیدی؟
ارزش داره دان کنم؟

[shmp30]

نه هنوز ولی آموزش های VTC (پست اول ) همشون خوب هستند .
Php ش رو دانلود کردم خیلی خوب بود :from me :