Contact Us

Architecting with Google Cloud Platform: Infrastructure

Class Information

Course Date(s):     June 27, 2018 - August 6, 2018 -
Course Code: GAD105 Duration (Days): 3 Days Format: Classroom or ILO

Course Overview

This three-day instructor-led class introduces participants to the comprehensive and flexible infrastructure and platform services provided by Google Cloud Platform. Through a combination of presentations, demos, and hands-on labs, participants explore and deploy solution elements, including infrastructure components such as networks, systems and applications services. This course also covers deploying practical solutions including securely interconnecting networks, customer-supplied encryption keys, security and access management, quotas and billing, and resource monitoring.

Audience

This class is intended for the following participants:

  • Cloud Solutions Architects, DevOps Engineers.
  • Individuals using Google Cloud Platform to create new solutions or to integrate existing systems, application environments, and infrastructure with the Google Cloud Platform.

Prerequisites

To get the most out of this course, participants should have:

  • Completed Google Cloud Platform Fundamentals or have equivalent experience
  • Basic proficiency with command-line tools and Linux operating system environments
  • Systems Operations experience including deploying and managing applications, either on-premises or in a public cloud environment

Key Topics

Module 1: Introduction to Google Cloud Platform

  • Role of the Cloud Architect.
    Learn about Solution Domains as an approach to design.
  • Lab: Console and Cloud Shell.
  • Module 2: Virtual Networks
  • Cloud Virtual Networks (CVN), Projects, Networks, Subnetworks, IP addresses, Routes, Firewall rules.
  • Subnetworks for resource management instead of physical network topology.
  • Lab: Virtual Networking.
  • Module 3: Virtual Machines
  • GCE, tags, VM options, vCPUs, disk options, images, and special features of persistent disks for VMs.
  • Module 4: Cloud IAM
  • Members, roles, organizations, account administration, service accounts.
  • Lab: Cloud IAM.
  • Module 5: Resource Management
  • Billing, Quotas, Labels, Names, Cloud Resource Manager.
  • Lab: Lab Billing.
  • Module 6: Data Services
  • Cloud Storage, Datastore, Bigtable, Cloud SQL.
  • Lab: Cloud Storage.
  • Lab: Cloud SQL.
  • Module 7: Interconnecting Networks
  • VPNs, Cloud Router, Cloud Interconnect, Direct Peering, Cloud DNS.
  • Lab: VPN and Cloud Router.
  • Module 8: Infrastructure Automation
  • Infrastructure automation, custom images, startup and shutdown scripts and metadata,
  • Deployment Manager, Cloud Launcher.
  • Lab: Hadoop Cluster Maker.
  • Lab: Virtual Machine.
  • Module 9: Autoscaling
  • Load Balancing, Instance Groups, Autoscaler.
  • Lab: Autoscaling.
  • Module 10: Resource Monitoring
  • Stackdriver, Monitoring, Logging, Error Reporting, Tracing, Debugging.
  • Lab: Resource Monitoring (Stackdriver).
  • Module 11: Containers
  • Containers, Google Container Engine (GKE), and Container Registry.
  • Module 12: Platform Security
  • Learn about Google’s layered security strategy that uses a multi-faceted approach to provide platform security services and benefits.
  • Module 13: Managed Services
  • Dataproc, Dataflow, BigQuery, Datalab.
  • Lab: BigQuery and Datalab.
  • Module 14: Application Development Infrastructure
  • App Engine, Cloud SDK, Dev Tools, Cloud Source Repos, Cloud Pub/Sub, Cloud Endpoints and Apigee, Cloud Functions.

Objectives

This course teaches participants the following skills:

  • Consider the entire range of Google Cloud Platform technologies in their plans.
  • Learn methods to develop, implement, and deploy solutions.
  • Distinguish between features of similar or related products and technologies.
  • Recognize a wide variety of solution domains, use cases, and applications.
  • Develop essential skills for managing and administering solutions.
  • Develop knowledge of solution patterns — methods, technologies, and designs that are used to implement security, scalability, high availability, and other desired qualities.

Developing Business Applications with Google App Engine

