If you are looking to learn Oracle SQL by your own, then this is the right place for you. This website content is designed in such a way that you can easily understand all the concepts of SQL theoretically as well as practically for Oracle Database. Let us have a glance at below sections of SQL tutorial.
1. Oracle SQL Introduction.
SQL or Structured Query Language is used to store, modify and retrieve data from database system. In order to access data from database, you need to write SQL queries. The data from database can be deleted, updated and retrieved by writing simple SQL commands. Before learning SQL commands, let us take a overview of the Database design.
2. What is Database?
Database is a storage unit which is used to store and access related information. You can easily maintain huge amount of data in a single database server. It makes easy to manage data in a multi-user environment where all users access database concurrently.
In Database, the data is stored in the form of Table. Each table contains specific information like Employee details, Sales details, Customer details etc. The table contains many number of rows and columns as per the user requirement. Each column in the table is referred to as 'Field'.
3. SQL Statements
SQL has many statements that are used to perform actions on Oracle database.
Some simple SQL statements are like
SELECT
UPDATE
DELETE
are used to perform actions on Oracle database.
The detailed explanation of how to write SQL queries to fetch, modify or delete data from database will be explained in the next section.
No comments:
Post a Comment