Wise courses

...DB files Logging and recovery of transactions Tables and indexes SQL queries Locking and concurrency Security Data replication DB backup/recovery DB performance...

...Level: Intermediate-to-advanced Audience: SQL Server DBAs, capacity planners and system administrators. Prerequisites: Completion of our course SQL Server...

...Upon completion of this presentation, the participant should have a working knowledge of the topics outlined under 'Core Topics' in the detailed outline...

...Isolation level usage and good practices How to monitor isolation levels Isolation level usage and good practices How to monitor isolation levels...

...business intelligence power users and end users who want to develop reports with report models built by administrators. The course details how to use...

...Management: automatic SQL tuning Storage management: table compression BI (data warehousing): partition manipulation and loading...

...Upon completion of this presentation, the delegate should be able to think clearly so as to exploit new and enhanced options available in Oracle...

...Objectives: Upon completion of this course, the delegate should understand Oracle database's architecture, API facilities and how this may contribute...

...table, index, and the like. Suitable for: Aspiring Oracle DBAs, junior DBAs and Oracle production DBAs. Aspiring Oracle DBAs, junior DBAs and Oracle production...

...'Core Topics' in the detailed outline. Suitable for: PL/SQL developers, DW ETL developers, DBAs and production DBAs. PL/SQL developers, DW ETL developers...

...Upon completion of this course, the participant should be able to develop and tune advanced PL/SQL applications. Suitable for: PL/SQL developers...

...Upon completion of this presentation, the delegate should be able to choose amongst index options so as to optimise processing in OLTP and data warehousing environments...

...DBAs and system administrators. Currency: 10g & 11g Audience: SQL*Plus application developers, DBAs and system administrators. Prerequisites...

...Data warehousing Objectives: Upon completion of this presentation, the participant should be conversant with Oracle vs. DB2 comparative differences and similarities...

...DB2 processes DB2 SQL facilities Etc. Suitable for: DBAs and System Administrators. DBAs and System Administrators. Upon completion of this course...

...DB2 Explain and tuning tools SQL and application interface enhancements Objectives: Upon completion of this course, the participant should be able to think...

...security and authorisation concepts Currency: V8 & V9 Audience: Aspiring DB2 UDB for LUW System Administrators, Data Administrators and Application Developers...

...Aspiring System Administrators, Database Administrators, Application Developers, Security Analysts and Capacity Planners. Prerequisites: Completion...

...Prerequisites: Completion of our course DB2 UDB Fundamentals or equivalent knowledge. Summary: This course focuses on the scope and limits of basic SQL operations such...

...Prerequisites: Completion of our course DB2 SQL Essentials or equivalent knowledge. Summary: Among the topics covered in this course are: Visual Explain...