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

...This developer-oriented presentation uses mainly examples to elaborate on the following SQL features: Data retrieval - SELECT statement Data aggregation (e...

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

...matrices and charts Sort data in reports Filter data Format reports Publish reports Render reports in Excel, PDF, etc Format: Lecture and hands-on...

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

...Experienced Oracle DBAs and/or system administrators who are conversant with Oracle 9i's new features and enhancements. Summary: This presentation elaborates...

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

...Upon completion of this course, the participant should be able to create and manage the fundamental Oracle schema objects: database, tablespace...

...Upon completion of this course, the participant should be competent to code PL/SQL applications incorporating PL/SQL components and constructs shown under...

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

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

...(in the detailed outline), especially SQL query optimisation...

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

...etc. To assist clear thinking with regards DB2 objects vs. Oracle objects, terminology differences are supplied at the beginning of each major...

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

...Upon completion of this course, the participant should be understand the entailments of planning, implementing and tuning the DB2 UDB Database Manager and the DB2 UDB database...

...DB2 SQL interface options (e.g., Command Line Processor, Command Center) Overview of Data Definition Language (DDL): Create/Alter/Drop DB2 objects...

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