Ogłoszenie wyodrębnione, bo często do mnie z tym przychodzicie.

- Podstawy języka SQL (Oracle, i inne)
- Pisanie zapytań sql, procedury, joby, triggery, wyzwalacze, funkcje sql.
- pomoc w rozwiązywaniu zadań z pisania zapytań sql

Dodatkowo oferuję profesjonalne szkolenie z administracji baz danych Oracle , począwszy od wersji 11g.
Całe szkolenie trwa minimum 40 godzin, ale jeśli masz problem z konkretnym tematem, to możemy skupić się wyłącznie na tym.

Tagi:
select, insert, update, delete, create, alter, drop, itp.

TRAINING CONTENT - COVERED POINTS
Prerequisites for the training:

• Operating system basics for Windows and Linux (basic commands,etc). Materials included.
• Networking basics
• OS prerequisites for Oracle DB installation and their purpose (eg. consequences if not taken care of)

Exploring the Oracle Database Architecture
-Oracle Database Architecture Overview
-Process Architecture
-Memory structures
-Logical and physical storage structuresInstalling your Oracle Software
-Tasks of an Oracle Database Administrator
-Tools Used to Administer an Oracle Database
-Oracle Universal Installer (OUI)
-Installing Oracle Database Software Optimal Flexible Architecture
Each OUI screen and option described.
What will happen if prereqs are not met, and how to resolve these problems.

Problem examples:
- insufficient fs space
- add space to lv from vg, and resize fs
- missing rpm’s - yum installation
- missing shm fs - memory_target error during installation, etc.
-Silent Install

Creating an Oracle Database
-Planning the Database
-Using the DBCA to Create a Database
-RL and CF mirroring setup
-Password Management
-Creating a Database Design Template
-Using the DBCA to Delete a Database

Managing the Oracle Database Instance
-Start and stop the Oracle database and components
Explain oradim for Windows.
Explain the purpose of oratab in Linux

Use Oracle Enterprise Manager
-Access a database with SQLPlus
-Modify database installation parameters
-Describe the stages of database startup
-Describe database shutdown options
-View the alert log
-Access dynamic performance views Configuring the Oracle Network Environment
-Use NetCA, NetMgr and OEM to create and configure the Listener
-Enable Oracle Restart to monitor the listener
-Use tnsping to test Oracle Net connectivity
-Identify when to use shared servers and when to use dedicated servers

Managing Database Storage Structures
-Storage Structures
-How Table Data Is Stored
-Anatomy of a Database Block
-Space Management in Tablespaces
Hands on keyboard:
Create, extend tablespaces, make them autoextensible, add datafiles.

-Tablespaces in the Preconfigured Database
-Actions with Tablespaces
-Oracle Managed Files (OMF)
-Oracle ASM overview - basics

Administering User Security
-Database User Accounts
-Predefined Administrative Accounts
-Benefits of Roles
-Predefined Roles
-Implementing Profiles

Managing Data Concurrency
-Data Concurrency
-Enqueue Mechanism
-Resolving Lock Conflicts
Hands on keyboard:
Simulate a lock conflict with 2 db users, and resolve it.
-Deadlocks

Managing Undo Data
-Data Manipulation
-Transactions and Undo Data
-Undo Data Versus Redo Data
-Configuring Undo Retention
-Flashback technology and recyclebin overview
Hands on keyboard:
Simulate drop query and restore the data from undo/recyclebin.

Database Maintenance
-Manage optimizer statistics
-Manage the Automatic Workload Repository (AWR)
Describe which parameters are mandatory to use AWR in 11g.
Hands on keyboard: generate AWR reports.

-Statspack overview.
-Use the Automatic Database Diagnostic Monitor (ADDM)
-Describe and use the advisory framework
-Set alert thresholds
-Use server-generated alerts
-Use automated tasks
-ADRCI usage and policy configuration

Performance Management
-Performance Monitoring
-Managing Memory Components
-Enabling Automatic Memory Management (AMM)
-Automatic Shared Memory Advisor
-Using Memory Advisors
-Dynamic Performance Statistics
-Troubleshooting and Tuning Views
-Invalid and Unusable Objects Backup and Recovery Concepts
-Statement Failure-User Error
-Understanding Instance Recovery
-Phases of Instance Recovery
-Using the MTTR Advisor
-Media Failure
-Archive Log Files Performing Database Backups

Backup Solutions: Overview
-Oracle Secure Backup
-User-Managed Backup
-Terminology
-Recovery Manager (RMAN)
-Configuring Backup Settings
-Backing Up the Control File to a Trace File
-Monitoring the Flash Recovery Area

Performing Database Recovery
-Opening a Database
-Data Recovery Advisor
-Loss of a Control File
-Loss of a Redo Log File
-Data Recovery Advisor
-Data Failures
-Listing Data Failures
-Data Recovery Advisor Views
Hands on keyboard:
Create full and archivelog backups with RMAN.
Create some dummy tables.
Restore and recover databases to the state before table creation. Corrupt the database by removing users dbf.
Use DRA to fix the database.

Moving Data
-Describe ways to move data
-Create and use directory objects
-Use SQL*Loader to move data
-Use external tables to move data
-RMAN database duplication overview
Explain: types of duplication
Hands on keyboard:
Create new instance on the same host using created backup.

General architecture of Oracle Data Pump
-Use Data Pump export and import to move data
Explain: Flashback_time - data consistency
Exclude/include options and commonly excluded schemas Table_exists_action options
Impdp post tasks.
Hands on keyboard:
Create schema based export.
Drop user.
Import that schema back.

Oracle Patching:
OPatch overview
- OPatch lsinvetory and its prerequisites
Hands on keyboard:
- Applying patch #1 on top of 11.2.0.1 OH.
- Trying to apply patch #2 and identifying a patch conflict
- Rolling back previous patch.
- Applying later patch

Oracle Upgrade:
- DBUA overview
- Supported ways of Oracle upgrade.
Hands on keyboard:
- installing new 11.2.0.4 OH
- creating sample db
- dropping sample db
- running pre-upgrade information tool
- upgrading 11.2.0.1 database using DBUA to 11.2.0.4

Szkoła średnia

Studia

U ucznia

Online