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

...the remaining, about 65%, of this hands-on course is dedicated to: Troubleshooting and problem-solving Performance and tuning optimization Tuning methodology...

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

...Upon completion of this presentation, the participant should understand SQL Server's: Concurrency controls Isolation levels Snapshot isolation Row versioning...

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

...Change management Database automation Storage management Fault diagnosis High-availability Security Partitioning Etc. At regular intervals, hands-on practicals...

...on Oracle's 10g R1 & R2 new features and enhancements as these should be of interest to Oracle technicians. Each 10g new feature and enhancement is compared...

...Suitable for: Database administrators, system administrators and developers. Database administrators, system administrators and developers. Currency...

...the participant should be able to create and manage the fundamental Oracle schema objects: database, tablespace, table, index, and the...

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

...Among the featured topics are: Collections SPARSE collections Table functions BULK COLLECT Cursor variables Dynamic SQL Packages PL/SQL optimisation Locking...

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

...The aim of this presentation is to clarify the physical and logical structural differences and similarities as these relate to Oracle 10g and DB2 UDB...

...details on backup/recovery but, due to time constraints, summarises other commands and utilities such as RUNSTATS, EXPORT, IMPORT db2look, table and table space recovery...

...Summary: Designed mainly for DBAs, this course comprehensively covers DB2 V9 new features, including: New automated database administration Large databases...

...Upon completion of this course, the participant should be able to: Describe the scope of each member of the DB2 UDB family. Characterise the properties...

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

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