أرجوكم بليييييييييييييييييييييييييييييز والله محتاجة مساعدة في هذا SQL



انا طالبة ماجستير ادارة أعمال-تقنيات المعلومات.....................وما عندي ولا 1% خلفية في الsql


والمصيبة ان بعد أقل من شهر من الآن سأمتحن فيه وأخذنا ورشة عمل مدتها يومين فقط!!!!








وأحس أني زي الأطرش في الزفة........





......أرجوكم اريد مساعدة أو على الاقل تدلوني لشخص يساعدني.........................اريد افهم هذا الشي واقدر اكون جداول وغيره



بلييييييييييييييييييز أنتظر رد أحد ضروري

Hi there
I guess This Link will help you
SQL Commands
and you can you use the search option on ARABOUG web site
for more deatilas
and if you require more help please letme know

with my best regards.

thank you for the fast reply

i'll try to check it out although i have tried a lot to learn by such files, it still complecated for me as i am not at all technical person and have no IT background

any way i'll try to use it....but i think i may come back for more help....


thanx alot

any time you need help i will be here inshallah i could assist

[يسار]in this site you will find many books about SQL Stamtments ,Either Arabic Or English books

Read Arabic book , you may be take 3 weeks only to learn SQL statment in sha'a Allah
you must learn that
they are SQL Structure
SIMPLE SQL STATMENT
----------------------------------------
SELECT Fields name
FROM table name;
EXAMPLE
SELECT EMPNO , ENAME , SAL
FROM EMP ;

YOU CAN USE WHERE Clause TO RESTRICT DATA
------------------------------------------------------------
SELECT EMPNO , ENAME , SAL
FROM EMP
WHERE SAL > 1000 ;


YOU CAN USE Math Operations WITH SQL STATAMNETS like that
---------------------------------------------------------------------------------
SELECT SAL + ( SAL * 120/100) FROM EMP;


YOU CAN GET SERVER DATE AND TIME WITH SQL STATMENTS
---------------------------------------------------------------------------

SELECT SYSDATE FROM DUAL;

-- DUAL IS DUMMY TABLE NOT MORE TO TEST YOUR DATA


THEY ARE SOME FUNCTION , YOU CAN USE IT TO CHAND RETIREVED DATA LIKE
UPPER() --- TO Convert small Letter to Capital

select upper('Muhammad') from dual ;

-- result is MUHAMMAD



LOWER- TO Convert CAPLITAL LETTER TO SMALL

select lower('Muhammad') from dual ;

-- result is muhammad

they are many Functions like that to give us other results ....

read arabic book it will be usefull .....

[/يسار][/b]

CLICK HERE

تم تعديل 7 مايو 200817 سنة بواسطة MuhammadYassein