Class Information

Course Date(s):     June 21, 2018 - August 9, 2018 -
Course Code: GAD104 Duration (Days): 2 Days Format: Classroom or ILO

Developing Applications with Google Apps Script

Class Information

Course Date(s):     June 19, 2018 - July 26, 2018 -
Course Code: GAD103 Duration (Days): 2 Days Format: Classroom or ILO

Fundamentals of Google Docs and Drive

Class Information

Course Date(s):     July 18, 2018 - August 29, 2018 -
Course Code: GEC102 Duration (Days): 1 Day Format: Classroom or ILO

Fundamentals of Google Apps Mail and Calendar

Class Information

Course Date(s):     July 12, 2018 - August 28, 2018 -
Course Code: GEC101 Duration (Days): 1 Day Format: Classroom or ILO

Developing Solutions with Google Cloud Platform

Class Information

Course Date(s):     July 16, 2018 - August 27, 2018 -
Course Code: GAD102 Duration (Days): 3 Days Format: Classroom or ILO

Course Overview

This three-day instructor-led course introduces you to concepts and best practices for developing applications with Google Cloud Platform. Through a combination of presentations, demos and hands-on labs, participants learn how to develop cloud-based applications using Google App Engine Standard Environment, Google Cloud Datastore, Google Cloud Endpoints, and Google Cloud Repositories

Audience

This class is intended for experienced application developers who want to learn how to migrate applications to the cloud or create native, cloud-based applications on Google Cloud App Engine.

Prerequisites

To get the most of out of this course, participants should have:

  • Completed Google Cloud Platform Fundamentals or have equivalent experience.
  • Basic proficiency with command-line tools and Linux operating system environments.
  • Experience developing applications and APIs using a common programming language such as Java or Python
  • Experience deploying and managing applications, either on- premises or in a public cloud environment

Key Topics

Module 1: Developing Solutions with Google Cloud Platform
  • Benefits of Google Cloud Platform.
  • Development tools and services for Google Cloud Platform.
  • Google Cloud Platform solution architectures.
  • Lab: Google Cloud Source Repositories.
Module 2: Google Cloud Endpoints
  • Cloud Endpoints features.
  • Developing APIs using Cloud Endpoints.
  • Accessing Cloud Endpoints APIs using JavaScript clients.
  • Lab: Google Cloud Endpoints.
Module 3: App Engine Services
  • Modular application design and App Engine services.
  • Deploying services.
  • Accessing App Engine services.
  • Lab: Google App Engine Services.
Module 4: User Authentication and Credentials
  • Authentication and authorization concepts.
  • Securing access through application configuration.
  • Authentication with the Users service.
  • Authorization with API keys, OAuth, and application default credentials.
  • Lab: User Authentication.
Module 5: Managing App Engine Applications
  • Deploying and managing multiple application versions.
  • Traffic splitting, incremental rollouts, and canary releases.
  • Budgets and quotas.
  • Stackdriver logging and application tracing.
  • Lab: Managing Google App Engine Applications.
Module 6: Storage for Solution Developers
  • Functionality and benefits of Cloud Platform storage options.
  • Using Google Cloud Storage for immutable BLOB storage.
  • Integrating Google Cloud SQL into App Engine Apps.
  • Cloud Datastore fundamentals.
  • Lab: Google Cloud Datastore.
Module 7: Queries and Indexes
  • Implementing query filters with Cloud Datastore.
  • Single-property and composite indexes.
  • Configuring and optimizing indexes.
  • Lab: Google Cloud Datastore Queries and Indexes.
Module 8: Entity Groups, Consistency, and Transactions
  • Strong and eventual consistency in Cloud Datastore.
  • Ensuring strongly consistent queries.
  • Best practices for Cloud Datastore transactions.
  • Lab: Google Cloud Datastore Transactions.
Module 9: App Engine Performance and Optimization
  • Memcache use cases and implementation patterns.
  • Manual, basic, and automatic scaling behavior.
  • Configuring application scaling.
  • Lab: Google App Engine Performance and Optimization.
