Wise courses

...theories and practices, this presentation elaborates on the SQL Server database engine in terms of its facilities related to: Architecture Configuration DB...

...Upon completion of this presentation, the participant should be able competent to troubleshoot and resolve SQL Server performance issues as these relate...

...This developer-oriented presentation uses mainly examples to elaborate on the following SQL features: Data retrieval - SELECT statement Data aggregation (e...

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

...Server 2005 Reporting Services' Report Builder tool to design and deliver a variety of report types in various formats. Objectives: Upon completion of this presentation...

...hands-on practicals are used to enhance the attendee's learning experience. Then Oracle 11g features are summarised in terms of best practices and performance...

...where useful, with its version 9i counterpart. Then Oracle 10g features are summarised in terms of best practices and performance. Objectives...

...Upon completion of this course, the delegate should understand Oracle database's architecture, API facilities and how this may contribute to various OLTP and BI solutions...

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

...Upon completion of this course, the participant should be competent to code PL/SQL applications incorporating PL/SQL components and constructs shown under...

...Prerequisites: Completion of our course Oracle PL/SQL Application Workshop or equivalent knowledge. Summary: This lab-oriented PL/SQL presentation focuses...

...in the following contexts: Structure and organisation How to choose Column selectivity Maintenance Performance Monitoring OLTP vs. data warehousing Objectives...

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

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

...the participant should understand: DB2 product family and environment A broad range of DB2 commands and utilities (especially backup and recovery)...

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

...Describe the scope of each member of the DB2 UDB family Characterise the properties and components of a DB2 UDB database Understand data modelling concepts...

...Upon completion of this course, the participant should be understand the entailments of planning, implementing and tuning the DB2 UDB Database Manager and the DB2 UDB database...

...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...

...Currency: V8 & V9 Audience: Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners...