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

Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated. This course is designed to teach you the fundamentals of SQL using Oracle Database 11g database technology.

Learn To:

  • Develop essential SQL skills that enable developers to write queries against single and multiple tables.
  • Manipulate data in tables.
  • Create database objects.
  • Use single row functions to customize output.
  • Work with group functions to report aggregated data.
  • Use conversion functions and conditional expressions.
  • Manipulate queries to return required data.
  • Perform calculations on data.
  • Administer database objects.

Audience
  • Database Admi…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle 11G, PL/SQL, Oracle, CompTIA A+ / Network+ / Security+, and IT Security.

Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated. This course is designed to teach you the fundamentals of SQL using Oracle Database 11g database technology.

Learn To:

  • Develop essential SQL skills that enable developers to write queries against single and multiple tables.
  • Manipulate data in tables.
  • Create database objects.
  • Use single row functions to customize output.
  • Work with group functions to report aggregated data.
  • Use conversion functions and conditional expressions.
  • Manipulate queries to return required data.
  • Perform calculations on data.
  • Administer database objects.

Audience
  • Database Administrators
  • Database Designers
  • Support Engineer
  • Developer
  • Technical Administrator

Course Topics 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

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

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.