Module 10: Task Queues
  • Push and pull queue capabilities and configuration.
  • Adding and consuming tasks with push and pull queues.
  • Scheduling tasks with the Cron Service.
  • Lab: Task Queue API.
  • Lab: Deleting Google Cloud Platform Projects and Resources.

Objectives

This course teaches participants the following skills:

  • Build scalable and reliable applications using Google App Engine Standard Environment.
  • Leverage Google Cloud Endpoints to implement, deploy, and manage API backends.
  • Create microservice-based applications using App Engine services.
  • Manage application security, versioning, deployment, and monitoring.
  • Store application data, optimize query performance, and use transactions in Google Cloud Datastore.
  • Provide improved performance and capacity with Memcache and instance scaling.

Google Cloud Platform Fundamentals: Core Infrastructure

Class Information

Course Date(s):     July 11, 2018 - August 2, 2018 -
Course Code: GAD101 Duration (Days): 1 day Format: Classroom or ILO

Course Overview

This one-day instructor-led class provides an overview of Google Cloud Platform products and services. Through a combination of presentations, demos, and hands-on labs, participants learn the value of Google Cloud Platform and how to incorporate cloud-based solutions into business strategies.

Audience

This class is intended for the following participants:

  • Individuals planning to deploy applications and create application environments on Google Cloud Platform.
  • Developers, systems operations professionals, and solution architects getting started with Google Cloud Platform.
  • Executives and business decision makers evaluating the potential of Google Cloud Platform to address their business needs.

Prerequisites

Familiarity with application development, systems operations, Linux operating systems, and data analytics/machine learning is helpful in understanding the technologies covered.

Key Topics

Module 1: Introducing Google Cloud Platform
  • Explain the advantages of Google Cloud Platform
  • Define the components of Google’s network infrastructure, including: Points of presence, data centers, regions, and zones.
  • Understand the difference between Infrastructure-as-a- Service (IaaS) and Platform-as-a-Service (PaaS).
  • Lab: Sign Up for the Free Trial and Create a Project.
Module 2: Getting Started with Google Cloud Platform
  • Identify the purpose of projects on Google Cloud Platform.
  • Understand the purpose of and use cases for Identity and Access Management.
  • List the methods of interacting with Google Cloud Platform.
  • Lab: Getting Started with Google Cloud Platform.
Module 3: Google App Engine and Google Cloud Datastore
  • Understand the purpose of and use cases for Google App Engine and Google Cloud Datastore.
  • Contrast the App Engine Standard environment with the App Engine Flexible environment.
  • Understand the purpose of and use cases for Google Cloud Endpoints.
  • Lab: Deploying Applications Using App Engine and Cloud Datastore.
Module 4: Google Cloud Platform Storage Options
  • Understand the purpose of and use cases for: Google Cloud Storage, Google Cloud SQL, and Google Cloud Bigtable.
  • Learn how to choose between the various storage options on Google Cloud Platform.
  • Lab: Integrating Applications with Google Cloud Storage.
Module 5: Google Container Engine
  • Define the concept of a container and identify uses for containers.
  • Identify the purpose of and use cases for Google Container Engine and Kubernetes.
  • Deploying Applications Using Google Container Engine.
Module 6: Google Compute Engine and Networking
  • Identify the purpose of and use cases for Google Compute Engine.
  • Understand the various Google Cloud Platform networking and operational tools and services.
  • Lab: Deploying Applications Using Google Compute Engine.
Module 7: Big Data and Machine Learning
  • Understand the purpose of and use cases for the products and services in the Google Cloud big data and machine learning platforms.
  • Lab: Getting Started with BigQuery.

Objectives

This course teaches participants the following skills:

  • Identify the purpose and value of Google Cloud Platform products and services
  • Interact with Google Cloud Platform services
  • Describe ways in which customers have used Google Cloud Platform
  • Choose among and use application deployment environments on Google Cloud Platform: Google App Engine, Google Container Engine, and Google Compute Engine
  • Choose among and use Google Cloud Platform storage options: Google Cloud Storage, Google Cloud SQL, Google Cloud Bigtable, and Google Cloud Datastore
  • Make basic use of BigQuery, Google’s managed data warehouse for analytics

