Oracle Applications Using ADO.NET AND C#
Course Title: Oracle Applications Using ADO.NET AND C#
Course #: ADO7I
Duration: 5 days
Overview:
Oracle is a robust and powerful data storage engine that provides services on all levels of an application infrastructure – combining programmer-definable objects and tools, data manipulation tools that are capable of retrieving data from a host of data sources and storing those data in a database, and the capability to automate tasks and run them under developer control. This comprehensive, five-day course is designed to provide programmers an introduction to database programming, focusing on database design working with Oracle as your primary data store.
Topics:
Introduction to Oracle9i
Audience: Oracle programmers and database designers.
Prerequisites: .NET Framework fundamentals, including building simple Windows Forms and Web Forms applications. Exposure to relational databases of some sort and prior knowledge of Oracle is helpful, but not required.
Course #: ADO7I
Duration: 5 days
Overview:
Oracle is a robust and powerful data storage engine that provides services on all levels of an application infrastructure – combining programmer-definable objects and tools, data manipulation tools that are capable of retrieving data from a host of data sources and storing those data in a database, and the capability to automate tasks and run them under developer control. This comprehensive, five-day course is designed to provide programmers an introduction to database programming, focusing on database design working with Oracle as your primary data store.
Topics:
Introduction to Oracle9i
- Oracle RDBMS Terminology
- Oracle’s Physical Database Structures
- Oracle’s Logical Database Structures
- Oracle Segments
- Oracle Tablespaces
- Oracle Datafiles
- Oracle Redo Log Files
- Oracle Enterprise Manager
- Benefits of Oracle Enterprise Manager
- OEM Architecture
- Two-Tiered OEM
- Tier One: OEM Console
- OEM Console
- Tier Two: Oracle Management Server
- Multiple Management Servers
- Tier Three: Managed Nodes
- Intelligent Agents
- OEM Common Services
- Oracle Database Objects
- Oracle Table Functionality
- Relating Information Between Tables
- Using Table Aliases in SELECT Statements
- Oracle Procedural Functionality
- Oracle View Functionality
- Oracle Synonym Functionality
- Oracle Type Functionality
- Oracle Object Functionality
- Oracle Information Storage
- Using SQL*PLUS
- Relational Database Concepts
- High-Level Database Types: OLAP Databases
- High-Level Database Types: OLTP Databases
- High-Level Database Types: OLAP vs. OLTP
- Functions of a Relational Database
- Making the Conceptual Move
- Structuring Tables Using Keys
- Enforcing Relationships Using Foreign Keys
- Relating Foreign Keys and Primary Keys
- Second Normal Form
- Third Normal Form
- Deriving a Design from a Scenario
- Going to First Normal Form
- Going to Second Normal Form
- Going to Third Normal Form
- Oracle SQL Language
- Database Object Permissions
- Object Privileges
- System Privileges
- Roles: Groups of Privileges
- Using Roles to Manage User Permissions
- Data Definition Language (DDL) Statements: CREATE …
- Data Definition Language (DDL) Statements: DROP …
- Data Definition Language (DDL) Statements: ALTER …
- Data Modification (DML) Statements: INSERT …
- Retrieving Information from Tables: SELECT …
- Displaying Information from Tables: SELECT …
- Displaying Information from Tables: Customizing Output with Column Headers
- Using the WHERE Keyword to Select Specific Rows of Data
- Using Relational Operators in the WHERE Clause
- Using Pattern Matching in the WHERE Clause
- Checking for Known and Unknown Quantities in the Database
- Looking for Multiple Values in the Database: IN and BETWEEN
- Creating Complex Where Clauses
- Sorting Output from a SELECT Query
- Sub-Sorting Output from a SQL Query
- Sorting on Non-Displayed Columns
- Reversing Order of Sorting Output
- Removing Data From a Table: DELETE
- Modifying Existing Data in a Table: UPDATE
- Using Data Control Language (DCL) to Control Transactions in a Database
- Committing Changes
- Rolling Back Changes
- Organizing Information into Groups
- Using the GROUP BY Clause
- Aggregating Functions
- Using Aggregate Functions with GROUP BY
- Using Non-Aggregated Columns with a GROUP BY
- Joining Tables Using ANSI Standard Syntax
- Joining Tables Using Oracle Syntax
- Creating a Database
- Oracle’s Physical Database Structures
- Oracle’s Logical Database Structures
- Manually Creating a Database
- Explanation of CREATE DATABASE Command
- Using Control Files
- Guidelines for Creating Control Files
- Oracle Redo Log Files
- Creating New Tablespaces
- Review of CREATE TABLE
- Constraints That May be Added to a Table
- PRIMARY KEY Constraint
- Naming the Constraints
- UNIQUE Constraint
- Using the UNIQUE Constraint in Table Creation
- Specifying the Location of a Table
- Creating Stored Procedures and Functions
- Creating and Executing a Procedure
- Using Data Dictionary Views to See Information About Procedures
- Using the USER_SOURCE View
- Using Data Dictionary Views to Find Information about Tables
- Using Triggers
- Testing the Trigger
- Viewing the Contents of Triggers
- Overview of Indexes
- Creating Indexes
- Creating Unique and Non-Unique Indexes
- Building a Composite Index
- Using Indexes to Speed Data Retrieval
- Physical Storage of Indexes
- Creating an Index-Organized Table
- Hidden Indexes
- Creating a PRIMARY KEY Constraint Using an Explicit Index
- Tracking Usage of an Index
- Oracle Transactions
- Transaction Management Overview
- Marking your Place within a Transaction: SAVEPOINT
- Rolling Back Uncommitted Transactions: ROLLBACK
- Creating Transactions
- Implicit Transactions
- Locks
- Oracle Transactions and Database Concurrency
- Explicit (Manual) Data Locking
- Explicit (Manual) Locking at the Table Level
- Table Locking Modes
- Implicit Row Locking
- Implicit Row Locking using the FOR UPDATE OF Clause
- Serializable Isolation Level
- Modifying the Isolation Level
- Choosing an Isolation Level
- Recovery from a Serialization Error
- Isolation Levels and Internal Locking
- Oracle Programming Objects
- Benefits of PL/SQL
- Structure of a PL/SQL Block
- DECLARE Section
- PL/SQL Data types
- PL/SQL Control Structures
- PL/SQL Conditional Statements: IF
- PL/SQL Conditional Statements: CASE
- PL/SQL Iterative Statements: LOOP
- PL/SQL Iterative Statements: LOOP; EXIT; RETURN
- PL/SQL Iterative Statements: EXIT-WHEN
- PL/SQL Iterative Statements: WHILE … LOOP
- PL/SQL Iterative Statements: FOR … LOOP:
- PL/SQL Sequential Control: GOTO and NULL
- PL/SQL Error Handling: Exceptions
- Exception Handling Block
- Complete PL/SQL Block
- Managing Cursors
- Overview of Explicit Cursors
- Declaring a Cursor
- Declaring Cursors
- Simplifying Cursor Coding with a FOR Loop
- Instantiating User-Defined Data Types
- Creating and Using a User-Defined Data Type
- Introduction to XML
- Benefits of XML
- Selecting Elements from an XML Document
- Transforming an XML Document
- Structure of XSL Stylesheet
- Oracle Utilities and Technologies for Use with XML
- Creating a Well-Formed XML Document
- Rules for Well-Formatted XML Documents
- Document Type Definition (DTD)
- Storing XML Datagrams
- XML Extensions to Oracle
- Generating XML from a Table's Contents: DBMS_XMLGEN Package
- Generating XML from Existing Table Data
- Summary of DBMS_XMLGEN Methods
- Combining XSQL, XSLT and XML
- Retrieving Data: MODEL.XSQL
- Formatting the Data into XML: MODEL.XSL
Audience: Oracle programmers and database designers.
Prerequisites: .NET Framework fundamentals, including building simple Windows Forms and Web Forms applications. Exposure to relational databases of some sort and prior knowledge of Oracle is helpful, but not required.
Clients
