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. Suitable for: SQL Server DBAs, capacity planners and system administrators. SQL Server DBAs, capacity planners and system administrators...

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

...This presentation details how to use SQL Server's isolation levels for lock avoidance and read consistency, mainly in OLTP environments. Objectives...

...Upon completion of this presentation, the delegate should be competent to: Understand report models Create reports using Report Builder Create different types of reports...

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

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

...10g & 11g Audience: Database administrators, system administrators and developers. Prerequisites: At least 1 year of IT experience. Summary...

...Currency: 10g & 11g Audience: Aspiring Oracle DBAs, junior DBAs and Oracle production DBAs. Prerequisites: Completion of our course Oracle Architecture...

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

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

...processes and schema objects. Summary: This course discusses all of the Oracle index options: B*tree Bitmap Hash Partitioned Index clustered table...

...firm grounding in Oracle's: Indexing options Cost-Based Optimizer (CBO) statistics I/O types (access paths) Partitioning options PL/SQL good practices...

...Additionally, the following are among other comparisons made: Hardware requirements Software requirements Price considerations Security issues Backup/recovery...

...DB2's storage, partitions, table spaces, buffer pools, etc. DB2 security features DB2 locking & concurrency facilities DB2 processes DB2 SQL facilities...

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

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

...additionally, the participant should have a working knowledge of access rights, authentication and authorisation...

...(correlated & non-correlated) Subselects Column/scalar functions Objectives: Upon completion of this lab-oriented course, the delegate should be competent to code SQL SELECT...

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