Oracle Database 11g R2 Administration

Class Information

No Dates available
Course Code: 035249S Duration (Days): 5 Days Format: Classroom or ILO

Course Overview

Administration of the Oracle database management system (DBMS) software environment and of the server systems on which the DBMS runs is one of the primary tasks required of database administrators. While it is true that the hardware and software platforms on which the DBMS runs have become increasingly complex, as has the database software itself, the capabilities provided by the Oracle database have correspondingly become more sophisticated.

Audience

The primary audiences for this course are:
• Database administrators
• Web server administrators
• System administrators
• Implementation specialists
• Data center support engineers
• Senior application designers and developers

Prerequisites

Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are:
• ORACLE DATABASE 11G R2: SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11G R2: PROGRAM WITH PL/SQL – COMPLETE LIBRARY

Key Topics

INSTALLATION & UPGRADE VOLUME

CONFIGURING THE SERVER FOR INSTALLATION
• IDENTIFY SYSTEM REQUIREMENTS
• OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
• ORACLE_BASE
• ORACLE_HOME
• CONFIGURE LINUX INSTALLATION
• CONFIGURE MS WINDOWS INSTALLATION
• PREREQUISITE CHECKS & FIXUP UTILITY

ENTERPRISE EDITION INSTALLATION
• MORE ABOUT THE INSTALLATION
• START THE INSTALLATION
• DESKTOP CLASS INSTALLATION 11G R2
• SERVER CLASS INSTALLATION 11G R2
• POST-INSTALLATION CONFIGURATION

VERIFY THE INSTALLATION
• ACCESSING THE EM DATABASE CONTROL
• USING THE EM INTERFACE
• USING SQL*PLUS
• USING EM SQL WORKSHEET
• USING SSH

UPGRADE, DEINSTALLATION & PATCHING
• DATABASE UPGRADE
• NETCA
• DBUA
• ONLINE PATCHING
• ORACLE DEINSTALLER

VOLUME A:

MANUALLY STARTING & STOPPING DATABASE SERVICES
• STARTING & STOPPING DATABASE CONTROL
• STARTING & STOPPING THE LISTENER
• STARTING & STOPPING THE DATABASE
• SYSDBA

EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL
• THE ORACLE ENTERPRISE ARCHITECTURE
• GENERAL DATABASE ARCHITECTURE
• V$VERSION

EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY
• MORE ABOUT DATABASE INSTANCES
• USING V$SGA_DYNAMIC_COMPONENTS
• ABOUT THE PGA
• MANAGING MEMORY

EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES
• INSTANCE BACKGROUND PROCESSES
• SQL EXECUTION PROCESSES
• USING V$SESSION CREATING AN ORACLE DATABASE
• CREATE A NEW DATABASE
• CONFIGURE AN EXISTING DATABASE
• DROP A DATABASE
• MANAGE DBCA TEMPLATES
• MANUALLY CREATE A DATABASE
• MORE ABOUT THE DATABASE FILES

ENABLING TRANSPARENT DATA ENCRYPTION
• TRANSPARENT DATA ENCRYPTION
• MANAGING TDE
• IMPLEMENTING COLUMN ENCRYPTION

MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES
• ABOUT TABLESPACES
• TABLESPACE MANAGEMENT
• AUTOEXTEND OPTIONS
• DROP TABLESPACE
• ALTER TABLESPACE

MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES
• MORE ABOUT TEMPORARY TABLESPACES
• USING V$SORT_SEGMENT
• ABOUT TEMPORARY TABLESPACE GROUPS
• MORE ABOUT PERMANENT TABLESPACES
• ABOUT DATABASE_PROPERTIES
• MORE ABOUT BIGFILE TABLESPACES
• MORE ABOUT THE SYSAUX TABLESPACE

MANAGE DATABASE STORAGE STRUCTURES: DATA FILES & TEMP FILES
• MANAGING DATA FILES
• MANAGING TEMP FILES
• ENABLE ORACLE-MANAGED FILES (OMF)

