08-506 668 00
Training You Can Trust®
 
 

Oracle Database 10g: A Comprehensive Hands-On Introduction

Developing Database Applications with SQL and PL/SQL
 
Kurs: 593   Längd: 5 dagar
 
 

You Will Learn How To

  • Build, query and manipulate Oracle 10g databases to create powerful applications
  • Retrieve and manipulate data efficiently using powerful SQL features
  • Create and manage database tables, views and sequences
  • Maintain data integrity and enforce security with privileges and roles
  • Compose reusable structured PL/SQL code with cursors and procedures
  • Enhance performance through indexes and PL/SQL optimisation

Course Benefits

To efficiently handle today's business-critical information, organisations count on database systems that are reliable and scalable, and on experienced professionals to manage them. In this course, you gain the practical knowledge and skills required to leverage the Oracle Database 10g server. Hands-on exercises provide experience in applying relational database concepts, leveraging the SQL language and programming with PL/SQL.

Who Should Attend

Those interested in Oracle 10g. Relational database experience and familiarity with basic programming concepts are useful. Oracle experience is not required.

Hands-On Training

Exercises provide experience creating robust and powerful applications with Oracle 10g, including:
  • Creating tables, views and sequences
  • Producing queries using joins, set operators, groupings and subqueries
  • Merging large datasets and inserting across multiple tables
  • Imposing business rules with declarative constraints
  • Enforcing security with roles
  • Enhancing performance with indexes
  • Controlling logic and handling exceptions
  • Building PL/SQL procedures, triggers and packages

Related Courses

  • 594 Oracle Database 10g Administration UK course
  • 492 Oracle-databaser: applikationsutveckling
  • 493 Oracle PL/SQL: programmering
  • 234 Developing SQL Queries for Oracle Databases UK course
  • 137 SQL Server 2008: omfattande introduktion
  • 138 SQL Server 2008: databasadministration
  • 925 SQL programmeringsspråk: introduktion

 
Oracle is a registered trademark of Oracle Corporation. 		  Oracle Database 10<i>g</i> Comprehensive Introduction

Kursschema

Learning Tree AnyWareDu kan gå de överstrukna kurserna i klassrummet eller live, online via Learning Tree AnyWareTM.

Storbritannien

26 - 30 marsLondon 
3 - 7 sepLondon 

USA

13 - 17 febNew York 

När du ska gå en AnyWare-kurs bör du anmäla dig minst 10 dagar före kursstart.


För fler kursdatum besök www.learningtree.se
 
http://www.learningtree.se/courses/se593.htm
 
 
08-506 668 00
Training You Can Trust®
 
 

Oracle Database 10g: A Comprehensive Hands-On Introduction

Developing Database Applications with SQL and PL/SQL
 
Kurs: 593   Längd: 5 dagar
 
 
Course Content
 

Oracle 10g Technology Overview

  • Relational database concepts
  • Logical data modelling
  • Specifying attributes, entities, relationships and candidate keys
  • Installation, configuration and architecture
  • Defining SGA, processes and database files

Retrieving and Controlling Data

Working with SQL*Plus and iSQL*Plus

  • Configuring environment settings
  • Defining connections using login.sql
  • Implementing case-insensitive queries

Assessing SQL fundamentals

  • Selecting, filtering and ordering results
  • Avoiding pitfalls in null values
  • Pattern matching with regular expressions
  • Combining result sets with set operators

Exploiting SQL techniques

  • Oracle joins vs. ANSI joins
  • Outer joins and self joins
  • Grouping and aggregating data
  • Simple and correlated subqueries
  • Comparing CASE and DECODE functions

Manipulating data

  • Streamlining DML with MERGE
  • Locking data and managing transactions

Designing and Formulating the Database

Applying the physical design

  • Mapping logical model to physical design
  • Establishing a storage framework
  • Creating users and schemas
  • Defining LOB and TIMESTAMP data

Constructing and managing tables

  • Building tables with CREATE TABLE
  • Altering and dropping tables
  • Restoring data with Flashback
  • Accessing OS files with external tables
  • Leveraging the data dictionary

Developing views and sequences

  • Assembling views to filter data
  • Generating unique IDs using sequences

Maintaining integrity

  • Determining referential integrity
  • Imposing business rules with CHECK constraints
  • Handling data with deferred and enforced constraints

Optimising Server Programming

Invoking PL/SQL fundamentals

  • Declaring variables and constants
  • Defining stored procedures and functions
  • Writing structured code with %TYPE and %ROWTYPE

Establishing program control

  • IF...THEN...ELSE vs. CASE statements
  • Creating WHILE LOOPs and FOR LOOPs
  • Error handling with predefined exceptions

Operating with cursor types

  • Controlling implicit and explicit cursors
  • Passing parameters to cursors
  • Simplifying cursors with FOR LOOPs
  • Improving performance with ROWID
  • Handling concurrency with FOR UPDATE

Implementing Development Techniques

Assembling triggers

  • Distinguishing statement and row triggers
  • Regulating triggers with predicates
  • Building triggers to validate, derive and audit data

Constructing procedures and packages

  • Choosing best parameter types
  • Creating and administering packages
  • Advantages of employing packages
  • Debugging programs with DBMS_OUTPUT

Advancing Security and Performance

Enforcing security

  • Verifying with password aging
  • Classifying system and object privileges
  • Controlling access with roles
  • Accessing schemas via synonyms

Enriching performance

  • Guidelines for defining optimal indexes
  • Creating unique, non-unique and composite indexes
  • Monitoring index usage
 
http://www.learningtree.se/courses/se593.htm
 
 
08-506 668 00
Training You Can Trust®
 
 

Oracle Database 10g: A Comprehensive Hands-On Introduction

Developing Database Applications with SQL and PL/SQL
 
Kurs: 593   Längd: 5 dagar
 
 
Kurspriser
25 950 krOrd. Pris
kurspriser med
rabattprogram
14 300 krMed Treklöver
12 975 krMed Fyrklöver
17 350 krMed Företagskort -
10-kort
21 700 krMed ProPack 40
Alla priser i SEK, exkl moms.

I kursavgiften ingår bl a...

  • Kursplats
  • Gruppövningar
  • Tillgång till klassrumsutrustning
  • Omfattande kursmaterial
  • Lunch
  • För- och eftermiddagsfika
  • Kursdiplom
  • Kostnadsfritt deltagande i våra specialiserade Certifieringsprogram (inkl. tillhörande examenstester)
  
 

Nyttja våra förmånliga erbjudanden och avtal

Learning Trees Två-, Tre- och Fyrklöver
  • Personligt rabattprogram med 2, 3 eller 4 valfria kurser
  • Upp till 50 % rabatt per kurs jämfört med ord. pris
  • Läs mer på www.learningtree.se/klover
Learning Trees Företagskort
  • Flexibelt och kostnadseffektivt som ger upp till 35 % rabatt kurs jämfört med ord. pris
  • Utbilda valfri medarbetare, när som helst och var som helst under 12 månader
  • Läs mer på www.learningtree.se/foretagskort

Vi garanterar att du blir nöjd

Om du inte känner dig 100 % övertygad om att Learning Tree har levererat vad du förväntat dig så tar vi inte ut någon avgift för ditt kursdeltagande. Vår kvalitetsgaranti ger den enskilde deltagaren möjlighet att efter genomförd kurs endast betala om kursen uppfyller deltagarens förväntningar.

Boka dig idag!

Vårt omfattande kursschema ger dig möjlighet att välja både datum och kursort för din utbildning. Ring 08-506 668 00 eller boka dig online.
 
http://www.learningtree.se/courses/se593.htm