Certification Forum  

Go Back   Certification Forum > Oracle Certification

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 10-06-2011, 11:03 PM
Junior Member
 
Join Date: Oct 2011
Posts: 9
Default [offer]Full Course SQL Oracle Training



[CODE]Full Course SQL Oracle Training
English | 7 Session | 2.45 GB

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


Code:
http://www.filesonic.com/file/1352368334/part1.rar
http://www.filesonic.com/file/1352366154/part2.rar
http://www.filesonic.com/file/1352573484/part3.rar
http://www.filesonic.com/file/1352579894/part4.rar
http://www.filesonic.com/file/1352368354/part5.rar
http://www.filesonic.com/file/1352355634/part6.rar
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 10-20-2011, 11:25 PM
Junior Member
 
Join Date: Oct 2011
Posts: 7
Default

it provides the perfect introduction of SQL
explains each topic ...
thanks buddy for sharing its toooooooo good
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 11-06-2011, 03:56 PM
Junior Member
 
Join Date: Oct 2010
Posts: 5
Default Looks great...

Looks great but in Arabic..
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-13-2012, 11:19 PM
Junior Member
 
Join Date: Apr 2012
Posts: 1
Default The tutorial is in English or Arabic

Hi,

The tutorial is in English or Arabic
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 08:17 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21