Oracle SQL in 10 Minutes - Asim Abbasi
CH1: SQL Basics | CH2: SQL Operators | CH3: SQL Built-in Functions | CH4: SQL Joins | CH5: UPDATE, INSERT & DELETE Statements | CH6: CREATE, ALTER & DROP Statements | CH7: Constraints | CH8: Linking Tables vs Joining Tables | CH9: SQL Statements for Other Database Objects | CH10: SQL Statements for Database Security
Chapter 1: SQL Basics
Oracle is such a complex system that without
analogies it’s really very hard to comprehend and grasp the concept of
Oracle architecture and it’s working. If you are new to Oracle or an
experienced DBA, understanding of concepts is the key to success not
only in Oracle Certifications but in real world. Also once you
understand the concepts then there is nothing left for cramming.
Oracle System is basically divided into two things namely Oracle
Instance and Oracle Database. We have taken the analogy of a Genie
(Ghost/Djin): just like the one you might have seen in the movie/story
of “Aladdin & the Magic Lamp”. When Aladdin rubbed the lamp; Genie
became available and fulfilled all his commands. Similarly when you
double click “Oracle” icon in your system, Oracle Instance gets alive
and waits for users information/data related commands to fulfill, as it
is a magnificent “Data Management Genie”.
Oracle Instance is something with which users interact in terms of storing and retrieving information. Anything that is going into the database or coming out of the database has to be through Oracle Instance and to communicate with Oracle Instance we need to learn Genie’s language: SQL. So after learning SQL, Aladdin will be fully capable to command the Instance.
Figure 1: The Complete Oracle System: Oracle Instance
+ Oracle Database.
________________________________________
Chapter 1: Overview
CH1: SQL Basics | CH2: SQL Operators | CH3: SQL Built-in Functions | CH4: SQL Joins | CH5: UPDATE, INSERT & DELETE Statements | CH6: CREATE, ALTER & DROP Statements | CH7: Constraints | CH8: Linking Tables vs Joining Tables | CH9: SQL Statements for Other Database Objects | CH10: SQL Statements for Database Security
Share with others: