Oracle Database 11g: SQL Fundamentals I (Self-Study Course)

 

Who should attend

  • Database administrators
  • Database designers
  • Developers

Prerequisites

  • Familiarity with data processing concepts and techniques
  • Ability to use a graphical user interface (GUI)

Course Objectives

  • To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting
  • To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return value
  • To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE
  • To recognize the steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries

Product Description

  • Oracle Database 11g: Using SQL to Query Your Database
    • Using SQL in Oracle Database 11g
    • Retrieving, Restricting and Sorting Data
    • Using Single-Row Functions
  • Oracle Database 11g: Conversion Functions, Group Functions, and Joins
    • Conversion Functions and Conditional Expressions
    • Group Functions and Joins
  • Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
    • Using Subqueries and Set Operators
    • Manipulating Data
  • Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
    • Using DDL Statements to Create and Manage Tables
    • Creating Other Schema Objects

Price on request