Teaching Oracle to Write sql*Plus (Or using sql as a Code Generator)




Скачать 114.35 Kb.
НазваниеTeaching Oracle to Write sql*Plus (Or using sql as a Code Generator)
страница1/2
Дата01.03.2013
Размер114.35 Kb.
ТипДокументы
  1   2



Conference Autumn 2009

Tryavna, 13th Nov – 15th Nov 2009


Sessions and Speakers












13 Nov 2009

Hall Tryavna

12.00 - 13.00

Conference session

Teaching Oracle to Write SQL*Plus (Or using SQL as a Code Generator)

Peter Robson, Independent, JustSQL, ,


Valid SQL statements can be generated from Oracle by embedding SQL commands (as string variables), within a ‘parent’ script.

This can appear a complex process, particularly when multiple hierarchies of scripts are built, combined with the retrieval of attributes used as variables in the ‘next’ embedded script. However, the construct of these scripts is very logical, which enables the skilled practitioner to build them quickly and easily.

The technique is a powerful means of achieving results that would otherwise only be possible in a 3GL host language. The skilled dba can deploy this type of script to perform a wide range of tasks, thus further enhancing the considerable value of SQL*Plus as a dba tool.

Increasingly complex examples will be presented (using animated PowerPoint screens), to show clearly the rules required to enable the successful construct of these nested scripts, and the most efficient means of building them.

Speaker

Qualified as a geologist, then moved into IT in the late 1970’s, immediately specialising in database. Joined the British Geological Survey in 1980; the prime mover in having relational database adopted as the corporate data repository. Designed, built and extended the corporate Data Architecture covering multiple instances of Oracle. Built advanced replication software maintaining remote instances synchronous. Strong analytical and design skills combined with an active interest in extending the boundaries of SQL. Has presented at conferences (Oracle and others) all over Europe, the UK, and in North America, and is currently a Director of the UK Oracle User Group with special responsibility for their Membership. Represents Chris Date in Europe, organizing seminars for him.




13 Nov 2009

Hall Bulgaria

12.00 - 13.00

Demonstration


Exadata adventures

Yavor Ivanov, Mediation Engineer, Mobiltel, / ,


Being the first in the world to adopt new technology has a price. The price usually is doubled (at least) efforts and sleepless nights. I will present a story about Mobiltel’s custom Exadata implementation, which is the first (successful) in the world.

Speaker

There is that feeling when everything is working perfectly. When you know the data is protected. You know the service is guaranteed. The users are able to do their job, and you know they will be able to do it tomorrow, and the day after, and the year after that… The feeling when you know everything is done the way it is supposed to be done. It may have been hard work, but you know it’s done properly.

There is a point after which you just start to feel the system’s pulse. And the data is the blood of the system.

When I can sense that the system is working smoothly… this is the feeling that makes me happy.

I like the data. I can feel the data. I care about the data.

I’m mostly focused on the following areas:

- High availability - RAC, MSCS + FailSafe, HP ServiceGuard

- Disaster recovery - Data Guard, Standby database, Replication

- Backup strategies - not "scripts", but "strategies"

Outside of the database, I care about the workflow, usage patterns, user troubles and other things that may lead to a better system or a worse one. The database is the heart of the system; the data is the blood. But I know the system is something complex and the data in itself cannot do any good. I am training my ability to take a look at the whole system from a bird’s eye view.

But my passion is the data




13 Nov 2009

Hall Tryavna

13.15 - 14.15

Conference session

The Power of 11g Automatic SQL Tuning

Julian Dontcheff, OCM, Head of DBAs, NOKIA Corp., / ,


After almost 2 years in Nokia’s production environment, 11g automatic SQL tuning has proven to work even better than expected. For a Data Center DBA team administering hundreds of databases, this new feature of 11g has become DBA’s best friend. I will provide tips on how to get the best out of it.

Speaker

First Oracle Certified Master in Europe, more than 20 years of database experience




13 Nov 2009

Hall Bulgaria

13.15 - 14.15

Conference session

Easy_reporting_with_free_tools.PDF

Stoyan Ivanov, Owner, Easy Systems, / ,


The following presentation will show how, just using an Oracle Database on Linux without any special reporting tools, one still can develop reports that are in PDF or in some other formats in a productive and easy to maintain way.

Speaker








13 Nov 2009

Hall Tryavna

15.00 - 16.00

Conference session


Loading 1TB in an hour with Exadata V2