MANAGING UNDO DATA
• ABOUT UNDO SPACE MANAGEMENT
• CONFIGURE UNDO MANAGEMENT
• UNDO_MANAGEMENT
• UNDO_TABLESPACE
• UNDO_RETENTION
• GUARANTEE UNDO RETENTION
• MONITOR UNDO SPACE
• USE THE UNDO ADVISOR

VOLUME B:

NETWORK ENVIRONMENT: ORACLE NET SERVICES
• ORACLE NET SERVICES ARCHITECTURE
• ORACLE NET CONFIGURATION ASSISTANT
• ORACLE NET MANAGER
• CONFIGURATION USING EM
• TROUBLESHOOTING NETWORK PROBLEMS
• COUNTERING DATABASE ATTACKS

NETWORK ENVIRONMENT: ORACLE SHARED SERVERS
• SHARED SERVERS ARCHITECTURE
• CONFIGURE SHARED SERVERS
• MONITOR SHARED SERVERS
• V$SHARED_SERVER
• V$SHARED_SERVER_MONITOR
• V$SESSION • V$CIRCUIT
• V$DISPATCHER & V$DISPATCHER_CONFIG
• V$QUEUE

SECURITY: IMPLEMENTING DATABASE SECURITY
• DATABASE SYSTEM PRIVILEGES
• DATABASE OBJECT PRIVILEGES
• AUDITING OF DATABASE ACTIVITY
• AUDIT_TRAIL PARAMETER
• ENHANCED DEFAULT SECURITY SETTINGS

SECURITY: ADMINISTERING USER SECURITY
• CREATE & MANAGE DATABASE ACCOUNTS
• GRANT & REVOKE DATABASE PRIVILEGES
• RESOURCE LIMITS VIA PROFILES
• ALTER PROFILE
• DROP PROFILE
• PASSWORD MANAGEMENT VIA PROFILES
• ABOUT ROLE-BASED SECURITY
• WITH ADMIN OPTION
• WITH ADMIN OPTION & SYSTEM PRIVILEGES
• WITH GRANT OPTION & OBJECT PRIVILEGES
• ALTER USER…DEFAULT ROLE
• SET ROLE
• ENHANCED DEFAULT SECURITY SETTINGS
• SEC_CASE_SENSITIVE_LOGON SETTING

MOVING DATA: SQL LOADER
• LOADER CONCEPTS
• CONTROL FILE OPTIONS
• LOAD METHODS
• USING THE EM INTERFACE

MOVING DATA: EXPORT & IMPORT
• MANAGE DIRECTORY OBJECTS
• ABOUT THE DATA PUMP ARCHITECTURE
• DATA PUMP IMPORT
• DATA PUMP DATA DICTIONARY VIEWS
• USING THE EM INTERFACE

DATABASE MAINTENANCE & PERFORMANCE MONITORING
• MANAGEMENT & ADVISORY FRAMEWORK
• MANAGE AWR
• ADDM
• USE METRICS & ALERT THRESHOLDS
• AUTOMATIC MAINTENANCE TASKS

MANAGING CONCURRENCY & LOCKS
• ABOUT LATCHES & LOCKS
• MANAGE & MONITOR LATCHES
• V$LOCK
• V$LOCKED_OBJECT
• V$SESSION
• V$SESSION_WAIT
• DBA_BLOCKERS & DBA_WAITERS
• DBA_DML_LOCKS & DBA_DDL_LOCKS
• DML_LOCKS

BACKUP & RECOVERY CONCEPTS & CONFIGURATION
• ABOUT BACKUP & RECOVERY STRUCTURES
• MANAGING REDO DATA
• MANAGING ARCHIVAL DATA
• AUTOMATIC CRASH RECOVERY
• CREATING A BASIC BACKUP STRATEGY

Objectives

