Wise courses

...Upon completion of this presentation, the delegate should have an intimate understanding of the SQL Server DB engine per the 'Core Topics' in the detailed outline...

...to both OLTP and OLAP environments. Format: Lecture and hands-on (about...

...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 Format: Lecture...

...Business intelligence/data warehouse specialists, BI managers, BI power users and anyone tasked with tactical and strategic planning and analysis. Business...

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

...Finally, locking and concurrency are explored in terms of transaction processing and recovery. Objectives: Upon completion of this course, the participant...

...DBAs and production DBAs. Currency: 10g & 11g Summary: This beginners PL/SQL application programming workshop focuses on PL/SQL definitions...

...& concurrency Performance and good practices Objectives: Upon completion of this course, the participant should be able to develop and tune advanced PL/SQL applications...

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

...but does not include the elaborate details one would expect in our comprehensive Database Administration presentation. For example, the workshop includes...

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

...Prerequisites: Minimum of six (6) months experience in any IT environment. Summary: This concepts and facilities presentation provides a focused introduction...

...Completion of our course DB2 Concepts & Facilities or equivalent knowledge. Summary: After discussing general relational database terms and concepts...

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

...Visual Explain concepts & operators Creating Explain snapshots for static & dynamic SQL Displaying and using an Access Plan Graph Improving an Access Plan Graph...