Shopping Cart
Your Cart is Empty
View Cart
  
 
 
 
Oracle 12c
Oracle 11g
Oracle 10g
Oracle Certification
Microsoft
Adobe & PHP
Free Oracle Training Software
Virtual Training With Sideris Courseware Textbooks
Train-the-trainer Workshops & Training
Press room: Sideris Courseware in the news
Downloads
About the Authors
Frequently Asked Questions
Become a Reseller
International Sales & Support
 
 
Textbooks & Training Courseware for
Information Technology Professionals

Oracle, Microsoft Office, Microsoft VBA programming, Adobe CS6 and PHP training materials

 
 
 
 
 

new

 
 

Learn from Sideris textbooks on Adobe CS6 products of Photoshop, Illustrator and InDesign as well as Adobe Acrobat XI and PHP. It's everything you need to enhance your photos, display them on your own website, fill it with images and put together the launch invitation. Learn how to create and edit PDF's with Acrobat and learn the fundamentals of PHP.

 

Exciting new technology replaces legacy Brava eBooks. Features: High-quality graphics for enhanced understanding of complex concepts, multi-colored text for readability, bookmark navigation, perpetual license on up to 3 devices, annotation sharing, audio reader, and viewable through an on-line browser or from a downloaded iOS, PC, or Android app.


Start your Oracle 12c training with the new  Sideris Oracle 12c textbook series.  Textbooks for Oracle 12c database and Enterprise Manager Cloud Control administration as well as SQL and PL/SQL database developers. Click on this graphic for the latest textbook titles that have been released. Or download the full Sideris Courseware Catalog.

 
  .   .    
 
 
     
Training textbooks for Oracle 12c Oracle Certified Associate (OCA), Database, Oracle Enterprise Manager 12c Cloud Control, Oracle WebLogic Server 12c, SQL, PL/SQL, Oracle Cloud DBaaS, PaaS
eTextbook Oracle Database 12c: Install & Upgrade Workshop
 

eTextbook Oracle Database 12c: Install & Upgrade Workshop (2 days)

Description

This eTextbook offers a step-by-step guide for the installation of the optional Oracle 12c grid infrastructure followed by the installation of an Oracle 12c database. The primary focus is the configuration of a Linux host system, with helpful hints for other supported platforms such as Oracle Linux, Unix and MS Windows. This textbook starts with a bare-metal server system and guides one through the process of an operating system installation, operating system configuration and finally the Oracle grid infrastructure and Oracle database installations.

This eTextbook includes practical tips learned from many real-world installations. We include topics about the preparation of disks as Oracle Automatic Storage Management (ASM) candidate devices, troubleshooting installation issues and verifying the validity of an apparently successful installation.

While this eTextbook module applies specifically to the installation of the Enterprise Edition of the Oracle database, it covers basic topics that apply to any Oracle software installation. Therefore, this material is also useful for the installation of other Oracle products such as the Oracle Database Client, specialized options for a database server installation, and so on.

Print Textbook Available

See the list of related textbook items for a print textbook version of this eTextbook.

About This Series

When delivered as an instructor-led training (ILT) or live virtual training session, the suggested length of this eTextbook is 2 days. This eTextbook is most often combined with its companion eTextbook Oracle Database 12c: Architecture & Internals in a single 4 or 5-day presentation.

Audience

The target audience for this eTextbook is all Oracle professionals. Among the specific groups for whom this textbook will be helpful are:

  • Database administrators
  • Application designers and developers
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Chief Information Officers (CIO) and other information technology (IT) management professionals

Prerequisites

These are recommended prerequisites for this eTextbook:

  • Data Modeling: Logical Database Design
  • Oracle Database 12c: SQL Fundamentals (Levels I & II) 

Suggested Next Textbook

Because this is such a fundamental eTextbook to the entirety of the Sideris eTextbook learning series, there are a number of learning paths that one could follow after this textbook and its typical companion eTextbook noted above. You will note liberal references to other textbooks available within the Sideris Oracle database series so that you can choose the next step most suitable for your requirements.

This eTextbook is part of the Sideris Oracle Certified Associate (OCA) Administrator series, which in turn is one of the learning paths from the Sideris Oracle 12c administration curriculum.

