SQL fundamentals

Structured Query Language (SQL) is a standard language for accessing and manipulating databases. These fundamentals provide a starting point for the most common actions for working with SQL, with pointers to more in-depth documentation. The tutorial uses a sample database and explains key concepts.

• About the examples
• Conventions used
• SQL tutorial
  • Sample database
    • Accessing the sample database
    • Overview of the sample database
  • Creating a new table
  • Populating a table With rows
  • Querying a table
  • Executing joins between tables
    • Executing a join query
    • Executing an outer join
    • Executing a self join
  • Aggregating data
  • Updating a table
  • Deleting a table
  • The SQL language
• Advanced concepts
  • Views
  • Foreign keys
  • The ROWNUM pseudo-column
    • Limiting the number or rows returned
    • Adding a sequence number to rows in a table
  • Synonyms
    • Creating a synonym
    • Deleting a synonym
  • Hierarchical queries
    • Syntax
    • Examples
  • Hierarchical queries
    • Defining the parent/child relationship
    • Selecting the root nodes
    • Organization tree in the sample application
    • Designating the node level
    • Ordering the siblings
    • Retrieving the root node with CONNECT_BY_ROOT
    • Retrieving a path with SYS_CONNECT_BY_PATH
  • Multidimensional analysis
    • Aggregating results
  • Multidimensional analysis
    • Useful extensions
• Sample database description
  • Available scripts
  • About the sample database