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

...AVG, COUNT(*), MAX, MIN, SUM) Joins (INNER & OUTER) Data modification - INSERT, UPDATE, DELETE...

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

...such as tables, matrices and charts Sort data in reports Filter data Format reports Publish reports Render reports in Excel, PDF, etc. Suitable...

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

...This course describes, via examples and hands-on exercises, the Oracle database and its architecture. Emphasis is placed not only on what Oracle's features...

...this Oracle DBA fundamentals course describes Oracle's architecture, its processes and database objects - instance, database, tablespaces, tables...

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

...DBAs and production DBAs. PL/SQL developers, DBAs and production DBAs. Currency: 10g & 11g Audience: PL/SQL developers, DBAs and production...

...Currency: 10g & 11g Audience: Database administrators, system administrators and performance analysts. Prerequisites: Working knowledge of Oracle architecture...

...as these relate to Oracle SQL and PL/SQL. To this end, the Oracle EXPLAIN PLAN and related monitoring tools are central. As the EXPLAIN PLAN facility assumes...

...IT executives, DBAs and system administrators. Prerequisites: Working knowledge of Oracle architecture, processes and schema objects. Summary...

...DB2 processes DB2 SQL facilities Etc. Suitable for: DBAs and System Administrators. DBAs and System Administrators. Upon completion of this course...

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

...Aspiring System Administrators, Database Administrators, Application Developers, Security Analysts and Capacity Planners. Prerequisites: Completion...

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