Wise courses

...theories and practices, this presentation elaborates on the SQL Server database engine in terms of its facilities related to: Architecture Configuration DB...

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

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

...schema objects, etc. Summary: This DBA-oriented course presents the more useful new and enhanced features incorporated as part of Oracle 11g such...

...in both OLTP and data warehousing environments. Suitable for: Oracle DBAs, system administrators and technical support. Oracle DBAs, system administrators and technical support...

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

...indexes, etc. - in terms of how they work. Additionally, backup and recovery, load, import, export, etc. utilities are central to the hands-on exercises...

...semantics, constructs, etc. The training goals and objectives are mainly realised through extensive use of real-world examples, exercises and hands-on computer-based...

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

...in the following contexts: Structure and organisation How to choose Column selectivity Maintenance Performance Monitoring OLTP vs. data warehousing Objectives...

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

...Data warehousing Objectives: Upon completion of this presentation, the participant should be conversant with Oracle vs. DB2 comparative differences and similarities...

...the participant should understand: DB2 product family and environment A broad range of DB2 commands and utilities (especially backup and recovery)...

...via partitioning Enhanced security System performance Scalability options Manageability options XML considerations DB2 commands/utilities enhancements...

...Prerequisites: Minimum of six (6) months experience in any IT environment. Summary: This concepts and facilities presentation provides a focused introduction...

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

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

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