summer training oracle
DESCRIPTION
CETPA INFOTECH PVT LTD is one of the IT education and training service provider brands of India that is preferably working in 3 most important domains. It includes IT Training services, software and embedded product development and consulting services. http://www.cetpainfotech.comTRANSCRIPT
![Page 1: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/1.jpg)
CETPABecause Knowledge Matters
A market leader in the field of technical training for over a decade is glad to organize a workshop on ORACLE Technology to shape the career of bright students and to turn them into great engineers. We hope to have a good time with you.
![Page 2: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/2.jpg)
ORACLE
![Page 3: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/3.jpg)
Introduction to Oracle
Physical Structure Logical Structure
SOA Background Processes
Backup Methods Computer Science Database – CS01
Administrative Tasks
![Page 4: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/4.jpg)
FEATURES OF ORACLE
Managing Storage and Data
Managing & Using Information
Maintaining Availability, Security and Performance
Managing Systems And Managing Change
![Page 5: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/5.jpg)
ORACLE TASK
• Cold Backup (aka Consistent Backups)– The only way to make a consistent whole database backup
is to shut down the database with the NORMAL, IMMEDIATE, or TRANSACTIONAL options and make the backup while the database is closed.
– Advantage : No recovery is required after datafiles are restored – quicker restore
– Disadvantage : No access to database during backup time (depends on size/system speed)
![Page 6: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/6.jpg)
Oracle Corporation
• US$ 10b company
• Over 40,000 employees
• 200,000 Database Customers Worldwide
• 13,000 Applications Customers Worldwide
![Page 7: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/7.jpg)
Automatic Storage Management
• The preferred and best storage manager for Oracle Databases
– Easier to manage than file systems– Performance of raw volumes– Built-in to Oracle database – Shared storage pool for all
databases• Free, and widely adopted
– >65% of 10g RAC deployments on ASM– >25% of 10g customers already using ASM– Many VLDB over 10TB
ASM DiskASM Disk
ASM DiskASM Disk
ASM Disk
![Page 8: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/8.jpg)
020406080
100120
0.1 1 10 100
LOBs
Linux Files
SecureFiles
• Innovative technology for high performance large object data–Smart buffering, write gathering, intelligent locking
–Fast bulk data transfers, LOB prefetch
• Much faster than LOBs with more capabilities
• File system-like performance with database functionality!
File Size (MB)
SecureFiles Breaks thePerformance Barrier!
File Read Performance(MB/second)
![Page 9: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/9.jpg)
DatabaseEncryption
• Encrypt at a column level (10g)
• New: encrypt entire tablespaces
• Redo, undo, backups also encrypted
• Key management done by database
• Transparent to applications
![Page 10: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/10.jpg)
Oracle Partitioning10 years of innovation
Core functionality
Oracle8 Range partitions, global range index
Oracle8i Hash and composite range-hash partitioning
Oracle9i List partitioning
Oracle9i R2 Composite range-list partitioning
Oracle 10g Global hash indexes
Oracle 10g R2 1M partitions per table
![Page 11: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/11.jpg)
Extending Oracle’XML Lead
Comprehensive XML storage and indexingand efficient end-to-end XML processing
• Binary XML - Compact and efficient storage representation– Complements existing object storage and text storage models– XMLtype storage format transparent to developer– Single, compact XML representation across client, mid-tier, db– Plan to place our Binary XML format into open source
• XML Path Indexing for schema-less XML documents
Performance
![Page 12: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/12.jpg)
Oracle XMLDB –Sustained Innovation
1998 2001 2004 2007
Perf
orm
ance
XMLStorage &RepositoryXML
API’s
XQuery
Binary XMLStorage& Indexing
![Page 13: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/13.jpg)
Data Security: Oracle ProductsIdentityManagement• Oracle Identity Management
DataProtection• Advanced Security• Secure Backup
AccessControl• Database Vault• Label Security
Monitoring• Audit Vault• EM Configuration Pack
Core Platform Security
![Page 14: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/14.jpg)
Notification Services
Send
Respond
Forward
Cancel
Query
Oracle Workflow Enabled Application
Oracle Database Server
WorkflowEngine
Execution
Definition
Administration
Monitoring
Query
WorkflowBuilder
WorkflowLoader
WorkflowDefinition
Files
WorkflowDevelopment
Client
OracleHTTP
Server
ApplicationServer
WebNotification
Worklist
WebMonitor
WebAdminTools
Browser Client
Business Event System
Send
Receive
Raise
Listen
Query
Oracle Workflow Architecture
![Page 15: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/15.jpg)
Automatic Diagnostic WorkflowDiagnostic Repository
Apply patch / workaround Use Repair Advisors
If unknown issue
Package incident & configUse Repair Advisor
Auto Incident Creation First-Failure Capture
Alert DBA Run Health Checks
Reduce Time to Problem Resolution
Error!
Check Metalink
If known issue
EM Support Workbench
![Page 16: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/16.jpg)
Develop on Windows, Database on any Platform(.net)
Visual StudioEnvironmentVisual StudioEnvironment
Oracle Developer Tools for VS.NET
Oracle Developer Tools for VS.NET
Windows
Windows
Linux
Unix
Oracle 10g, 9i, or 8i
Other
![Page 17: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/17.jpg)
Write .NET Stored Procedures for Oracle
Visual StudioEnvironmentVisual StudioEnvironment
Oracle Developer Tools for VS.NET
Oracle Developer Tools for VS.NET
Oracle DB Extensions
for .NET
Oracle DB Extensions
for .NET
C#,VB.NET,C++Server Project(Use ODP.NETif required)
C#,VB.NET,C++Server Project(Use ODP.NETif required)
Assembly foo.dll
(proc sp)
Assembly foo.dll
(proc sp)
Build
Develop
Stored Proc
Stored Procedure,
SQL ..
Stored Procedure,
SQL ..
ClientApplication
ClientApplication
Invoke
Invoke
Deploy
![Page 18: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/18.jpg)
Oracle AS Containers for J2EE Demonstration
![Page 19: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/19.jpg)
• Highest Quality of Service– Performance– Scalability– Availability– Security
• Lowest Cost• Easier to Manage• Reduce risk of change
![Page 20: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/20.jpg)
WHY ORACLE??
Visual StudioEnvironment
IIS
Oracle Developer Tools for VS.NET
C++, C#, VB .NET
Application
Develop
ODP.NET
Deploy
Oracle DB Extensions
For .NET
IIS(ASP
ASP.NET)
MTS/COM+
Application
Deploy
Oracle Services for MTS
Database Development
![Page 21: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/21.jpg)
Benefits
• Easy to learn and intuitive • Leverage SQL Server development experience • Powerful features that enhance productivity – e.g.
designers, auto code generation• Exposes latest and greatest Oracle functionality • Stay in Visual Studio for project lifecycle
![Page 22: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/22.jpg)
INFLUENCE / RESALE / REFERRAL
Go-to-Market EngagementEN
GAG
E /
ENAB
LEG
O-T
O-M
ARKE
T
BUSINESS DEVELOPMENT INITIATIVES
Partner CertifiedCertified
Advantage
PARTNER CATEGORIES
EDUCATIONPROVIDERS
HW / INF
ISV RESELLERSSERVICE
PROVIDERS
INDUSTRIES
MID-MARKET
SYSTEMINTEGRATORS
![Page 23: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/23.jpg)
![Page 24: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/24.jpg)
WHAT CETPA OFFERS….
• Writing Basic SQL Statement.• Restricting and Sorting Data.• Single Row Function.• Displaying Data From Multiple Tables.• Aggregating Data Using GROUP Function.• Sub-Queries.• Creating and Managing Tables.• Including Constraints.• Views.• Other Database Objects.• Controlling User-Access.• USING SET Operators.• Enhancement to the GROUP BY Clause.• Advance Sub-Queries.• Hierarchical Retrieval.
![Page 25: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/25.jpg)
Contact Details
![Page 26: Summer training oracle](https://reader034.vdocuments.us/reader034/viewer/2022051322/54640d31af79596b4d8b49e5/html5/thumbnails/26.jpg)
THANK YOU…
We are really very grateful to all of you for sharing your valuable time with us during the workshop. We hope you had a good time learning with us and we look forward to hear from you very soon in near future.!!!
Have a great time ahead………!!!!!
Presented by: