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

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

...Suitable for: Developers: SQL and Transact-SQL, report authors and report developers. Developers: SQL and Transact-SQL, report authors and report developers...

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

...the delegate should be competent to: Understand report models Create reports using Report Builder Create different types of reports, such as tables...

...OLTP and BI/data warehousing are given equal billing. Objectives: Upon completion of this presentation, the delegate should have a practical knowledge...

...Currency: 10g Releases 1 & 2 (where useful, compared with 9i) Audience: Oracle DBAs, system administrators and technical support. Prerequisites...

...Fundamentals (ORADBA) Oracle Data Warehouse Design (OWHDWD) Oracle Data Warehouse Performance & Tuning (OWHWPT) Oracle Data Warehousing: ETL Specifically (OWHETL)...

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

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

...Suitable for: Database administrators, system administrators and performance analysts. Database administrators, system administrators and performance analysts...

...Minimum of 6-months of SQL*Plus and PL/SQL developer experience or its equivalent. Summary: This course focuses on best practices and performance issues...

...IT executives, DBAs and system administrators. IT executives, DBAs and system administrators. Currency: Oracle 10g & 11g vs. DB2 UDB V8.2.x & V9 Audience...

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

...Suitable for: DBAs, production DBAs, system administrators and capacity planners. DBAs, production DBAs, system administrators and capacity planners. Level...

...and components of a DB2 UDB database. Understand data modelling concepts. Understand DB2 UDB objects and recovery facilities. List and describe DB2...

...this hands-on course develops, for the delegates, a working knowledge of DB2 for LUW in terms of: Planning Implementation Performance Objectives...

...INSERT, UPDATE and DELETE statements to manipulate relational data stored in one-or-more tables...

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