Oracle's 11g 2-Day Database and .NET Developer's Course
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
- 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 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
- 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
- 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
- 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
- Introduction to Global Applications
- Developing Global Applications with the .NET Framework
- Presenting Data in the Correct User Local Convention
- Synchronizing the .NET and Oracle Database Locale Environments
- Client Globalization Support in Oracle Data Provider for .NET
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: 13% [?]
Related Posts:
Tags for this post>> Oracle | SQL