Owen Hughes, Director EMEA Database Technologies, Oracle Corp, ,

Last year at Oracle Open World, Oracle launched the Oracle Database Machine, a complete package of software, servers, and storage with the power to tackle large-scale business intelligence problems immediately and scale linearly as your data warehouse grows. In this session, we will demonstrate how to use an Oracle Database Machine to load, transform, and query a 1-terabyte database in less than an hour. The demonstration shows techniques for exploiting full database parallelism in a simple but optimal manner.

Speaker

Owen Hughes has over 15 years experience in the IT industry and is currently Technology Director for EMEA Core Technology, with primary focus on Sun Oracle Exadata and Sun Oracle Database Machine Technologies at Oracle Corporation. Prior to joining Oracle, his previous role was as a technologist, providing architectural and business expertise to State and commercial companies in Ireland across the Financial Services, Communications and Service sectors. He has worked for various companies in Ireland focusing on Oracle solutions. Owen holds a Bachelor of Science Degree in Computer Applications from Dublin City University and a Masters in Technology Management from the National Institute of Technology Management in University College Dublin.




13 Nov 2009

Hall Bulgaria

15.00 - 16.00

Presentation,

Demonstration


10 myths about Oracle Siebel CRM

Stanimira Nakova, CRM Consultant,
Boris Stefanov, Technical Lead, TechnoLogica, ,


Siebel CRM On Demand

“Brought to you by the No.1 company in CRM, Oracle's Siebel CRM On Demand gives you the power to break down departmental silos and gain a 360-degree view of your customers.

Siebel CRM On Demand is a comprehensive, strategic CRM solution that goes far beyond any other software as a service offering to help you bring clarity to your sales processes; build loyal, long-term customer relationships; accelerate productivity; boost call center efficiency; and derive comprehensive, real-time customer intelligence.” Oracle

What else can be added about Oracle Siebel CRM?

Speaker

Stanimira Nakova works for TechnoLogica Ltd. http://www.technologica.com as CRM Consultant.

Boris Stefanov works for TechnoLogica Ltd. http://www.technologica.com as ERP Technical Lead.

They work on sophisticated projects including but not limited to: defining technical architecture(s), capacity planning, integration with legacy and OTC systems, disaster recovery scenarios, business process analysis, creating and managing the execution of project plans, implementing CRM/ERP/EPM/SCM solutions, perform coaching.

Boris Stefanov is OCP DBA 8, 8i, 9i and MCP DBA.

Stanimira Nakova has bachelor degree in Computer Science, Sofia University “St. Kliment Ohridski”, Sofia, Bulgaria, Faculty of Mathematics and Informatics – http://www.fmi.uni-sofia.bg and Master Degree in Business Administration (MBA), University of Veliko Tarnovo “St. St. Cyril and Methodius”, Bulgaria





13 Nov 2009

Hall Tryavna

16.15 - 17.15

Demonstration,

Conference session

Does the business process define system functionality or vice versa?

Bistra Papazova, Head of Management Consulting Department, Interconsult Bulgaria OOD, ,



Speaker

Bistra Papazova is Head of Management Consulting Department at Interconsult Bulgaria. She has participated in consulting projects related to Balanced scorecard, business process management, process-based information system requirements, and ARIS implementation at Nuclear Power Plant Kozloduy, Prista Oil, E.ON Bulgaria, Siemens Bulgaria, Sofiyska Voda and others. Previously Bistra has been Client Services Director at Netage Solutions where she was responsible for CRM system implementation at over 90 international companies, including Goldman Sachs and Merrill Lynch. Bistra has an MBA degree from the University of Maryland.




13 Nov 2009

Hall Bulgaria

16.15 - 17.15

Conference session


Overview from Application Express version 3.2.1

Iloon Ellen-Wolff, Principal Technical Support Engineer and Global Technical Lead Application Express, Oracle The Netherlands, ,

The conference session will give an overview of Application Express. What kind of tool and most important features within the product.

Speaker

I started working with Oracle products nineteen years ago, employed by several software houses in The Netherlands. My experience goes back to Oracle Forms version 2 and Report*writer. Almost eleven years ago, I started working for Oracle Support Services for the developer competency (Oracle Forms, Oracle Reports and Application Express) assisting customers with solving their software problems. During those years, I applied my gained knowledge in other ways like coaching new engineers, team leading and teaching Application Express courses for Oracle University




13 Nov 2009

Hall Tryavna

17.45 - 18.45

Conference session

Oracle UCM: Platform for building web site

