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