The overall objective of this training course is to allow the student to gain the skills necessary for day-to-day administration of an Oracle database. These training materials are the starting point for Oracle database administrators and sets the foundation for advanced administrator training and certification. Major tasks to be considered within this course are:
• Configuration of the Linux and MS Windows operating systems in anticipation of a database installation
• Server Class installation of the Oracle 11g R2 Enterprise Edition database
• Verification of a valid database installation
• Database administrator interface options, including the use of Enterprise Manager, command-line SQL*Plus, and terminal console SSH
• Database deinstallation
• Online software patching
• Startup and shutdown of database services and related software components
• Super administrator authentication options
• An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
• Management of database files.
• Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the Result Cache, the database buffer cache, and other similar components.
• Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
• Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
• Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
• Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
• Control over database support services, including the Database Control, Oracle Net and others.
• A primer on backup and recovery structures and strategies.
• Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.

Oracle Database 12c: Administration

Class Information

No Dates available
Course Code: 035208S Duration (Days): 5 Days Format: Classroom or ILO

Course Overview

The overall objective of this course is threefold. First, this course teaches you many of the day-to-day administration tasks required of an Oracle database administrator. Second, it is one of the course modules that assist in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces you to many of the administration sub-specialties that you 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, you may eventually specialize into backup and recovery strategies, database performance tuning, security administration and the like. So this course 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 course 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.

Audience

The target audience for this course is all Oracle professionals.
Course will be helpful to:

  • 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 course:

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

Key Topics

Introduction: Managing The Database Instance
• The Database Management Tools
• EM Database Express
• EM Cloud Control
• SQL Developer
• Database Administration Duties

Introduction: Database Architecture Review
• Database Instance Configurations
• Memory Structures
• Process Structures
• Storage Architecture

Introduction: Starting & Stopping Database Services
• Start & Stop The Database Listener
• About Database Startup/Shutdown
• SYSOPER
• SYSDBA
• Database State & Stages
• Startup With EM Cloud Control
• Startup With SQL*PLUS
• Shutdown With EM Cloud Control
• Shutdown With SQL*PLUS
• Using MS Windows Services

Introduction: Oracle Network Environment
• Oracle NET Services Architecture
• Oracle NET Configuration Assistant
• Oracle NET Manager
• Using EM Cloud Control
• Advanced Network Compression
• Troubleshooting Network Problems

Introduction: Diagnostics & Oracle Support
• About Database Diagnostics
• Fault Diagnosability Infrastructure
• Database Instance Health Snapshot
• The Support Workbench
• Proactive Database Health Checks
• Package Diagnostic Data
• Working With The Knowledge Base

Storage: Tablespace Management
• Starter Tablespaces
• Create Tablespace With EM CC
• Create Tablespace With SQL
• Manage Tablespaces With EM CC
• Manage Tablespaces With EM DE
• Manage Tablespaces With SQL
• DROP Tablespace
• ALTER Tablespace

Storage: Advanced Tablespace Management
• Managing Temporary Tablespaces
• Temp Tablespace Groups With EM
• Temp Tablespace Groups With SQL
• Default Permanent Tablespaces
• Bigfile Tablespaces
• Managing The SYSAUX Tablespace

Storage: Data Files & Temp Files Management
• Manage Data Files With EM
• Access Metadata With SQL
• Manage Data Files With SQL
• Manage Temp Files
• Oracle-Managed Files (OMF)

Storage: Undo Data & Undo Tablespaces
• About Undo Space Management
• Configure Undo Management
• Guarantee Undo Retention
• Monitor Undo Space With SQL
• Use The EM Undo Advisor

Security & Schemas: Security Overview & Database Privileges
• Database Security Principles
• Database System Privileges
• Database Object Privileges
• Super Administrator Roles
• Privilege Analysis

Security & Schemas: User Security
• Create & Manage User Accounts
• Manage Users With EM
• Manage Users With SQL
• CREATE User
• ALTER User
• DROP User
• Grant & Revoke Privileges
• Resource Limits Via Profiles
• ALTER Profile
• DROP Profile
• Password Management Via Profiles
• Role-Based Security Management
• Alter User…Default Role
• Set Role
• Delegating Privilege Authorization
• With Admin Option & System Privileges
• With Grant Option & Object Privileges
• Principle Of Least Privilege Checklist