Miroslav Georgiev, Tech Lead, Magic Solutions

Anatoli Atanasov, Senior Technology Sales Consultant, Fusion Middleware, Oracle Bulgaria, ,


Oracle Universal Content Management (UCM) provides an enterprise-class Web content management framework with the tools necessary to effectively manage Web sites. It dramatically improves Web publishing productivity and enables organizations to maintain accurate, timely, and current Web content with consistent branding and presentation across all corporate sites.

Speaker

Anatoli Atanasov works for Oracle Corporation branch Bulgaria as a Senior Technology Sales Consultant specializing in and covering the Oracle Fusion Middleware product portfolio. His main responsibilities include designing scalable middleware infrastructures, educating the BG middleware market, consulting customers on different IT projects, etc. He has strong background in software development with Java and Oracle middleware and database technologies.

Prior to joining Oracle from a partner, Anatoli Atanasov had worked in different projects mainly in the Financial and Public sectors as a software engineer. In the last couple of years he is specializing in Service Oriented Architectures, Business Process Management, Java development and Portals, Application and Database Security and Content/Document Management Solutions.

Anatoli Atanasov has Master of Science degree from Sofia University “St. Kliment Ohridski” in Software Engineering and Bachelor degree from Technical University of Sofia in Computer Systems and Management.




13 Nov 2009

Hall Bulgaria

17.45 - 18.45

Conference session

SQL Developer Unit Testing

Barry McGillin, Senior Development Manager, Oracle Corp, ,

This session will show you how to prepare a set of unit tests for your database application.  This enables you to graphically define your tests based on their definition as shown in SQL Developer and see real time results based on your input.  This feature, released with SQL Developer 2.1 is another tool for your toolset as you produce production level code.

Speaker

Barry has 15 years experience in databases, middleware, software development, and project management. Barry has been working in Oracle with the database since 1992 (6.0.36). He regularly speaks at conferences and has spoken in over 27 countries showing customers how to make use of Oracle and migrate their applications to it. Today, he is the development manager for SQL Developer.




13 Nov 2009

Hall Tryavna

19.00 - 20.00

Conference session

Oracle 11g R2 Features

Owen Hughes, Director EMEA Database Technologies, Oracle Corp, Mihail Kalachev, Senior Database Administrator, Mobiltel, ,

"Consolidate Compress Control" - this is the moto of the latest and most promising release of Oracle 11g - Release 2. Since its release date on the 1st of September 2009, there have been many quotes about it like: "delivers highest quality of service at much lower cost" or "11gR2 is a big step forward to managing Oracle Real Application Clusters like a single platform". Be among the first in the world to learn about all the cool new features that make all those nice quotes come true.

Speaker

Owen Hughes has over 15 years experience in the IT industry and is currently Technology Director for EMEA Core Technology, with primary focus on Sun Oracle Exadata and Sun Oracle Database Machine Technologies at Oracle Corporation. Prior to joining Oracle, his previous role was as a technologist, providing architectural and business expertise to State and commercial companies in Ireland across the Financial Services, Communications and Service sectors. He has worked for various companies in Ireland focusing on Oracle solutions. Owen holds a Bachelor of Science Degree in Computer Applications from Dublin City University and a Masters in Technology Management from the National Institute of Technology Management in University College Dublin.


5 years of professional experience in the field of Database Administration. 2 years of experience with Oracle Database Administration. Since 2006 - Database Administrator in MobilTel EAD – the biggest Bulgarian Mobile Operator. Senior DBA since 2009. Professional interests are in the following areas: Oracle Exadata, Real Application Clusters, Performance tuning and optimization, Very Large Databases, Disaster Recovery.




13 Nov 2009

Hall Bulgaria

19.00 - 20.00

Conference session

Faster, Better, Cheaper JD Edwards EnterpriseOne Implementations: Oracle Business Accelerators

Yonka Zoteva, Functional Team Leader Oracle Applications, TechnoLogica,
Maria Petrova, Applications Developer, TechnoLogica, ,

Oracle Business Accelerators are powerful tools that optimize Oracle's JD Edwards EnterpriseOne implementations. We, as Oracle partners, could leverage these tools to quickly and predictably deploy a full range of industry-specific implementations for midsize and enterprise customers. In this session we will focus on the main components of OBA and how to use the configuration tools to quickly prepare a demo for a customer.

Speaker

Yonka Zoteva is OCP DBA and OCP Consultant. She has more than 5 years of professional experience with Oracle Applications and has participated in several ERP implementations.

