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

 
 
 
 
 

 

 
 

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.

 

Enhanced   Instructor delivery. There is no substitute for  a  subject matter expert in Oracle, Adobe,  or Microsoft. Sideris custom print textbooks combined with our online resources make distance-learning and virtual training more effective than ever. Watch and see how to enhance your instructor presentations.


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 Master (OCM), Database, Oracle Enterprise Manager 12c Cloud Control, Oracle WebLogic Server 12c, SQL, PL/SQL, Oracle Cloud DBaaS, PaaS
Oracle Enterprise Manager 12c Cloud Control: Install & Upgrade Workshop
 

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

Description

This training textbook is the first in a series provided by Sideris for the Oracle Enterprise Manager 12c Cloud Control product. This textbook 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.

Audience

The target audience for this textbook 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 textbook 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 textbook is part of the ORACLE DATABASE 12C: OCM (ORACLE CERTIFIED MASTER) & ENTERPRISE MANAGER CLOUD CONTROL series from the Sideris training textbook library.

Certification

This textbook 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 Textbooks

It is assumed that the textbook 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 textbook 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 textbook 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
Oracle Database 12c: Architecture & Internals
 

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

Description

This is a core curriculum textbook 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 textbook 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 textbook 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 textbook 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 textbook is critical to the success of most Oracle technology professionals, whether they are database administrators, security specialists, tuning experts or cloud computing administrators.

Audience

The target audience for this textbook 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 textbook 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 textbook:

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

The successful completion of this textbook 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 textbook 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 Textbook

Because this is such a fundamental textbook to the entirety of the Sideris textbook learning series, there are a number of learning paths that one could follow after this textbook. 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.

Certification

This textbook 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
Oracle Database 12c: Install & Upgrade Workshop
 

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

Description

This textbook 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 textbook 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 course 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.

About This Series

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

Audience

The target audience for this textbook 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 textbook:

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

Suggested Next Textbook

Because this is such a fundamental textbook to the entirety of the Sideris textbook learning series, there are a number of learning paths that one could follow after this textbook and its typical companion textbook 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 textbook 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 textbook 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
Oracle Database 12c: Administration Workshop
 

Oracle Database 12c: Administration Workshop (5 days)

Description

The overall objective of this textbook 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 textbook 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 textbook introduces the many powerful capabilities of the Oracle database and references the applicable textbooks within the Sideris Oracle database administration series that one might next consult.

Whenever appropriate this textbook 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.

About This Series

This textbook 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 textbook 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 textbook 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 textbook:

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


Download PDF outline