Security & Schemas: Database Auditing
• Auditing Database Activity
• Traditional Auditing
• Unified Auditing
• Create Audit Policy

Security & Schemas: SQL Loader
• Loader Concepts
• Loader From The Command Line
• Control File Options
• Load Methods
• Loader Express Mode
• Loader From EM

Security & Schemas: Export & Import
• Manage Directory Objects
• The Data Pump Architecture
• Data Pump Export
• Data Pump Import
• Data Pump Dictionary Views
• Using The EM Cc Interface

Performance & Availability: Managing Performance & SQL Tuning
• Management Advisory Framework
• Performance Monitoring & AWR
• The SQL Tuning Advisor
• Monitoring Exceptions With Metrics

Performance & Availability: Data Concurrency
• About System & User Locks
• Monitor & Manage User Locks
• Monitor Locks With Data Dictionary
• Manage Locks With EM

Performance & Availability: Backup & Recovery Concepts
• Backup & Recovery Structures
• Managing Redo Data
• Configuring For Recoverability
• Instance Recovery
• Recoverability Checklist

Oracle Database 12c – PL/SQL Fundamentals I & II

Class Information

No Dates available
Course Code: 035203S Duration (Days): 5 Days Format: Classroom or ILO

Course Overview

This class introduces you to Oracle database programming using the PL/SQL programming language. You will learn the syntax, structure and features of the language. This class will also lay the foundation for the entire Sideris Oracle PL/SQL programming series, allowing you to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.
PL/SQL may be considered as one of the basic skill sets required for any Oracle professional, nearly as important as the SQL language itself.

Audience

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

  • Application designers and database developers
  • Database administrators
  • Web server administrators

Prerequisites

Either of the Sideris textbooks Oracle Database 12c: SQL – Fundamentals (Levels I & II) or Oracle Database 12c: SQL Complete Library (Levels I, II & III) are recommended prerequisites for this textbook.

Key Topics

Selection & Setup Of The Database Interface
• Considering Available Tools
• Selecting The Appropriate Tool
• Oracle NET Database Connections
• Oracle PAAS Database Connections
• Setup SQL Developer
• Setup SQL*PLUS
• Setup JDeveloper

About BIND & SUBSTITUTION Variables
• Using SQL Developer
• Using SQL*PLUS

Choosing A Database Programming Language
• What Is Database Programming?
• PL/SQL Performance Advantages
• Integration With Other Languages

PL/SQL Language Fundamentals
• PL/SQL Program Structure
• Language Syntax Rules
• Embedding SQL
• Writing Readable Code
• Generating Database Output
• SQL*PLUS Input Of A Program Block

DECLARE Section
• About The DECLARE Section
• DECLARE Primitive Types
• Declaration Options
• NOT NULL
• CONSTANT
• Data Dictionary Integration
• %TYPE
• Declare Simple User-Defined Types
• TYPE … TABLE
• TYPE … RECORD
• Extended User-Defined Types

BEGIN Section
• About The BEGIN Section
• Manipulating Program Data
• Logic Control & Branching
• GOTO
• LOOP
• IF-THEN-ELSE
• CASE

Exception Section
• About The EXCEPTION Section
• Isolating The Specific EXCEPTION
• PRAGMA EXCEPTION_INIT
• SQLCODE & SQLERRM Example
• SQL%ROWCOUNT & SELECT…INTO

Beyond The Basics: Explicit Cursors
• About Explicit Cursors
• Extended Cursor Techniques
• FOR UPDATE OF Clause
• WHERE CURRENT OF Clause
• Using FOR…LOOP Cursors

Beyond The Basics: Nested Blocks

Beyond The Basics: DECLARED Subprograms
• Using DECLARED Subprograms
• DECLARED Procedure
• DECLARED Function

Objectives

This class begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language. The final section goes beyond the basics and begins to explore advanced topics that will be useful later in the Sideris Oracle PL/SQL developer textbook series. One learns techniques and features that allow modular and reusable programs to be developed, increasing productivity and maintainability of database applications.

$$2,950 Registeration till

Interested? Register Now

Copyrights 2017. Citent Inc. All rights reserved