Vi ste ovdje
Overview/Description
In this course, the need for governance in a Service-Oriented Architecture environment is highlighted, and the different characteristics related to service management are covered. You are also introduced to the concepts that enable defining and implementing a service. This is an important aspect of designing an SOA system as it allows appropriate business functionality to be mapped to the appropriate service type.
Target Audience
Business Analysts, Sales Consultants, Technical Consultants, SOA Architects, Application Developers, and J2EE Developers.
Expected Duration (...
Overview/Description
This course provides an introduction to the topic of securing services and composite applications. It also describe the activities involved in SOA adoption planning.
Target Audience
Business Analysts, Sales Consultants, Technical Consultants, SOA Architects, Application Developers, and J2EE Developers
Expected Duration (hours)
1.0
Lesson ObjectivesOracle SOA Suite 11g: SOA Security and Adoption Planning
identify the features of Web Services Security
identify the features of Oracle Web Service Manager
attach security policies to services
authenticate users by attaching...
Overview/Description
To use Oracle-supplied packages
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
2.8
Lesson ObjectivesOracle-Supplied Packages and DBMS_SCHEDULER
use the DBMS_OUTPUT package to send a message...
Overview/Description
To create and work with Oracle 10g packages
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
2.8
Lesson ObjectivesPL/SQL Packages
recognize the structure of a package and outline the...
Overview/Description
To create and manage triggers
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
3.8
Lesson ObjectivesPL/SQL Triggers
identify the function, benefits, and enhancements provided by triggers in PL...
Overview/Description
SQL Server 2008 Analysis Services takes relational data and provides a robust way to analyze it in a meaningful way through MDX queries and data mining. This course will introduce the fundamentals of querying multi-dimensional data. It will introduce the MDX language which used to query multi-dimensional data. This includes a discussion on how to create a basic MDX query, how to establish a cube context, how to build subcubes and named sets, and how data can be modified with MDX. The course also provides a review of Key Performance Indicators (KPI), Actions, Perspectives...
Overview/Description
Enterprises use databases to store their most critical data. To protect and ensure the data's availability, database administrators need to establish a solid backup and restoration plan. Such plans are used to protect data in the event of a disaster by allowing complete sets of duplicate data to be restored in a timely fashion. There are multiple types of backups that can be taken to ensure the recovery of data, including a full recovery or a point-in-time recovery. SQL Server 2008 R2 also offers database snapshots, which can be used to revert a database to a specific...
Overview/Description
SQL Server 2008 R2 offers the use of partitions to manage subsets of data for large tables and indexes. Partitions can be used to improve the read/write performance on tables within a database by allowing the data within tables to be spread across multiple filegroups, whereas standard tables must be contained within a single filegroup. Data that is stored within partitions is treated as a logical entity, and the partitioned tables and indexes support the same properties as a standard table. SQL Server 2008 R2 allows views to be partitioned, which joins data from multiple...
Overview/Description
SQL Server 2008 R2 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2008 R2 database to meet business requirements, administrators and developers must fully understand how to design, create, and configure these database objects. These objects include tables for storing data in the database, views to allow access to the data within specific tables, and indexes to optimize the performance of the database for data retrieval. This course identifies each of these database objects and...
Overview/Description
SQL Server 2008 R2 provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may need to be split to allow for more data to be stored, or data from one partition may need to be moved to another partition. SQL Server 2008 R2 provides Transact-SQL statements to ensure that administrators can perform these tasks to manage the table partitions. SQL Server also provides data compression at the table row and page level...