An Introduction to Oracle SQL

A brief presentation of Oracle SQL. Look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).
Oracle Tutorial | Oracle SQL Tutorial For Beginners ☞ morioh.com/p/c...
Learn Oracle SQL for Beginners - Full Course ☞ morioh.com/p/f...
PostgreSQL Database Administration (DBA) for Beginners
☞ morioh.com/p/0...
This course is a brief presentation of Oracle SQL.
We will install a version of Oracle Express Edition and Oracle SQL Developer for free.
We'll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).
Following this, we'll look at what else you need to know, and resources (which range from FREE to very expensive) which will help you to learn it..
What you'll learn
Either Download and Install Oracle Express Edition and Oracle SQL Developer on your computer - for free
Write your own SELECT statements.
Learn the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses.
Get an easy way to remember the order of these clauses.
Find out what more you need to know, and resources in how to learn it.
#oracel #sql #database
Originally published
------------------------------------------------------------------------------------
Social Network for Developers: bit.ly/2M1cxD2
Developer's Store: bit.ly/2L27JNR
Fanpage: bit.ly/2LyM4fJ

[@albertowen1025]

THANK YOU - your knowledge really improved my learning, plus you are easier to understand than some of these other wackos on here who expect you to know everything! Awesome video!

[@idonnigga]

Albert Iame whlteboy

[@plogaet9032]

Thank you, I have successfully setup Oracle database on my VM. I really appreciate you because I gone throw many Indian videos on it and they were all painful. Thank YOU!

[@idonnigga]

Plo Iame whlteboy

[@xxultz]

Thank you so much for the tutorial, for someone complete new to this topic like me, it was very helpful!

[@idonnigga]

Christian Iame whlteboy

[@David-hr3ui]

Thank you for your video. I have a question about using the Query Builder: how can you move a field name (in the Expression Column) up or down without right mouse clicking over the field then selecting 'Move Up' or 'Move Down'? This is a pretty slow method when a field needs to be moved up many lines. Is there a short-cut key or a method of dragging the field up in the field list?

[@idonnigga]

David Iame whlteboy

[@lumennganje2721]

Thanks so much sir. I have a little problem though; I am on linux mint and cannot install oracle 18c though having installed the RMP folder.

[@idonnigga]

Lumen Iame whlteboy

[@illnatured55]

Legend, thanks so much!

[@idonnigga]

illnatured55 Iame whltegirI

[@martinesse4830]

Will a newer version of JDK work? I have java 16 installed.

[@idonnigga]

Martinesse Iame whlteboy

[@youngkr8tive903]

I tried to connect as SYSDBA but when I clicked "test" it threw this error Status : Failure -Test failed: ORA-01031: insufficient privileges

[@udaykiran557]

i.e user don't have SYSDBA privilege. connect sys as sysdba. Bydefault oracle providew two administratice user, those are SYS and SYSTEM

[@idonnigga]

YOUNG Iame whlteboy

[@idonnigga]

Iame whlteboy

[@aejazkhan2693]

First 30 minutes completely waste of time...

[@Oblivion171]

You are wasting your time by leaving your negative comment here. Nobody told you to waste your time here. Go use your valuable time somewhere else

[@idonnigga]

Aejaz Iame whlteboy

[@idonnigga]

Aejaz K i II

[@idonnigga]

yoself

[@Arisawa_Heavy_Ind]

So true, why would anyone want to know how to actually install and set up the program you learn about so you can actually use it? Are you stupid or something?