Intelligentedu Best New Free Computer IT Training Tutorial Resources

Here is a 2-day dotNEt Database Course from Oracle, titled Oracle Database 2 Day + .NET Developer's Guide 11g Release 1 (11.1). This will help you get started using the Oracle database with the .NET Framework, including the key features of Oracle Data Provider for .NET and Oracle Developer Tools for Visual Studio. Using this, you will learn how to install, configure, and build basic applications using Oracle .NET components and software. You will also learn how to create and work with PL-SQL and .NET stored procedures. Also check out the related documents linked below the table of contents. This guide is also available in pdf format.


Table of Contents for Oracle's 2 Day Database and .NET Developer's Course:

1 Introduction

• About This Guide
• What is the Microsoft .NET Framework
• Overview of Oracle Data Provider for .NET
• Overview of Oracle Developer Tools for Visual Studio
• Overview of .NET Stored Procedures
• Overview of Oracle Providers for ASP.NET

2 Installing .NET Products

• What You Need
  • Oracle Database
  • Sample Data
  • Oracle Data Access Components
  • Oracle Database Extensions for .NET
  • Visual Studio 2008
• Installing .NET Products
• Configuring a NET Connect Alias

3 Building a Simple .NET Application Using ODP .NET

• Creating a New Project
• Adding a Reference
• Adding Namespace Directives
• Designing the User Interface
• Writing the Connection Code
• Compiling and Running the Application
• Error Handling
  • Using Try-Catch-Finally Block Structure
  • Handling General Errors
  • Handling Common Oracle Errors

4 Retrieving and Updating with Oracle Data Provider for .NET

• Using the Command Object
• Retrieving Data: a Simple Query
• Retrieving Data: Bind Variables
• Retrieving Data: Multiple Values
• Using the DataSet Class with Oracle Data Provider for .NET
• Enabling Updates to the Database
• Inserting, Deleting, and Updating Data

5 Using Oracle Developer Tools for Visual Studio

• Using Oracle Developer Tools
• Connecting to the Oracle Database
• Creating a Table and Its Columns
• Creating a Table Index
• Adding Table Constraints
• Adding Data to a Table
• Generating Code Automatically to Display and Update Data

6 Using PL/SQL Stored Procedures and REF CURSORs

• Introduction to PL/SQL Stored Procedures
• Introduction to PL/SQL Packages and Package Bodies
• Introduction to REF CURSORs
• Creating a PL/SQL Stored Procedure that Uses REF CURSORs
• Modifying an ODP .NET Application to Run Stored Procedures
• Running a PL/SQL Stored Procedure Using an ODP .NET Application

7 Developing and Deploying .NET Stored Procedures

• Overview of .NET Stored Procedures
• Starting the Common Language Runtime Service
• Creating a Connection as SYSDBA
• Creating an Oracle Project
• Creating .NET Stored Functions and Procedures
• Deploying .NET Stored Functions and Procedures
• Running .NET Stored Functions and Procedures
• Running .NET Stored Procedure in a Query Window

8 Including Globalization Support

• Introduction to Global Applications
• Developing Global Applications with the .NET Framework
• Presenting Data in the Correct User Local Convention
  • Connecting to SQL*Plus
  • Using Oracle Date Formats
  • Using Oracle Number Formats
  • Using Oracle Linguistic Sorts
  • Oracle Error Messages
• Synchronizing the .NET and Oracle Database Locale Environments
• Client Globalization Support in Oracle Data Provider for .NET
  • Client Globalization Settings
  • Using Session Globalization Settings
  • Thread-Based Globalization Settings

Appendix A Starting and Stopping an Oracle Database Instance
Appendix B Copying a Form  Index


Related Training and Help Documents from Oracle:

• Oracle Data Provider for .NET Developer's Guide
• Oracle Database Extensions for .NET Developer's Guide
• Oracle Database 2 Day DBA
• Oracle Database 2 Day Developer's Guide

Popularity: 11% [?]

Related Posts:

Developing Oracle Database Applications with Visual Studio and .NET

Tutorials for .Net, ASP and Windows Web Developers

Free Book on ASP.NET 2.0

Free Microsoft ASP.NET 2.0 Webcast Series

Enterprise Library for .NET Framework 2.0

Tags for this post>> Oracle | SQL