Certification

This eTextbook considers subjects helpful for multiple certifications, including such certifications as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".


Download PDF outline


Training textbooks for Oracle 12c Oracle Certified Associate (OCA), Database, Oracle Enterprise Manager 12c Cloud Control, Oracle WebLogic Server 12c, SQL, PL/SQL, Oracle Cloud DBaaS, PaaS
eTextbook Oracle Database 12c: Architecture & Internals
 

eTextbook Oracle Database 12c: Architecture & Internals (2-3 days)

Description

This is a core curriculum eTextbook applicable to most learning paths within the Sideris Oracle textbook series. We begin with a discussion of the broad systems infrastructure where one finds Oracle database installations, and we outline how the database fits with other systems in a multi-tiered architecture, including web servers, application servers and engineered systems such as the Oracle Exadata database computing platform. We then explore the intricacies of a single database installation, including memory, process and storage structures. Periodically we delve into the internals of the database, probing into such areas internal locking mechanisms, kernel module calls and database failures.

This eTextbook initially presents the Oracle database architecture from the perspective of a traditional, single-tenant database configuration as it exists within an on-premise systems infrastructure. We then draw comparisons between such a traditional environment and the new Oracle 12c multi-tenant architecture, used in both traditional and cloud-based computing models.

We present this information in a form that goes beyond a discussion of theoretical concepts. In many cases the Enterprise Manager interface is used to explore the components under consideration. Therefore one of the secondary objectives of this eTextbook is to acquaint you with the built-in Enterprise Manager Database Express interface and sometimes with its EM Cloud Control (CC) companion. In particular our focus is to discover the capabilities of the Enterprise Manager Database Express interface newly introduced with the Oracle 12 database release.

The architecture of different Oracle database installations are not all uniform, as there is considerable flexibility regarding the way a particular installation is configured. Such configuration options exist largely in the form of database parameter settings. So this eTextbook will devote considerable time to identifying these parameters and how these settings can be used to configure a database installation to suit local requirements.

The information contained within this eTextbook is critical to the success of most Oracle technology professionals, whether they are database administrators, security specialists, tuning experts or cloud computing administrators.

Print Textbook Available

See the list of related textbook items for a print textbook version of this eTextbook.

Audience

The target audience for this eTextbook is all Oracle professionals. Among the specific groups for whom this textbook will be helpful are:

  • Database administrators
  • Application designers and developers
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Chief Information Officers (CIO) and other information technology (IT) management professionals

About This Series

This eTextbook is part of the Sideris Oracle Certified Associate (OCA) Administrator series, which in turn is one of the learning paths from the Sideris Oracle 12c administration curriculum.

Prerequisites

These are recommended prerequisites for this eTextbook:

  • Oracle Database 12c: SQL Fundamentals (Levels I & II) 
  • Oracle Database 12c: Install & Upgrade Workshop

The successful completion of this eTextbook requires that one have access to an Oracle Database 12c Enterprise Edition (EE) installation. The textbook entitled ORACLE DATABASE 12C: INSTALL & UPGRADE WORKSHOP will assist you in performing such an installation and it is for this reason that it is listed above as a mandatory prerequisite. The eTextbook that you are now reading is therefore intended to help you to explore the architecture and the internals of the new database installation that you may have just created using that prerequisite as a guide.

Suggested Next eTextbook

Because this is such a fundamental eTextbook to the entirety of the Sideris eTextbook learning series, there are a number of learning paths that one could follow after this eTextbook. You will note liberal references to other eTextbooks available within the Sideris Oracle database series so that you can choose the next step most suitable for your requirements.

Certification

This eTextbook considers subjects helpful for multiple certifications, including such certifications as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration" as well as an Oracle Database 12c Administrator Certified Professional (OCP), Oracle Database 12c Administrator Certified Master (OCM), and an Oracle Database 12c Performance Tuning Certified Expert.


Download PDF outline


Training textbooks for Oracle 12c Oracle Certified Associate (OCA), Database, Oracle Enterprise Manager 12c Cloud Control, Oracle WebLogic Server 12c, SQL, PL/SQL, Oracle Cloud DBaaS, PaaS
eTextbook Oracle Database 12c: Administration Workshop
 

