Oracle database tips logo
Article categories | Blog and News Page | SQL | SQL*Plus | DBA Scripts | Standby dbs | Database Links | Techno webcasts | Oracle Magazine | Free IT Magazines | Oracle Database Hosting Companies | Site Search |
RSS
XML RSS
What is this?
AddThis Feed Button

Social Bookmarking
- Found on the internet ! -

Oracle workbooks

Download Oracle Books



- Featured ebook -

Database Normalization
by Alf Pedersen

Database Normalization ebook Understand and master how to normalize a database using methods richly documented with graphical ERD and server diagram examples

NoAdware Free Trial

NoAdware Remove
harmful
adware,
spyware,
trojans,
dialers
and worms!
-- FREE --
IT Magazine
Subscriptions

WebSite Magazine WebSite Magazine Practical advice, helpful tools and insights for website owners

Oracle Magazine Oracle Magazine Contains technology strategy articles, sample code, tips, Oracle and partner news, how-to articles for developers and DBAs

Dr Dobb's Journal Dr Dobb's Journal enables coders to write the most efficient programs and help in daily programming quandaries

DM Review DM Review is recognized as the premier business intelligence, analytics and data warehousing publication
Various other Free IT magazine subscriptions

Oracle SQL Tutorials.



Pick any one of these friendly Oracle SQL Tutorials below.

Each one has been selected considering the time constraints of
busy IT professionals today.

Start at the beginning and work your way through them all,
you will be comfortably mastering Oracle SQL in no time.

Need a quicker route?
Pick the page that suits your interest and come back to the earlier ones if you need to.

  • Oracle SQL Background Info
    Shows you the basics of tables, indexes and normalization and won't bore you
    with the history of Oracle.

  • Select
    Allows you to query the data in the tables and limit the result based on columns or rows.

  • Insert
    To add data to your tables, you will use the Insert statement, easy examples in the tutorial.

  • Update
    Syntax description of the Oracle Update clause and examples to change table data.

  • Delete
    Delete unwanted data easily from your table using the Oracle Delete statement.

  • Oracle Subquery
    Create more complex SQL by using normal and correlated subqueries.

  • Oracle Joins

  • Oracle Functions
    Provides a descriptive list with examples of some of the more commonly used functions.

  • Oracle Datatypes

  • Oracle Constraints
    Foreign key, check, not-null, primary and unique constraints are explained here.

  • Oracle Triggers


Recommended reading:

  • Oracle online documentation: OracleŽ Database SQL Reference



  • Return from oracle sql tutorials to oracle-database-tips home.