Maria Petrova has recently joined TechnoLogica APPS team. Her major responsibilities are applications installation and configuration as well as custom solutions development.




14 Nov 2009

Hall Tryavna

9.30 - 10.30

Discussion

Oracle - Google integration

Anjo Kolk, Owner, Miracle Benelux, ,


Google has many different APIs that can be used freely. In this presentation we will focus on Google Spreadsheet and Google Visualization with the Oracle DB. We will show you how to built dashboards with Google Spreads, igoogle and normal webpages.

Speaker

Anjo started as a trainee at Oracle. A job was offered and the next 16 years Anjo worked for Oracle. He worked mostly with the RDBMS Performance and Oracle Parallel Server. In those 16 years he lived in the Netherlands, Ireland, Japan and the USA.

During his time with the Oracle Server Performance Group Anjo worked with many big companies that are specialized in making or selling software (Baan, SAP, Amdocs etc). He also worked at customers all over the world (like NTT, Docomo etc.) to help them improve the performance of their systems as well as implementing new systems.

While he was working on these performance issues he developed a tuning method called YAPP (Yet Another Performance Profiling Method) to tune Oracle systems based on response times. He is recognized as the father of the YAPP-methodology which was first documented in the YAPP white paper in 1998 and publicly used in his website oraperf.com. This method can also be used on non-Oracle SQL systems.

He taught at many internal Oracle classes, throughout the world. He is the author of the well known an often quoted "Oracle7 Wait Events and Enqueues" white paper, the owner and inventor of the http://www.oraperf.com website, and one of the founders of the Oaktable Network.

After Oracle he worked for Precise software Solutions for 2 year as an Oracle Technologist, and worked for Veritas Software Application Performance Management (APM) for 2 years as an Oracle Technologist where he developed performance prototype software. In September 2006 he founded Miracle Benelux.

On 12 April 2007 Anjo and his good friend Mogens Nørgaard became Oracle ACE's "which formally recognizes Oracle advocates with strong credentials as evangelists and educators in that community."




14 Nov 2009

Hall Bulgaria

9.30 - 10.30

Demonstration


What’s new in Oracle Database 11g security

Nikolay Manchev, Head of Standard Software, Index Bulgaria Ltd., ,


During this session the audience will learn about security enhancements in Database 11g like new passwords features, default auditing, Fine Grained Network Access, connection throttling etc. There will be live demos on some of the features. We will also discuss the differences between 10g and 11g in а certain security situations.

Speaker

Nikolay has a strong technical background in the middleware and database field. He used to work for BEA and Oracle Bulgaria and is currently leading complex system integration projects at Index Bulgaria. He is an Oracle, Sun and VMWare certified. Nikolay is а guest lecturer at the University of Plovdiv and University of Sofia, Honored Member of the Bulgarian Association of Software Developers and Member of BGOUG. He is hosting a site dedicated on Oracle technologies at www.manchev.org (available only in Bulgarian)




14 Nov 2009

Hall Tryavna

10.45 - 11.45

Conference session

NetApp Oracle Solutions

Lars Ejskjaer, Technical consultant – FTS EMEA, NetApp, ,

For more than a decade, NetApp and Oracle have continued to collaborate and share the same vision. We focus on developing solutions that help you reduce the complexity of managing and storing information.


Dynamic Infrastructures from Fujitsu – FlexFrame for Oracle

Todor Todorov, Technology Sales Consultants, Fujitsu, ,

FlexFrame for Oracle - Dynamic assignment of servers to Oracle services

- ideal for a stepwise Oracle consolidation on industry standard platforms

- manages both – real and virtual servers

- an ideal platform for Oracles Grid Computing and SOA strategy

Speaker







14 Nov 2009

Hall Bulgaria

10.45 - 11.45

Conference session

OracleUnix-like

Svetoslav Gyurov, System Engineer, CnSys, ,

The presentation will focus on how Linux penetrated the enterprise OS market and Oracle installations on industry standard servers. This will outline main high availability techniques and tunable system considerations. The presenter will make a comparison between Linux and Unix environment and show why Linux is not yet at the level of the proprietary Unix systems.

Speaker

Svetoslav Gyurov is a System Engineer at CNSys PLC. He is experienced in the area of business critical servers, storage systems and high availability solutions. He is interested in Oracle Database, Oracle RAC, Oracle Dataguard, virtualization, system and database administration.


OCP DBA 9i, 10g

