Oracle University Official Study Notes (ENG)

		Oracle DBA Forum
Oracle University Official Study Notes (ENG)

Подразделы : Oracle University Official Study Notes (ENG)

Искать в этом разделе

	Раздел	Последнее сообщение	Тем	Сообщений
Oracle 10g SQL Fundamentals
	Oracle 10g SQL Fundamentals I Contents: Introduction 01 Retrieving Data Using the SQL SELECT Statement 02 Restricting and Sorting Data 03 Using Single-Row Functions to Customize Output 04 Reporting Aggregated DataUsing the Group Functions 05 Displaying Data from Multiple Tables 06 Using Subqueries to Solve Queries 07 Using the Set Operators 08 Manipulating Data 09 Using DDL Statementsto Create and Manage Tables 10 Creating Other Schema Objects 11 Managing Objectswith Data Dictionary Views	11 Managing Objectswith Data... от Marley 26.12.2009 05:28	13	396
	Oracle 10g SQL Fundamentals II Contents: Introduction 01 Controlling User Access 02 Manage Schema Objects 03 Manipulating Large Data Sets 04 Generating Reports by GroupingRelated Data 05 Managing Data in Different Time Zones 06 Retrieving Data Using Subqueries 07 Hierarchical Retrieval 08 Regular Expression Support	08 Regular Expression Support от Marley 26.12.2009 06:38	10	218
Oracle 10g PL/SQL Fundamentals
	Oracle 10g PL/SQL Fundamentals Contents: Introduction 01 Introduction to PL/SQL 02 Declaring PL/SQL Variables 03 Writing Executable Statements 04 Interacting with the Oracle Server 05 Writing Control Structures 06 Working with Composite Data Types 07 Using Explicit Cursors 08 Handling Exceptions 09 Creating Stored Procedures and Functions	Introduction от Marley 25.01.2010 16:12	11	236
Oracle 10g PL/SQL Advanced
	Oracle 10g PL/SQL Advanced Contents: Introduction 01 PL/SQL Programming Concepts: Review 02 Design Considerations 03 Working with Collections 04 Advanced Interface Methods 05 PL/SQL Server Pages 06 Fine-Grained Access Control 07 Performance and Tuning 08 Analyzing PL/SQL Code	08 Analyzing PL/SQL Code от Marley 26.12.2009 20:16	10	265
Oracle 10g Develop PL/SQL Program Units
	Oracle 10g Develop PL/SQL Program Units Contents: Introduction 01 Creating Stored Procedures 02 Creating Stored Functions 03 Creating Packages 04 Using More Package Concepts 05 Utilizing Oracle-Supplied Packages in Application Development 06 Dynamic SQL and Metadata 07 Design Considerations for PL/SQL Code 08 Managing Dependencies 09 Manipulating Large Objects 10 Creating Triggers 11 Applications for Triggers 12 Understanding and Influencing the PL/SQL Compiler	12 Understanding and... от Marley 27.12.2009 18:54	14	337
Oracle 10g Reports Developer
	Oracle 10g Reports Developer Contents: Introduction 01 Introduction to Oracle Reports Developer 02 Designing and Running Reports 03 Working in Oracle Reports Developer 04 Creating a Paper Report 05 Enhancing a Basic Paper Report 06 Managing Report Templates 07 Creating a Web Report 08 Enhancing Reports Using the Data Model: Queries and Groups 09 Enhancing Reports Using the Data Model: Data Sources 10 Enhancing Reports Using the Data Model: Creating Columns 11 Enhancing Reports Using the Paper Layout 12 Controlling the Paper Layout: Common Properties 13 Controlling the Paper Layout: Specific Properties 14 Web Reporting 15 Extending Functionality Using XML 16 Creating and Using Report Parameters 17 Embedding a Graph in a Report 18 Enhancing Matrix Reports 19 Coding PL/SQL Triggers 20 Extending Functionality Using the SRW Package 21 Maximizing Performance Using OracleAS Reports Services 22 Building Reports: Efficiency Guidelines	22 Building Reports:... от Marley 23.01.2010 18:46	24	592
Oracle 10g Java Programming
	Oracle 10g Java Programming Contents: Introduction 01 Introducing the Java and Oracle Platforms 02 Defining Object-Oriented Principles 03 Basic Java Syntax and Coding Conventions 04 Exploring Primitive Data Types and Operators 05 Controlling Program Flow 06 Building Applications with Oracle JDeveloper 10g 07 Creating Classes and Objects 08 Object Life Cycle and Inner Classes 09 Using Strings, String Buffer, Wrapper and Text-Formatting Classes 10 Reusing Code with Inheritance and Polymorphism 11 Using Arrays and Collections 12 Structuring Code by Using Abstract Classes and Interfaces 13 Throwing and Catching Exceptions 14 User Interface Design: Swing Basics Planning the Application Layout 15 Adding User Interface Components and Event Handling 16 Using JDBC to Access the Database 17 Deploying Applications by Using Java Web Start	03 Basic Java Syntax and... от Marley 04.03.2010 12:57	19	461