eTextbook Oracle Database 12c: Administration Workshop (5 days)

Description

The overall objective of this eTextbook is threefold. First, this textbook instructs one in many of the day-to-day administration tasks required of an Oracle database administrator. Second, it is one of the eTextbook modules that assist in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces one to many of the administration sub-specialties that one might next pursue. It is increasingly rare for a single database administrator to fulfill all the required responsibilities necessary for management of an enterprise-scale Oracle database installation. Therefore, one may eventually specialize into backup and recovery strategies, database performance tuning, security administration and the like. So this eTextbook introduces the many powerful capabilities of the Oracle database and references the applicable eTextbooks within the Sideris Oracle database administration series that one might next consult.

Whenever appropriate this eTextbook demonstrates how an Oracle database installation integrates with its host environment, most commonly a Linux, Unix or MS Windows operating system platform. Extensive examples, workshop exercises and solutions are provided using the SQL command-line, the Enterprise Manager Database Express and the Enterprise Manager Cloud Control interfaces.

Print Textbook Available

See the list of related textbook items for a print textbook version of this eTextbook.

About This Series

This eTextbook is part of the Sideris Oracle Certified Associate (OCA) Administrator series, which in turn is one of the learning paths from the Sideris Oracle 12c administration curriculum.

Certification

This eTextbook considers subjects helpful for multiple certifications, including such certifications as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".

Audience

The target audience for this eTextbook is all Oracle professionals. Among the specific groups for whom this eTextbook will be helpful are:

  • Database administrators
  • Application designers and developers
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Chief Information Officers (CIO) and other information technology (IT) management professionals

Prerequisites

These are recommended prerequisites for this eTextbook:

  • Oracle Database 12c: SQL Fundamentals (Levels I & II) 
  • Oracle Database 12c: Install & Upgrade Workshop
  • Oracle Database 12c: Architecture & Internals


Download PDF outline


Training textbooks for Oracle 12c Oracle Certified Master (OCM), Database, Oracle Enterprise Manager 12c Cloud Control, Oracle WebLogic Server 12c, SQL, PL/SQL, Oracle Cloud DBaaS, PaaS
eTextbook Oracle Enterprise Manager 12c Cloud Control: Install & Upgrade Workshop
 

eTextbook Oracle Enterprise Manager 12c Cloud Control: Install & Upgrade Workshop (2 days)

Description

This training eTextbook is the first in a series provided by Sideris for the Oracle Enterprise Manager 12c Cloud Control product. This eTextbook is intended to provide one with an in-depth understanding of the architecture of the Oracle Enterprise Manager 12c Cloud Control platform. It guides one through a step-by-step installation and preliminary configuration of a Cloud Control instance. Operating system specific considerations that apply to installing the Cloud Control on a Linux, Unix or MS Windows host are provided, along with numerous examples. Potential problems and pitfalls are discussed and possible troubleshooting remedies are offered.

One will learn how to discover within the systems infrastructure a host system and a software installation running on that host, such as a database or middleware application server instance. Incorporating the host system and the software installation into the Enterprise Manager 12c framework then allows the Cloud Control to be used to manage those targets.

The training material then concludes with Oracle Enterprise Manager 12c Cloud Control upgrade procedures, including actual examples from real-world upgrade scenarios. Throughout the procedures explained in this textbook are recommendations for building a high-availability, high-performance and secure Enterprise Manager installation.

Print Textbook Available

See the list of related textbook items for a print textbook version of this eTextbook.

Audience

The target audience for this eTextbook is all Oracle professionals. Among the specific groups for whom this textbook will be helpful are:
• Database administrators
• Web server administrators
• System administrators
• Implementation specialists
• Data center support engineers

About This Series

This eTextbook is part of the Sideris Oracle Certified Master (OCM) & Enterprise Manager Cloud series, which in turn is one of the learning paths from the Sideris Oracle 12c administration training curriculum.

Training Suggestions

This eTextbook is part of the ORACLE DATABASE 12C: OCM (ORACLE CERTIFIED MASTER) & ENTERPRISE MANAGER CLOUD CONTROL series from the Sideris training textbook library.

Certification

This eTextbook considers subjects helpful for certification as an Oracle Enterprise Manager 12c Certified Implementation Specialist for "Exam: 1Z0-457: Oracle Enterprise Manager 12c Certified Implementation Specialist".

Suggested Next eTextbooks

It is assumed that the eTextbook ORACLE ENTERPRISE MANAGER 12C CLOUD CONTROL: ADMINISTER THE ENTERPRISE is being used along with this one as part of a single training session. If not, then that textbook should be part of the next training session. 

If you have not already completed the Sideris eTextbook ORACLE DATABASE 12C: MANAGE THE MULTITENANT ARCHITECTURE, this is also recommended for a subsequent training session. 

Furthermore, like any other database installation, the Oracle Enterprise Manager 12c Cloud Control repository database must be managed and administered. The eTextbook ORACLE DATABASE 12C: ADMINISTRATION WORKSHOP is another recommendation for managing the repository database required for an Enterprise Manager 12c installation.


Download PDF outline


Training textbooks for Oracle 12c Oracle Certified Associate (OCA), Database, Oracle Enterprise Manager 12c Cloud Control, Oracle WebLogic Server 12c, SQL, PL/SQL, Oracle Cloud DBaaS, PaaS
eTextbook Oracle Database 12c: Resource Manager & Scheduler
 

eTextbook Oracle Database 12c: Resource Manager & Scheduler (3 days)

Description

One of the most important and oftentimes underutilized database features is that of the Oracle Database 12c Resource Manager. This is an essential facility for achieving optimum database performance. While this facility could be considered as highly recommended though optional in a traditional Oracle database configuration, in a multi-tenant configuration of pluggable databases enclosed within a container database, the use of the Oracle Database 12c Resource Manager can really be considered as mandatory. This training eTextbook provides conceptual background information on the advantages of this feature over other resource management systems, offers numerous real-word examples and includes step-by-step workshops and exercise solutions that demonstrate the use of this feature.

Yet another related database feature that is often underutilized is that of the Oracle Database Scheduler. This training eTextbook shows how this scheduler compares with other scheduling systems, including the Oracle Enterprise Manager 12c Cloud Control job system. We briefly cover the basic features of the Scheduler that are largely self-evident, but the remainder of our material explores advanced capabilities including integration with the Oracle Database Resource Manager, building sophisticated scheduling systems using job classes, windows and other object components, and employing a file watcher that is especially useful in a data warehouse environment. Perhaps most importantly, we will discuss how proliferating systems and databases resulting from machine virtualization and pluggable databases can be effectively managed using a centralized database Scheduler.

Audience

The target audience for this eTextbook is all Oracle professionals. Among the specific groups for whom this textbook will be helpful are:
  • Database administrators
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Senior application designers and developers

Certification

This eTextbook considers subjects applicable to certification training as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".


Prerequisites

This eTextbook is the final module in the Sideris training series entitled ORACLE DATABASE 12C ADMINISTRATOR CERTIFIED ASSOCIATE (OCA), which in turn is one of the learning paths from the Sideris Oracle 12c administration curriculum. The prerequisites for this textbook are:
  • ORACLE DATABASE 12C: SQL FUNDAMENTALS (LEVELS I & II)
  • ORACLE DATABASE 12C: INSTALL & UPGRADE WORKSHOP
  • ORACLE DATABASE 12C: ARCHITECTURE & INTERNALS
  • ORACLE DATABASE 12C: ADMINISTRATION WORKSHOP
An additional optional but recommended prerequisite is ORACLE ENTERPRISE MANAGER 12C CLOUD CONTROL: INSTALL & UPGRADE WORKSHOP.

Suggested Next eTextbook

The next certification training series that follows this one is for an Oracle Database 12c Administrator Certified Professional (OCP). These training modules are included in that certification series:

  • ORACLE DATABASE 12C: MANAGE THE MULTITENANT ARCHITECTURE
  • ORACLE DATABASE 12C: ADVANCED ADMINISTRATION & ASM
  • ORACLE DATABASE 12C: BACKUP & RECOVERY WORKSHOP

Download PDF outline