HP-UX Certified Systems Expert 11iv2,v3




14 Nov 2009

Hall Tryavna

12.00 - 13.00

Conference session

Fusion Middleware 11g: Foundation for Innovation

George Moykin, Senior Presales Consultant, Fusion Middleware, Oracle Bulgaria, Oracle, ,


Oracle Fusion Middleware 11g is a modern application infrastructure that significantly improves the agility and intelligence of business applications while enabling organizations to exploit new hardware and software architectures for efficient IT execution and cost savings.

Speaker

More than 10 years of combined experience in IT engineering: designing and supervising the design of Enterprise applications and SOA (Service-Oriented Architecture) solutions, performing technology due diligence, providing complex technical and sales consultations, offering Middleware solutions and defining project implementation success criteria for IT industry and business.

Qualifications:

2008 - Certified SOA Solutions Architect

2006 - BEA Certified Developer: Build Solutions

1995 - Master of Science: Mathematics and Informatics, University of Sofia “St. Kliment Ohridski”




14 Nov 2009

Hall Bulgaria

12.00 - 13.00

Conference session

Oracle Clusterware and Private Network Considerations -
Practical Performance Management for Oracle RAC


Guenadi Jilevski, OCM, Sr. Oracle DBA, VP of GJ Information Consulting Inc., GJ Information Consulting Inc., / ,


Oracle Clusterware and Private Network Considerations -
Practical Performance Management for Oracle RAC

Speaker

Consultant with more than twenty years of industry experience in high profile Oracle projects in Far East and Americas. Master of Science (Computer Science), Sofia Technical University, Sofia, Bulgaria. Ph.D. VLSI Design, Sofia Technical University, Sofia, Bulgaria. Oracle Certified Master, Certified Oracle 7.3, 8, 8i & 9i Database Administrator (OCP)
  1   2

Похожие:

Teaching Oracle to Write sql*Plus (Or using sql as a Code Generator) iconЛабораторная работа №5 посвящена оптимизации запросов и работе с индексами
Лабораторные работы заключаются в изучении языка sql. Работы выполняются в sql plus под управлением системы Oracle (версии не ниже...
Teaching Oracle to Write sql*Plus (Or using sql as a Code Generator) iconЛабораторная работа Использование редактора запросов sql borland sql explorer(TM) для создания запросов к данным с использованием языка sql

Teaching Oracle to Write sql*Plus (Or using sql as a Code Generator) iconSiebel Configuration, Data Migration, eim, Oracle pl/sql, Performance Tuning

Teaching Oracle to Write sql*Plus (Or using sql as a Code Generator) iconСтруктурированных запросов sql в
...
Teaching Oracle to Write sql*Plus (Or using sql as a Code Generator) iconЛабораторная работа №1. Создание функций на pl/sql
Функции предназначены для использования в sql-предложениях, обращающихся к соответствующим отношениям. Они, по возможности, не должны...
Teaching Oracle to Write sql*Plus (Or using sql as a Code Generator) iconУчебного заведения
Курс повышения квалификации: Изучение программных модулей языка pl/sql для базы данных oracle
Teaching Oracle to Write sql*Plus (Or using sql as a Code Generator) icon1. Распределенные базы и хранилища данных
Базовыми субд для проведения практикума и лабораторных работ являются ms sql server 2005 и Oracle Server 10G
Teaching Oracle to Write sql*Plus (Or using sql as a Code Generator) iconЭкзаменационные вопросы интернет-курсов интуит (intuit): 241. Проектирование информационных систем в Microsoft sql server 2008 и Visual Studio 2008
Если при создании новой пользовательской функции используется одна sql команда после служебного слова return, то в этом случае
Teaching Oracle to Write sql*Plus (Or using sql as a Code Generator) iconКен Хендедерсон хотел написать самую лучшую из возможных книг практическое программирование на Transact-sql. Ему это удалось. Когда он начинал ее писать, в
Книга предназначена для программистов. Она написана, чтобы помочь разработчикам создавать приложения, которые используют Transact-sql....
Teaching Oracle to Write sql*Plus (Or using sql as a Code Generator) iconОбщая характеристика субд
Архитектуры субд: центра­ли­зованная, файл-сервер, клиент-сервер, тонкий клиент – сервер приложений – сервер базы данных. Oltp и...
Разместите кнопку на своём сайте:
Библиотека


База данных защищена авторским правом ©lib.znate.ru 2014
обратиться к администрации
Библиотека
Главная страница