Oracle 10g Build J2EE Apps
	Oracle 10g Build J2EE Apps Contents: 01 Introduction 02 J2EE Overview 03 Designing J2EE Applications 04 Creating the Web Tier: Servlets 05 Accessing the Database with Servlets 06 Using Advanced Techniques in Servlets 07 Maintaining State in J2EE Applications 08 Creating the Web Tier: JavaServer Pages 09 Modularizing JavaServer Pages Development with Tags 10 Communicating in J2EE 11 Creating the Business Tier: Enterprise JavaBeans 12 Implementing Business Tasks with Session EJBs 13 Managing Persistent Data in the Business Tier 14 Achieving State Management in the Business Tier 15 Container-Managed Relationships (CMRs) 16 Developing Message-Driven Beans 17 Integrating J2EE Components 18 Distributing Modular Applications: Introduction to Web Services 19 Distributing Modular Applications: Developing Web Services 20 Implementing Security in J2EE Applications 21 Oracle Application Server 10g Transaction Support	21 Oracle Application Server... от Marley 17.01.2010 07:42	22	623
Oracle 10g Performance Tuning
	Oracle 10g Performance Tuning Contents: 01 Introduction 02 Performance Tuning: Overview 03 Statistics and Wait Events 04 Metrics, Alerts, and Baselines 05 Using Statspack 06 Using Automatic Workload Repository 07 Reactive Tuning 08 Tuning the Shared Pool 09 Tuning the Buffer Cache 10 Automatic Shared Memory Management 11 Checkpoint and Redo Tuning 12 Tuning I/O 13 Tuning PGA and Temporary Space 14 Tuning Block Space Usage 15 Performance Tuning: Summary	15 Performance Tuning: Summary от Marley 27.12.2009 23:45	16	515
Oracle 10g SQL Tuning
	Oracle 10g SQL Tuning Contents: 01 Oracle Database Architecture: Overview 02 Following a Tuning Methodology 03 Designing and Developing for Performance 04 Introduction to the Optimizer 05 Optimizer Operations 06 Execution Plans 07 Gathering Statistics 08 Application Tracing 09 Identifying High-Load SQL 10 Automatic SQL Tuning 11 Index Usage 12 Using Different Indexes 13 Optimizer Hints 14 Materialized Views	14 Materialized Views от Marley 28.12.2009 05:25	15	387
Oracle 10g Backup and Recovery
	Oracle 10g Backup and Recovery Contents: 01 Introduction 02 Configuring for Recoverability 03 Using RMAN to Create Backups 04 Using RMAN to Perform Recovery 05 Using Oracle Flashback Technologies 06 Using RMAN to Create a Duplicate Database 07 Performing Tablespace Point-in-Time Recovery 08 Using the RMAN Recovery Catalog 09 Monitoring and Tuning RMAN 10 Oracle Secure Backup Overview 11 Installing Oracle Secure Backup 12 Using RMAN and Oracle Secure Backup 13 Backing Up File-System Fileswith Oracle Secure Backup 14 Restoring File-System Backupswith Oracle Secure Backup 15 Managing Oracle Secure Backup Security 16 Managing the Administrative Domain	16 Managing the... от Marley 29.12.2009 20:13	17	419
Oracle 11g SQL Fundamentals
	Oracle 11g SQL Fundamentals I Contents: Introduction 01 Retrieving Data Using the SQL SELECT Statement 02 Restricting and Sorting Data 03 Using Single-Row Functions to Customize Output 04 Using Conversion Functions and Conditional Expressions 05 Reporting Aggregated Data Using the Group Functions 06 Displaying Data from Multiple Tables 07 Using Subqueries to Solve Queries 08 Using the Set Operators 09 Manipulating Data 10 Using DDL Statements to Create and Manage Tables 11 Creating Other Schema Objects	11 Creating Other Schema... от Marley 26.12.2009 13:25	13	441
	Oracle 11g SQL Fundamentals II Contents: Introduction 01 Controlling User Access 02 Managing Schema Objects 03 Managing Objects with Data Dictionary Views 04 Manipulating Large Data Sets 05 Managing Data in Different Time Zones 06 Retrieving Data Using Subqueries 07 Regular Expression Support	07 Regular Expression Support от Marley 26.12.2009 14:30	9	267

	Есть новые сообщения
	Нет новых сообщений

Быстрый переход

Текущее время: 03:19. Часовой пояс GMT +3.