Overview/Description:
To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces
Target Audience:
Anyone wanting to learn about Oracle Database 10g database administrationPrerequisites:An understanding of database concepts and technologies
Objectives:
identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus. recognize how to use the DESCRIBE, PROMPT, and SELECT commands to work with data. recognize how to join tables and use DML and DDL statements to manipulate and define data. identify the functions of different SQL statements and recognize the function of data locking. identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus. use SQL*Plus and iSQL*Plus to manage data. identify the basic elements of PL/SQL and recognize the uses of PL/SQL. identify the characteristics of some common database interfaces. identify how Oracle works with common database interfaces.
http://rapidshare.com/files/56831055/SkillSoft.Oracle.Database.10g.Database.Interfaces.Release.2-LiB.rar
Saturday, September 18
Oracle 10g Release 2 Data Mining Administrator's Guide
Oracle 10g Release 2 Data Mining Administrator's Guide + Application Developer's Guide
ISBN B14338-02 Release date Nov 2005 Language English PDF 1.5Mb
http://rapidshare.com/files/64069029/Oracle10gDMGuide.rar
ISBN B14338-02 Release date Nov 2005 Language English PDF 1.5Mb
http://rapidshare.com/files/64069029/Oracle10gDMGuide.rar
Oracle 10g Workflow Administrator's Guide
ISBN B1585202 Release date Jun 2005 Language English PDF 1.9Mb
http://rapidshare.com/files/65037610/Oracle_10g_Workflow_Administrator_s_Guide.rar
http://rapidshare.com/files/65037610/Oracle_10g_Workflow_Administrator_s_Guide.rar
http://rapidshare.com/files/65037610/Oracle_10g_Workflow_Administrator_s_Guide.rar
http://rapidshare.com/files/65037610/Oracle_10g_Workflow_Administrator_s_Guide.rar
Oracle 10g Advanced Replication
ISBN B1422601 Release date Jun 2005 Language English PDF 2.2Mb
http://rapidshare.com/files/67257528/Oracle_10g_Advanced_Replication_by_fantoom121.rar
http://rapidshare.com/files/67257528/Oracle_10g_Advanced_Replication_by_fantoom121.rar
Oracle 10g Release 3 Enterprise Manager Advanced Configuration
ISBN B40002-02 Release date Feb 2007 Language English PDF 3.2Mb
http://rapidshare.com/files/64067819/Oracle10gAdvancedConfiguration.rar
http://rapidshare.com/files/64067819/Oracle10gAdvancedConfiguration.rar
Oracle 9i PowerPoint Slides
Develop Applications with BC4J
Oracle9i Access the DB with Java
Oracle9i AS Portal Build Corporate Portals
Oracle9i AS Portal Build Portlets with Java
Oracle9i Develop Applications with Enterprise JavaBeans
http://rapidshare.com/files/28187462/Develop_Applications_with_BC4J.rar
http://rapidshare.com/files/28187844/Oracle9i_Access_the_DB_with_Java.rar
http://rapidshare.com/files/28189353/Oracle9i_AS_Portal_Build_Corporate_Portals.rar
http://rapidshare.com/files/28191265/Oracle9i_AS_Portal_Build_Portlets_with_Java.rar
http://rapidshare.com/files/28193143/Oracle9i_Develop_Applications_with_Enterprise_JavaBeans.rar
Password: www.flibrary.org
Oracle9i Access the DB with Java
Oracle9i AS Portal Build Corporate Portals
Oracle9i AS Portal Build Portlets with Java
Oracle9i Develop Applications with Enterprise JavaBeans
http://rapidshare.com/files/28187462/Develop_Applications_with_BC4J.rar
http://rapidshare.com/files/28187844/Oracle9i_Access_the_DB_with_Java.rar
http://rapidshare.com/files/28189353/Oracle9i_AS_Portal_Build_Corporate_Portals.rar
http://rapidshare.com/files/28191265/Oracle9i_AS_Portal_Build_Portlets_with_Java.rar
http://rapidshare.com/files/28193143/Oracle9i_Develop_Applications_with_Enterprise_JavaBeans.rar
Password: www.flibrary.org
Oracle 10g - Powerpoint tutorial slides
Inlcudes:
Fundamentals I
Fundamentals II
SQLPL/SQL
Forms Developer
http://rapidshare.de/files/14385353/Oracle_10g_PPTs.rar
Fundamentals I
Fundamentals II
SQLPL/SQL
Forms Developer
http://rapidshare.de/files/14385353/Oracle_10g_PPTs.rar
Oracle 10g - PowerPoint Tutorial Slides Part 2
Oracle 10g Build J2EE Applications
Oracle Forms Developer 10g Build Internet Application
Oracle 10g Java Programming
Oracle JDeveloper 10g Build Applications with ADF
OracleAS Portal 10g Build Portlets with PLSQL
http://rapidshare.com/files/26216219/Oracle_10g_Build_J2EE_Applications.rar
http://rapidshare.com/files/26379280/Oracle_Forms_Developer_10g_Build_Internet_Application.rar
http://rapidshare.com/files/26380561/Oracle_10g_Java_Programming.rar
http://rapidshare.com/files/26381588/Oracle_JDeveloper_10g_Build_Applications_with_ADF.rar
http://rapidshare.com/files/26381749/OracleAS_Portal_10g_Build_Portlets_with_PLSQL.rar
Password www.flibrary.org
Oracle Forms Developer 10g Build Internet Application
Oracle 10g Java Programming
Oracle JDeveloper 10g Build Applications with ADF
OracleAS Portal 10g Build Portlets with PLSQL
http://rapidshare.com/files/26216219/Oracle_10g_Build_J2EE_Applications.rar
http://rapidshare.com/files/26379280/Oracle_Forms_Developer_10g_Build_Internet_Application.rar
http://rapidshare.com/files/26380561/Oracle_10g_Java_Programming.rar
http://rapidshare.com/files/26381588/Oracle_JDeveloper_10g_Build_Applications_with_ADF.rar
http://rapidshare.com/files/26381749/OracleAS_Portal_10g_Build_Portlets_with_PLSQL.rar
Password www.flibrary.org
Oracle 10g - PowerPoint Tutorial Slides Part 1
Oracle 10g Forms
Oracle 10g Reports
Oracle 10g SQL Fundamentals I
Oracle 10g SQL Fundamentals II
http://rapidshare.com/files/26183852/Oracle_10g_Forms__PPT_.rar
http://rapidshare.com/files/26185647/Oracle_10g_Reports__PPT_.rar
http://rapidshare.com/files/26186990/Oracle_10g_SQL_Fundamentals_I.rar
http://rapidshare.com/files/26181717/Oracle_10g_SQL_Fundamentals_II.rar
Password: www.flibrary.org
Oracle 10g Reports
Oracle 10g SQL Fundamentals I
Oracle 10g SQL Fundamentals II
http://rapidshare.com/files/26183852/Oracle_10g_Forms__PPT_.rar
http://rapidshare.com/files/26185647/Oracle_10g_Reports__PPT_.rar
http://rapidshare.com/files/26186990/Oracle_10g_SQL_Fundamentals_I.rar
http://rapidshare.com/files/26181717/Oracle_10g_SQL_Fundamentals_II.rar
Password: www.flibrary.org
Oracle 9iAS Portal Bible
This is your complete reference to Oracle Portal — the next generation release of Oracle WebDB, which provides a secure and manageable framework for delivering access to distributed software services and information resources.
Oracle9iAS Portal Bible shows you how to use Oracle Portal to build and deploy enterprise portals. Tthis book is for experienced Oracle users, developers, and database administrators looking for a more efficient means for delivering data to employees and customers over a web-based network. The book includes a complete and in-depth exploration of the various components of Oracle Portal and also shows you how to use the SiteBuilder component of Oracle Portal to create and manage Web sites. You’l learn how to create and deploy portlets and understand how to use the portlet API to extend the functionality of their components. Other topics covered in the book are integrating Oracle Portal’s functions with those of legacy applications; administering completed web applications using built-in management and performance monitoring functions; and creating, integrating, and customizing portlets.
http://www.mytempdir.com/277171
Oracle9iAS Portal Bible shows you how to use Oracle Portal to build and deploy enterprise portals. Tthis book is for experienced Oracle users, developers, and database administrators looking for a more efficient means for delivering data to employees and customers over a web-based network. The book includes a complete and in-depth exploration of the various components of Oracle Portal and also shows you how to use the SiteBuilder component of Oracle Portal to create and manage Web sites. You’l learn how to create and deploy portlets and understand how to use the portlet API to extend the functionality of their components. Other topics covered in the book are integrating Oracle Portal’s functions with those of legacy applications; administering completed web applications using built-in management and performance monitoring functions; and creating, integrating, and customizing portlets.
http://www.mytempdir.com/277171
Oracle Dba Made Simple: Oracle Database Administration Techniques (Oracle In-Focus Series)
Oracle Dba Made Simple: Oracle Database Administration Techniques (Oracle In-Focus Series) Mike Ault ISBN: 097407165X Publisher: Rampant Tech Press - 2003-08
http://rapidshare.com/files/38089491/Oracle_DBA_Made_Simple_Oracle_Database_Administration_Techniques.rar
Password: www.blueportal.org
http://rapidshare.com/files/38089491/Oracle_DBA_Made_Simple_Oracle_Database_Administration_Techniques.rar
Password: www.blueportal.org
SQL Functions Programmer's Reference
Author(s) : Arie Jones, Ryan K. Stephens, Ronald R. Plew, Robert F. Garrett, Alex KriegelPublisher : WroxYear : Apr 2005ISBN 10 : 0764569015ISBN 13 : 9780764569012Language : EnglishPages : 790File type : PDFSize : 2.7 MB
This book is a complete SQL functions reference for all of the major RDBMS vendors in today’s market. The SQL implementations covered in this book include ANSI SQL, Oracle, Microsoft SQL Server, Sybase, IBM Universal Database (UDB) DB2, MySQL, and PostgreSQL. As a SQL programmer, you will find that there is a growing need to effectively use SQL functions, yet there are few resources to serve as an aid. You will also encounter the need to cross-reference different SQL implementations, at times having to integrate data between, say, Oracle and SQL Server.Migrations of data from one implementation to another is also very common in data warehousing environments, and as organizations make the commitment to go with another vendor’s relational database management system (RDBMS) to better support evolving business needs. This book is the necessary tool to facilitate expedient function referencing, cross-referencing between implementations, creating userdefined functions (UDFs), and providing tips and examples for applying the use of functions to real-world data-retrieval situations.This book is for the SQL programmer, and any software developer who has a need to effectively retrieve data from a relational database, or to integrate applications with RDBMS implementations. Database administrators and other database users will also discover great value. This book is for readers of all levels, and has been organized in an easy-to-understand format that allows quick search and reference. This book is packed with realistic examples, allowing the reader to immediately apply SQL functions concepts to the job at hand.Although the intent of this book is not to teach you SQL, the introductory chapters we have provided serve as an introduction to the world of SQL, explaining basic SQL concepts and describing how to use SQL to query a database, either with or without the use of functions. The trailing chapters of this book show numerous applications of SQL functions in the modern database world.
http://rapidshare.com/files/67119817/sqlfuncprogref.rar
password:ganelon
This book is a complete SQL functions reference for all of the major RDBMS vendors in today’s market. The SQL implementations covered in this book include ANSI SQL, Oracle, Microsoft SQL Server, Sybase, IBM Universal Database (UDB) DB2, MySQL, and PostgreSQL. As a SQL programmer, you will find that there is a growing need to effectively use SQL functions, yet there are few resources to serve as an aid. You will also encounter the need to cross-reference different SQL implementations, at times having to integrate data between, say, Oracle and SQL Server.Migrations of data from one implementation to another is also very common in data warehousing environments, and as organizations make the commitment to go with another vendor’s relational database management system (RDBMS) to better support evolving business needs. This book is the necessary tool to facilitate expedient function referencing, cross-referencing between implementations, creating userdefined functions (UDFs), and providing tips and examples for applying the use of functions to real-world data-retrieval situations.This book is for the SQL programmer, and any software developer who has a need to effectively retrieve data from a relational database, or to integrate applications with RDBMS implementations. Database administrators and other database users will also discover great value. This book is for readers of all levels, and has been organized in an easy-to-understand format that allows quick search and reference. This book is packed with realistic examples, allowing the reader to immediately apply SQL functions concepts to the job at hand.Although the intent of this book is not to teach you SQL, the introductory chapters we have provided serve as an introduction to the world of SQL, explaining basic SQL concepts and describing how to use SQL to query a database, either with or without the use of functions. The trailing chapters of this book show numerous applications of SQL functions in the modern database world.
http://rapidshare.com/files/67119817/sqlfuncprogref.rar
password:ganelon
High Performance Oracle (with source code)
Author(s) : Geoff IngramPublisher : WileyYear : Sep 2002ISBN 10 : 0471224367ISBN 13 : 9780471224365Language : EnglishPages : 720File type : PDFSize : 2.6 MB (book + source code)
The purpose of this book is to help organizations deploy Oracle8i and Oracle9i (including Release 2) systems that meet the key end-user requirements of performance and availability at the same time. The ability to deliver on these twin requirements requires a holistic approach to the design and build of the end-to-end Oracle system, and this holistic approach is at the heart of this book. Too often, insufficient emphasis is given to components that are not related to the server. For example, consider a scenario where an Oracle end-user application uses a local configuration file (tnsnames.ora) to locate an Oracle database.If the database relocates to a new server one weekend, and the configuration file change is overlooked, end users won’t be able to connect on Monday morning. The database may as well be down. From the end-user perspective, it is. In the worst case, the outage could affect the organization’s bottom line. Appropriate network configuration, based on a centralized naming service, is a critical success factor for delivering availability. A similar emphasis is required on all aspects of the Oracle configuration, from initial installation to production support, in order to meet performance and availability requirements.This book is divided into six parts, which are intended to cover subjects in the order you might address them when setting up an Oracle configuration from scratch. In order to get the most out of the book, the best approach is to read it from cover to cover in sequential order. The detail is important, and a lack of attention to detail in all relevant areas of the technology is based on personal experience significant reason why Oracle systems don’t meet end-user performance and availability requirements.This book is intended for both DBAs and developers of all levels. In many ways, the term advanced in the Oracle world is something of a misnomer. The scope of what Oracle provides is very extensive: There’s a lot to know, but most of it is not especially complex. Anyone who understands Oracle fundamentals can understand and benefit from the contents of this book and Oracle’s own Concepts Guide is a great place to start. The challenge comes in deploying systems based on techniques that work from the many techniques available. This book sets out to provide a fast track to deploying systems with performance and availability built in.
http://rapidshare.com/files/62272665/hiperforac.rar
password:ganelon
The purpose of this book is to help organizations deploy Oracle8i and Oracle9i (including Release 2) systems that meet the key end-user requirements of performance and availability at the same time. The ability to deliver on these twin requirements requires a holistic approach to the design and build of the end-to-end Oracle system, and this holistic approach is at the heart of this book. Too often, insufficient emphasis is given to components that are not related to the server. For example, consider a scenario where an Oracle end-user application uses a local configuration file (tnsnames.ora) to locate an Oracle database.If the database relocates to a new server one weekend, and the configuration file change is overlooked, end users won’t be able to connect on Monday morning. The database may as well be down. From the end-user perspective, it is. In the worst case, the outage could affect the organization’s bottom line. Appropriate network configuration, based on a centralized naming service, is a critical success factor for delivering availability. A similar emphasis is required on all aspects of the Oracle configuration, from initial installation to production support, in order to meet performance and availability requirements.This book is divided into six parts, which are intended to cover subjects in the order you might address them when setting up an Oracle configuration from scratch. In order to get the most out of the book, the best approach is to read it from cover to cover in sequential order. The detail is important, and a lack of attention to detail in all relevant areas of the technology is based on personal experience significant reason why Oracle systems don’t meet end-user performance and availability requirements.This book is intended for both DBAs and developers of all levels. In many ways, the term advanced in the Oracle world is something of a misnomer. The scope of what Oracle provides is very extensive: There’s a lot to know, but most of it is not especially complex. Anyone who understands Oracle fundamentals can understand and benefit from the contents of this book and Oracle’s own Concepts Guide is a great place to start. The challenge comes in deploying systems based on techniques that work from the many techniques available. This book sets out to provide a fast track to deploying systems with performance and availability built in.
http://rapidshare.com/files/62272665/hiperforac.rar
password:ganelon
Subscribe to:
Posts (Atom)