SQL Developer

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.

At the end of the training, participants will be able to:

Pre-requisite

All attendees should have a basic knowledge of syntax.

Duarion

5  days

Course Outline

  1. Version History
  2. Feature Overview
  3. Development Tools
  1. Using Variables
  2. Control of Flow Statements
  3. Error Handling
  4. Using Cursors
  1. Creating Views
  2. Updating Through Views
  3. Indexed Views
  1. Creating Procedures
  2. Passing Parameters
  1. Scalar, Inline Table and Multi-Statement
  2. Data Manipulation in UDFs
  3. Profiling UDFs
  1. Trigger Syntax
  2. Trigger Events
  3. Enabling/Disabling Triggers
  4. Nested Triggers
  1. Ranking Functions
  2. Recursive Queries
  3. Relational Operators
  1. Data Definition Language Triggers
  2. DDL Event Notifications
  3. Metadata Views
  1. Architecture Overview
  2. Service Broker Example
  3. Conversation Architecture
  4. Conversation Process
  5. Security
  1. Work Flow and Data Flow
  2. Package Design
  3. Deployment
  4. Worked Examples
  1. XML Data Type
  2. FOR XML Enhancements
  3. OPENXML Enhancements
  4. XML Schemas
  5. XML Indexes
  1. Web Services Architecture
  2. Native HTTP Support
  3. HTTP Endpoint Declaration
  4. XML Input/Output Types
  1. Notification Applications
  2. Design Patterns
  3. Instance and Configuration Files
  1. Enabling the .NET CLR
  2. Creating Managed Stored Procedures
  3. Creating Managed UDFs
  4. Creating Managed Triggers
  1. ADO.NET Client Development
  2. ADO.NET Enhancements
  3. Asynchronous Support
  4. Snapshot Isolation
  5. Bulk Import
  1. Managing SQL Server
  2. Managing Replication
  1. Report Manager
  2. Report Server
  3. Creating Reports
  4. Deploying Reports
  5. Viewing Reports

Reviews